Task: Transform-by-output-target-schema (source dataset: github-pipelines)

Your task is to create a data transformation pipeline in Python using pandas libraries.

Given Source Tables below, and a Target Schema provided by users that demonstrates how the desired output table should look like schematically, please write Python pandas code that can transform the Source Tables into an output table, that matches the schema/structure given by the Target Schema.  Please note that the data values in the Target Schema are intended to represent the format and layout of the output table, but may not exactly match the actual data generated from the Source Tables when the python code is run on the Source Tables.

Use operations such as merge, groupby, pivot, apply, or any appropriate python or pandas steps. Your code should save the resulting DataFrame to a CSV file named 'output.csv'. Ensure that the code is executable and can be run directly as is, in a Python environment with pandas installed.

Source Tables:


Table #1
Filename: source_0.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc              |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-----------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|:----------|---------:|:-----------------|
| 2016-04-30 18:14:47    |           298592 | Outlet 15 |                19 |                861066 |    751 | Iced Milk Tea          |     1 |    4.73 |       4.73 |        169984 |    27 | ADULT       | DINNER        | Drink       | Drink;Cold          | 4.73      |        1 | SOLO             |
| 2016-04-30 18:14:47    |           298592 | Outlet 15 |                19 |                861063 |    313 | HAM BO LO BUN          |     1 |    5.94 |       5.94 |        169984 |    27 | ADULT       | DINNER        | Side        | Fingerfood;Chicken  | 5.94      |        1 | SOLO             |
| 2016-04-30 18:14:47    |           298592 | Outlet 15 |                19 |                861065 |    705 | Kopi                   |     1 |    2.06 |       2.06 |        169984 |    27 | ADULT       | DINNER        | Drink       | Drink;Hot           | 2.06      |        1 | SOLO             |
| 2016-04-30 18:15:17    |           298593 | Outlet 22 |                 4 |                861077 |    767 | Iced Lychee Tea        |     1 |    6.67 |       6.67 |        167766 |    48 | MIDDLE      | DINNER        | Drink       | Drink;Cold          | 6.67      |        2 | COUPLE           |
| 2016-04-30 18:15:17    |           298593 | Outlet 22 |                 4 |                861074 |    769 | Iced Lemon Tea         |     1 |    5.94 |       0    |        167766 |    48 | MIDDLE      | DINNER        | Drink       | Drink;Cold          | 5.94      |        2 | COUPLE           |
| 2016-04-30 18:15:17    |           298593 | Outlet 22 |                 4 |                861075 |   1135 | Soup of the Day        |     1 |    0    |       0    |        167766 |    48 | MIDDLE      | DINNER        |             |                     |           |        2 | COUPLE           |
| 2016-04-30 18:15:17    |           298593 | Outlet 22 |                 4 |                861072 |     35 | BP Chicken Chop        |     1 |   12.73 |      12.73 |        167766 |    48 | MIDDLE      | DINNER        | Main        | Western;Chicken     | 12.73     |        2 | COUPLE           |
| 2016-04-30 18:15:17    |           298593 | Outlet 22 |                 4 |                861073 |     74 | Wanton Soup Noodle     |     1 |   10.79 |      10.79 |        167766 |    48 | MIDDLE      | DINNER        | Main        | Noodle;Pork;Seafood | 10.79     |        2 | COUPLE           |
| 2016-04-30 18:15:17    |           298593 | Outlet 22 |                 4 |                861076 |   1175 | Homemade Cold Beancurd |     1 |    9.58 |       9.58 |        167766 |    48 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold        | 19.15     |        2 | COUPLE           |
| 2016-04-30 18:36:59    |           298634 | Outlet 13 |                 9 |                861210 |    767 | Iced Lychee Tea        |     1 |    6.67 |       6.67 |         69711 |    38 | MIDDLE      | DINNER        | Drink       | Drink;Cold          | 6.67      |        1 | SOLO             |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146138 |     21 | Chicken Chop Cream Spag      |     1 |   14.42 |      14.42 |        182827 |    44 | MIDDLE      | LUNCH         | Main        | Spaghetti;Chicken   |     14.42 |        5 | GROUP            |
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146148 |    902 | Cent Egg Pork Por            |     1 |   10.3  |      10.3  |        182827 |    44 | MIDDLE      | LUNCH         | Main        | Porridge;Pork       |     10.3  |        5 | GROUP            |
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146142 |    401 | Siew Mai                     |     1 |    5.45 |       5.45 |        182827 |    44 | MIDDLE      | LUNCH         | Side        | Dimsum;Seafood;Pork |      5.45 |        5 | GROUP            |
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146147 |    820 | Minced Kai Lan W Silver Fish |     1 |   11.51 |      11.51 |        182827 |    44 | MIDDLE      | LUNCH         | Side        | Vegetable;Seafood   |     11.51 |        5 | GROUP            |
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146145 |    412 | Har Gao                      |     1 |    5.94 |       5.94 |        182827 |    44 | MIDDLE      | LUNCH         | Side        | Dimsum;Seafood      |      5.94 |        5 | GROUP            |
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146140 |     74 | Wanton Soup Noodle           |     1 |   10.79 |      10.79 |        182827 |    44 | MIDDLE      | LUNCH         | Main        | Noodle;Pork;Seafood |     10.79 |        5 | GROUP            |
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146141 |     78 | SPECIAL STIR FRIED BEE HOON  |     1 |   12.73 |      12.73 |        182827 |    44 | MIDDLE      | LUNCH         | Main        | Noodle;Pork;Seafood |     12.73 |        5 | GROUP            |
| 2016-07-17 14:01:29    |           397261 | Outlet 21 |                18 |               1146144 |    407 | Radish Cake                  |     1 |    5.94 |       5.94 |        182827 |    44 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork         |      5.94 |        5 | GROUP            |
| 2016-07-17 14:02:22    |           397267 | Outlet 11 |                27 |               1146168 |    632 | Fish Slice Muifan            |     1 |   12.73 |      12.73 |        179954 |    68 | SENIOR      | LUNCH         | Main        | Rice;Fish           |     12.73 |        2 | COUPLE           |
| 2016-07-17 14:02:22    |           397267 | Outlet 11 |                27 |               1146166 |   1175 | Homemade Cold Beancurd       |     1 |    9.58 |       9.58 |        179954 |    68 | SENIOR      | LUNCH         | Dessert     | Dessert;Cold        |     19.15 |        2 | COUPLE           |


Table #3
Filename: source_10.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|:----------|---------:|:-----------------|
| 2016-07-23 19:34:38    |           404547 | Outlet 8  |                22 |               1166477 |    753 | Iced Coffee-Tea              |     1 |    4.73 |       4.73 |         79807 |    28 | ADULT       | DINNER        | Drink       | Drink;Cold          | 4.73      |        3 | GROUP            |
| 2016-07-23 19:55:49    |           404594 | Outlet 15 |                19 |               1166635 |    765 | Fresh  Lime Juice            |     1 |    5.94 |       5.94 |         60904 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Cold          | 5.94      |        1 | SOLO             |
| 2016-07-23 19:55:49    |           404594 | Outlet 15 |                19 |               1166634 |    761 | Ice Milo Dinosaur            |     1 |    5.45 |       5.45 |         60904 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Cold          | 5.45      |        1 | SOLO             |
| 2016-07-23 19:55:49    |           404594 | Outlet 15 |                19 |               1166633 |     78 | SPECIAL STIR FRIED BEE HOON  |     1 |   12.73 |      12.73 |         60904 |    39 | MIDDLE      | DINNER        | Main        | Noodle;Pork;Seafood | 12.73     |        1 | SOLO             |
| 2016-07-23 19:59:51    |           404601 | Outlet 14 |                16 |               1166681 |    780 | Iced Grass Jelly             |     1 |    3.52 |       3.52 |         73108 |    39 | MIDDLE      | DINNER        |             |                     |           |        2 | COUPLE           |
| 2016-07-23 19:59:51    |           404601 | Outlet 14 |                16 |               1166679 |    127 | Borsch Soup                  |     1 |    5.94 |       5.94 |         73108 |    39 | MIDDLE      | DINNER        | Side        | Soup;Beef           | 5.94      |        2 | COUPLE           |
| 2016-07-23 19:59:51    |           404601 | Outlet 14 |                16 |               1166678 |   1210 | Chix Wing BP                 |     1 |    5.94 |       5.94 |         73108 |    39 | MIDDLE      | DINNER        | Side        | Fingerfood;Chicken  | 5.94      |        2 | COUPLE           |
| 2016-07-23 19:59:51    |           404601 | Outlet 14 |                16 |               1166677 |     78 | SPECIAL STIR FRIED BEE HOON  |     1 |   12.73 |      12.73 |         73108 |    39 | MIDDLE      | DINNER        | Main        | Noodle;Pork;Seafood | 12.73     |        2 | COUPLE           |
| 2016-07-23 19:59:51    |           404601 | Outlet 14 |                16 |               1166680 |    507 | Ham & Egg Soup Ndl           |     1 |    9.45 |       9.45 |         73108 |    39 | MIDDLE      | DINNER        | Main        | Noodlesoup;Pork     | 9.45      |        2 | COUPLE           |
| 2016-07-23 19:59:51    |           404601 | Outlet 14 |                16 |               1166683 |    859 | SOY MILK WITH GLUTINOUS BALL |     1 |    6.67 |       6.67 |         73108 |    39 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold        | 6.67      |        2 | COUPLE           |


Table #4
Filename: source_11.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|:----------|---------:|:-----------------|
| 2016-08-13 23:42:09    |           431469 | Outlet 7  |                10 |               1241896 | 769    | Iced Lemon Tea               |     1 |    5.94 |       0    |        166855 |    26 | ADULT       | DINNER        | Drink       | Drink;Cold         | 5.94      |        1 | SOLO             |
| 2016-08-13 23:42:09    |           431469 | Outlet 7  |                10 |               1241897 | 1135   | Soup of the Day              |     1 |    0    |       0    |        166855 |    26 | ADULT       | DINNER        |             |                    |           |        1 | SOLO             |
| 2016-08-13 23:42:09    |           431469 | Outlet 7  |                10 |               1241898 | 1175   | Homemade Cold Beancurd       |     1 |    9.58 |       9.58 |        166855 |    26 | ADULT       | DINNER        | Dessert     | Dessert;Cold       | 19.15     |        1 | SOLO             |
| 2016-08-14 00:12:36    |           431486 | Outlet 9  |                19 |               1241940 | 718    | Hot Honey with Lemon         |     2 |    4.73 |       9.46 |        176942 |    31 | ADULT       | SUPPER        | Drink       | Drink;Hot          | 4.73      |        2 | COUPLE           |
| 2016-08-14 00:12:36    |           431486 | Outlet 9  |                19 |               1241942 | 783    | Iced Coffee-Tea Float        |     1 |    8.36 |       8.36 |        176942 |    31 | ADULT       | SUPPER        | Drink       | Drink;Cold         | 8.36      |        2 | COUPLE           |
| 2016-08-14 00:12:36    |           431486 | Outlet 9  |                19 |               1241938 | 216B   | Chicken Papaya Soup Beehoon  |     1 |   13.94 |      13.94 |        176942 |    31 | ADULT       | SUPPER        | Main        | Noodlesoup;Chicken | 13.94     |        2 | COUPLE           |
| 2016-08-14 00:12:36    |           431486 | Outlet 9  |                19 |               1241944 | 820    | Minced Kai Lan W Silver Fish |     1 |   11.51 |      11.51 |        176942 |    31 | ADULT       | SUPPER        | Side        | Vegetable;Seafood  | 11.51     |        2 | COUPLE           |
| 2016-08-14 00:12:36    |           431486 | Outlet 9  |                19 |               1241936 | 34     | Fish & Chips                 |     1 |   13.94 |      13.94 |        176942 |    31 | ADULT       | SUPPER        | Main        | Western;Fish       | 13.94     |        2 | COUPLE           |
| 2016-08-14 00:12:36    |           431486 | Outlet 9  |                19 |               1241941 | 751    | Iced Milk Tea                |     1 |    4.73 |       4.73 |        176942 |    31 | ADULT       | SUPPER        | Drink       | Drink;Cold         | 4.73      |        2 | COUPLE           |
| 2016-08-14 00:39:51    |           431513 | Outlet 18 |                23 |               1242018 | 780    | Iced Grass Jelly             |     1 |    3.52 |       3.52 |         58292 |    31 | ADULT       | SUPPER        |             |                    |           |        2 | COUPLE           |


Table #5
Filename: source_12.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                       |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:--------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-09-27 12:26:36    |           484150 | Outlet 1  |                20 |               1386125 |    767 | Iced Lychee Tea                 |     1 |    6.67 |       6.67 |        189732 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         |      6.67 |        2 | COUPLE           |
| 2016-09-27 12:26:36    |           484150 | Outlet 1  |                20 |               1386127 |    820 | Minced Kai Lan W Silver Fish    |     1 |   11.51 |      11.51 |        189732 |    40 | MIDDLE      | LUNCH         | Side        | Vegetable;Seafood  |     11.51 |        2 | COUPLE           |
| 2016-09-27 13:01:47    |           484201 | Outlet 1  |                20 |               1386234 |    254 | SH Pork Chop Rice               |     1 |   13.94 |      13.94 |         78137 |    32 | ADULT       | LUNCH         | Main        | Rice;Pork          |     13.94 |        1 | SOLO             |
| 2016-09-27 13:01:47    |           484201 | Outlet 1  |                20 |               1386235 |    715 | Milk Tea                        |     1 |    4.24 |       4.24 |         78137 |    32 | ADULT       | LUNCH         | Drink       | Drink;Hot          |      4.24 |        1 | SOLO             |
| 2016-09-27 14:05:08    |           484338 | Outlet 19 |                 5 |               1386563 |   1108 | Chix Wing Japanese Sesame Sauce |     1 |    5.94 |       5.94 |         52748 |    34 | ADULT       | LUNCH         | Side        | Fingerfood;Chicken |      5.94 |        1 | SOLO             |
| 2016-09-27 14:05:08    |           484338 | Outlet 19 |                 5 |               1386562 |     45 | Chix Chop Bk Rice               |     1 |   15.15 |      15.15 |         52748 |    34 | ADULT       | LUNCH         | Main        | Bakedrice;Chicken  |     15.15 |        1 | SOLO             |
| 2016-09-27 14:05:08    |           484338 | Outlet 19 |                 5 |               1386566 |    758 | Iced Soy Milk                   |     1 |    4.73 |       4.73 |         52748 |    34 | ADULT       | LUNCH         | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-09-27 14:09:34    |           484345 | Outlet 13 |                 9 |               1386577 |     24 | SCALLOP CREAM SAUCE SPAGHETTI   |     1 |   17.58 |      17.58 |        188002 |    23 | ADULT       | LUNCH         | Main        | Spaghetti;Seafood  |     17.58 |        1 | SOLO             |
| 2016-09-27 14:09:34    |           484345 | Outlet 13 |                 9 |               1386580 |   1175 | Homemade Cold Beancurd          |     1 |    9.58 |       9.58 |        188002 |    23 | ADULT       | LUNCH         | Dessert     | Dessert;Cold       |     19.15 |        1 | SOLO             |
| 2016-09-27 14:09:34    |           484345 | Outlet 13 |                 9 |               1386581 |    412 | Har Gao                         |     1 |    5.94 |       5.94 |        188002 |    23 | ADULT       | LUNCH         | Side        | Dimsum;Seafood     |      5.94 |        1 | SOLO             |


Table #6
Filename: source_13.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-05-05 19:36:02    |           305777 | Outlet 3  |                 9 |                882311 | 414    | Chix Feet                   |     1 |    5.94 |       5.94 |        168909 |    33 | ADULT       | DINNER        | Side        | Dimsum;Chicken     |      5.94 |        2 | COUPLE           |
| 2016-05-05 19:36:02    |           305777 | Outlet 3  |                 9 |                882304 | 14     | BP Chix Spag                |     1 |   12.73 |      12.73 |        168909 |    33 | ADULT       | DINNER        | Main        | Spaghetti;Chicken  |     12.73 |        2 | COUPLE           |
| 2016-05-05 19:36:02    |           305777 | Outlet 3  |                 9 |                882306 | 254    | SH Pork Chop Rice           |     1 |   13.94 |      13.94 |        168909 |    33 | ADULT       | DINNER        | Main        | Rice;Pork          |     13.94 |        2 | COUPLE           |
| 2016-05-05 20:07:38    |           305856 | Outlet 18 |                23 |                882500 | 767    | Iced Lychee Tea             |     1 |    6.67 |       6.67 |        166757 |    28 | ADULT       | DINNER        | Drink       | Drink;Cold         |      6.67 |        1 | SOLO             |
| 2016-05-05 20:07:38    |           305856 | Outlet 18 |                23 |                882499 | 21     | Chicken Chop Cream Spag     |     1 |   43.27 |      43.27 |        166757 |    28 | ADULT       | DINNER        | Main        | Spaghetti;Chicken  |     14.42 |        1 | SOLO             |
| 2016-05-05 20:12:31    |           305871 | Outlet 11 |                27 |                882546 | 560    | Coffee-Tea Snow Ice         |     1 |    8.36 |       8.36 |        161647 |    26 | ADULT       | DINNER        | Dessert     | Dessert;Cold       |      8.36 |        1 | SOLO             |
| 2016-05-05 20:12:31    |           305871 | Outlet 11 |                27 |                882545 | 112    | F.Toast Ice Cream           |     1 |    7.88 |       7.88 |        161647 |    26 | ADULT       | DINNER        | Side        | Bread;Sweet        |     23.64 |        1 | SOLO             |
| 2016-05-05 20:26:55    |           305940 | Outlet 2  |                 3 |                882731 | 414    | Chix Feet                   |     1 |    5.94 |       5.94 |        165904 |    26 | ADULT       | DINNER        | Side        | Dimsum;Chicken     |      5.94 |        1 | SOLO             |
| 2016-05-05 20:26:55    |           305940 | Outlet 2  |                 3 |                882732 | 715    | Milk Tea                    |     1 |    4.24 |       4.24 |        165904 |    26 | ADULT       | DINNER        | Drink       | Drink;Hot          |      4.24 |        1 | SOLO             |
| 2016-05-05 20:26:55    |           305940 | Outlet 2  |                 3 |                882730 | 216B   | Chicken Papaya Soup Beehoon |     1 |   13.94 |      13.94 |        165904 |    26 | ADULT       | DINNER        | Main        | Noodlesoup;Chicken |     13.94 |        1 | SOLO             |


Table #7
Filename: source_14.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                            |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat              |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-------------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:----------------------|----------:|---------:|:-----------------|
| 2016-11-19 14:57:27    |           547235 | Outlet 2  |                 3 |               1569294 |    407 | Radish Cake                          |     1 |    5.94 |       5.94 |        160789 |    47 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork           |      5.94 |        3 | GROUP            |
| 2016-11-19 14:57:27    |           547235 | Outlet 2  |                 3 |               1569291 |     47 | Mush Bk Rice                         |     1 |   13.94 |      13.94 |        160789 |    47 | MIDDLE      | LUNCH         | Main        | Baked Rice;Vegetarian |     13.94 |        3 | GROUP            |
| 2016-11-19 14:57:27    |           547235 | Outlet 2  |                 3 |               1569293 |    294 | Seafood and Slice Pork Macaroni Soup |     1 |   10.3  |      10.3  |        160789 |    47 | MIDDLE      | LUNCH         | Main        | Soup;Seafood;Pork     |     10.3  |        3 | GROUP            |
| 2016-11-19 14:57:27    |           547235 | Outlet 2  |                 3 |               1569295 |    412 | Har Gao                              |     1 |    5.94 |       5.94 |        160789 |    47 | MIDDLE      | LUNCH         | Side        | Dimsum;Seafood        |      5.94 |        3 | GROUP            |
| 2016-11-19 14:57:27    |           547235 | Outlet 2  |                 3 |               1569298 |    781 | Lychee Ice-blended                   |     1 |    7.15 |       7.15 |        160789 |    47 | MIDDLE      | LUNCH         | Drink       | Drink;Cold            |      7.15 |        3 | GROUP            |
| 2016-11-19 14:57:27    |           547235 | Outlet 2  |                 3 |               1569296 |    753 | Iced Coffee-Tea                      |     1 |    4.73 |       4.73 |        160789 |    47 | MIDDLE      | LUNCH         | Drink       | Drink;Cold            |      4.73 |        3 | GROUP            |
| 2016-11-19 15:01:22    |           547246 | Outlet 21 |                18 |               1569334 |     14 | BP Chix Spag                         |     1 |   12.73 |      12.73 |         72471 |    28 | ADULT       | LUNCH         | Main        | Spaghetti;Chicken     |     12.73 |        2 | COUPLE           |
| 2016-11-19 15:01:22    |           547246 | Outlet 21 |                18 |               1569335 |     74 | Wanton Soup Noodle                   |     1 |   10.79 |      10.79 |         72471 |    28 | ADULT       | LUNCH         | Main        | Noodle;Pork;Seafood   |     10.79 |        2 | COUPLE           |
| 2016-11-19 15:01:22    |           547246 | Outlet 21 |                18 |               1569336 |    769 | Iced Lemon Tea                       |     1 |    5.94 |       5.94 |         72471 |    28 | ADULT       | LUNCH         | Drink       | Drink;Cold            |      5.94 |        2 | COUPLE           |
| 2016-11-19 15:41:03    |           547295 | Outlet 12 |                 5 |               1569489 |    751 | Iced Milk Tea                        |     1 |    4.73 |       4.73 |        174115 |    29 | ADULT       | LUNCH         | Drink       | Drink;Cold            |      4.73 |        1 | SOLO             |


Table #8
Filename: source_15.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                 |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:--------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-12-03 20:21:56    |           564906 | Outlet 6  |                22 |               1619682 | 751    | Iced Milk Tea             |     1 |    4.73 |       9.45 |        193448 |    44 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      4.73 |        3 | GROUP            |
| 2016-12-03 20:24:40    |           564922 | Outlet 21 |                18 |               1619753 | 701    | Chinese Tea               |     1 |    2.06 |       2.06 |        199199 |    31 | ADULT       | DINNER        | Drink       | Drink;Hot          |      2.06 |        1 | SOLO             |
| 2016-12-03 20:24:40    |           564922 | Outlet 21 |                18 |               1619751 | 62     | Seafood Sauteed HF        |     1 |   12.73 |      12.73 |        199199 |    31 | ADULT       | DINNER        | Main        | Noodle;Seafood     |     12.73 |        1 | SOLO             |
| 2016-12-03 20:24:40    |           564922 | Outlet 21 |                18 |               1619752 | 307    | Prawn Paste Chicken       |     1 |    8.36 |       8.36 |        199199 |    31 | ADULT       | DINNER        | Side        | Fingerfood;Chicken |      8.36 |        1 | SOLO             |
| 2016-12-03 20:24:40    |           564922 | Outlet 21 |                18 |               1619754 | 751    | Iced Milk Tea             |     1 |    4.73 |       4.73 |        199199 |    31 | ADULT       | DINNER        | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-12-03 20:27:34    |           564930 | Outlet 16 |                 3 |               1619780 | 43     | Pork Chop Bk Rice         |     1 |   15.15 |      15.15 |         63151 |    42 | MIDDLE      | DINNER        | Main        | Bakedrice;Pork     |     15.15 |        3 | GROUP            |
| 2016-12-03 20:27:34    |           564930 | Outlet 16 |                 3 |               1619781 | 68     | Fried Spare Ribs Bee Hoon |     1 |   13.94 |      13.94 |         63151 |    42 | MIDDLE      | DINNER        | Main        | Noodle;Pork        |     13.94 |        3 | GROUP            |
| 2016-12-03 20:27:34    |           564930 | Outlet 16 |                 3 |               1619783 | 718    | Hot Honey with Lemon      |     2 |    4.73 |       9.46 |         63151 |    42 | MIDDLE      | DINNER        | Drink       | Drink;Hot          |      4.73 |        3 | GROUP            |
| 2016-12-03 20:27:34    |           564930 | Outlet 16 |                 3 |               1619782 | 217B   | Fish Papaya Soup Beehoon  |     1 |   13.94 |      13.94 |         63151 |    42 | MIDDLE      | DINNER        | Main        | Noodlesoup;Fish    |     13.94 |        3 | GROUP            |
| 2016-12-03 20:38:47    |           564965 | Outlet 5  |                18 |               1619885 | 68     | Pork Ribs BH              |     1 |   13.94 |      13.94 |         51618 |    28 | ADULT       | DINNER        | Main        | Noodle;Pork        |     13.94 |        1 | SOLO             |


Table #9
Filename: source_16.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc            |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:---------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|----------:|---------:|:-----------------|
| 2016-02-18 21:31:45    |           229532 | Outlet 7  |                10 |                666782 |    751 | Iced Milk Tea        |     1 |    4.73 |       5.45 |        159307 |    21 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      4.73 |        1 | SOLO             |
| 2016-02-18 21:40:14    |           229540 | Outlet 15 |                19 |                666813 |    549 | Signature Fried Rice |     1 |   13.94 |      15.15 |        163422 |    52 | SENIOR      | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        1 | SOLO             |
| 2016-02-19 13:46:05    |           229799 | Outlet 12 |                 5 |                667384 |    751 | Iced Milk Tea        |     1 |    4.73 |      10.91 |        161445 |    26 | ADULT       | LUNCH         | Drink       | Drink;Cold                     |      4.73 |        1 | SOLO             |
| 2016-02-19 13:46:05    |           229799 | Outlet 12 |                 5 |                667382 |    549 | Signature Fried Rice |     1 |   13.94 |      30.3  |        161445 |    26 | ADULT       | LUNCH         | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        1 | SOLO             |
| 2016-02-19 14:11:13    |           229829 | Outlet 5  |                18 |                667468 |    549 | Signature Fried Rice |     1 |   13.94 |      15.15 |        156470 |    26 | ADULT       | LUNCH         | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        1 | SOLO             |
| 2016-02-19 18:36:03    |           230019 | Outlet 9  |                19 |                667881 |    751 | Iced Milk Tea        |     2 |    4.73 |      10.9  |        159640 |    46 | MIDDLE      | DINNER        | Drink       | Drink;Cold                     |      4.73 |        1 | SOLO             |
| 2016-02-19 19:49:38    |           230158 | Outlet 19 |                 5 |                668204 |      2 | Warm Water           |     1 |    0.73 |       0.73 |        158800 |    38 | MIDDLE      | DINNER        | Drink       | Drink;Hot                      |      0.73 |        1 | SOLO             |
| 2016-02-19 20:11:32    |           230230 | Outlet 6  |                22 |                668353 |      2 | Warm Water           |     1 |    0.73 |       0.73 |         61902 |    35 | ADULT       | DINNER        | Drink       | Drink;Hot                      |      0.73 |        1 | SOLO             |
| 2016-02-19 20:11:32    |           230230 | Outlet 6  |                22 |                668355 |    549 | Signature Fried Rice |     1 |   13.94 |      15.15 |         61902 |    35 | ADULT       | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        1 | SOLO             |
| 2016-02-19 22:47:35    |           230549 | Outlet 7  |                10 |                669193 |    751 | Iced Milk Tea        |     1 |    4.73 |       5.45 |         59498 |    20 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      4.73 |        1 | SOLO             |


Table #10
Filename: source_17.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                     |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-01-23 20:38:12    |           205553 | Outlet 2  |                 3 |                601949 |    753 | Iced Coffee-Tea               |     1 |    4.73 |       4.73 |         79842 |    65 | SENIOR      | DINNER        | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-01-23 20:38:12    |           205553 | Outlet 2  |                 3 |                601946 |   1201 | Seafood Ee Noodle             |     2 |   13.21 |      26.42 |         79842 |    65 | SENIOR      | DINNER        | Main        | Noodle;Seafood     |     13.21 |        1 | SOLO             |
| 2016-01-23 21:33:40    |           205701 | Outlet 5  |                18 |                602466 |    767 | Iced Lychee Tea               |     1 |    6.67 |       6.67 |         61035 |    38 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      6.67 |        1 | SOLO             |
| 2016-01-23 23:34:54    |           205851 | Outlet 14 |                16 |                602957 |     24 | SCALLOP CREAM SAUCE SPAGHETTI |     1 |   17.58 |      17.58 |         73286 |    29 | ADULT       | DINNER        | Main        | Spaghetti;Seafood  |     17.58 |        1 | SOLO             |
| 2016-01-23 23:34:54    |           205851 | Outlet 14 |                16 |                602959 |    791 | Iced Yuzu Tea                 |     1 |    6.67 |       6.67 |         73286 |    29 | ADULT       | DINNER        | Drink       | Drink;Cold         |      6.67 |        1 | SOLO             |
| 2016-01-23 23:34:54    |           205851 | Outlet 14 |                16 |                602958 |    315 | HONEY CHICKEN WING (5pcs)     |     1 |    7.15 |       7.15 |         73286 |    29 | ADULT       | DINNER        | Side        | Fingerfood;Chicken |      7.15 |        1 | SOLO             |
| 2016-01-24 00:20:36    |           205877 | Outlet 17 |                 5 |                603041 |    102 | Kaya Butter Bread             |     1 |    3.52 |       3.52 |         58920 |    32 | ADULT       | SUPPER        | Side        | Bread;Sweet        |      3.52 |        2 | COUPLE           |
| 2016-01-24 00:20:36    |           205877 | Outlet 17 |                 5 |                603043 |    717 | Hot Honey Green Tea           |     1 |    4.73 |       4.73 |         58920 |    32 | ADULT       | SUPPER        | Drink       | Drink;Hot          |      4.73 |        2 | COUPLE           |
| 2016-01-24 00:20:36    |           205877 | Outlet 17 |                 5 |                603042 |    705 | Kopi                          |     1 |    2.06 |       2.06 |         58920 |    32 | ADULT       | SUPPER        | Drink       | Drink;Hot          |      2.06 |        2 | COUPLE           |
| 2016-01-24 10:14:32    |           205929 | Outlet 1  |                20 |                603214 |    403 | Beancurd Skin Prawn Roll      |     1 |    6.67 |       6.67 |         59632 |    47 | MIDDLE      | BREAKFAST     | Side        | Dimsum;Pork        |      6.67 |        1 | SOLO             |


Table #11
Filename: source_18.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat          | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:------------------|:----------|---------:|:-----------------|
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903688 | 1135   | Soup of the Day         |     1 |    0    |       0    |        171950 |    50 | MIDDLE      | LUNCH         |             |                   |           |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903691 | 411    | Pan Fried Dumpling      |     1 |    7.88 |       7.88 |        171950 |    50 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork       | 7.88      |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903694 | 545    | Chicken Flos Fried Rice |     1 |   12.73 |      12.73 |        171950 |    50 | MIDDLE      | LUNCH         | Main        | Friedrice;Chicken | 12.73     |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903689 | 1136   | Fruit Jelly Pudding     |     1 |    9.58 |       9.58 |        171950 |    50 | MIDDLE      | LUNCH         | Dessert     | Dessert;Cold      | 9.58      |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903690 | 407    | Radish Cake             |     1 |    5.94 |       5.94 |        171950 |    50 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork       | 5.94      |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903686 | 45     | Chix Chop Bk Rice       |     1 |   15.15 |      15.15 |        171950 |    50 | MIDDLE      | LUNCH         | Main        | Bakedrice;Chicken | 15.15     |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903692 | 413    | SPRING ROLL             |     1 |    5.94 |       5.94 |        171950 |    50 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork       | 5.94      |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903693 | 414    | Chix Feet               |     1 |    5.94 |       5.94 |        171950 |    50 | MIDDLE      | LUNCH         | Side        | Dimsum;Chicken    | 5.94      |        3 | GROUP            |
| 2016-05-10 14:47:17    |           312880 | Outlet 15 |                19 |                903687 | 780    | Iced Grass Jelly        |     1 |    3.52 |       0    |        171950 |    50 | MIDDLE      | LUNCH         |             |                   |           |        3 | GROUP            |
| 2016-05-10 15:45:31    |           312912 | Outlet 3  |                 9 |                903787 | 759C   | Coke                    |     1 |    3.52 |       3.52 |        169020 |    29 | ADULT       | LUNCH         | Drink       | Drink;Cold        | 3.52      |        1 | SOLO             |


Table #12
Filename: source_19.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item     | item_desc            |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat         | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:---------|:---------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-----------------|:----------|---------:|:-----------------|
| 2016-09-22 11:33:10    |           478117 | Outlet 17 |                 5 |               1369571 | TAKEAWAY | TAKEAWAY             |     1 |    0    |       0    |        184536 |    38 | MIDDLE      | BREAKFAST     |             |                  |           |        1 | SOLO             |
| 2016-09-22 11:33:10    |           478117 | Outlet 17 |                 5 |               1369569 | 904      | Fish Slice Por       |     1 |   10.3  |      10.3  |        184536 |    38 | MIDDLE      | BREAKFAST     | Main        | Porridge;Fish    | 10.3      |        1 | SOLO             |
| 2016-09-22 12:46:18    |           478178 | Outlet 12 |                 5 |               1369685 | 903      | Sampan Congee        |     1 |   11.51 |      11.51 |        180817 |    32 | ADULT       | LUNCH         | Main        | Porridge;Seafood | 11.51     |        1 | SOLO             |
| 2016-09-22 12:46:18    |           478178 | Outlet 12 |                 5 |               1369684 | 759C     | Coke                 |     1 |    3.52 |       3.52 |        180817 |    32 | ADULT       | LUNCH         | Drink       | Drink;Cold       | 3.52      |        1 | SOLO             |
| 2016-09-22 12:49:00    |           478185 | Outlet 21 |                18 |               1369701 | 251      | Yao Ma Tei Chix Rice |     1 |   13.94 |      13.94 |        172989 |    35 | ADULT       | LUNCH         | Main        | Rice;Chicken     | 13.94     |        1 | SOLO             |
| 2016-09-22 12:49:00    |           478185 | Outlet 21 |                18 |               1369702 | 292      | Soft Boiled Eggs     |     1 |    3.52 |       3.52 |        172989 |    35 | ADULT       | LUNCH         | Side        | Bread            | 3.52      |        1 | SOLO             |
| 2016-09-22 12:49:00    |           478185 | Outlet 21 |                18 |               1369703 | 751      | Iced Milk Tea        |     1 |    4.73 |       4.73 |        172989 |    35 | ADULT       | LUNCH         | Drink       | Drink;Cold       | 4.73      |        1 | SOLO             |
| 2016-09-22 12:51:12    |           478189 | Outlet 9  |                19 |               1369707 | 251      | Yao Ma Tei Chix Rice |     1 |   13.94 |      13.94 |        186553 |    26 | ADULT       | LUNCH         | Main        | Rice;Chicken     | 13.94     |        3 | GROUP            |
| 2016-09-22 12:51:12    |           478189 | Outlet 9  |                19 |               1369708 | 414      | Chicken Feet         |     1 |    5.94 |       5.94 |        186553 |    26 | ADULT       | LUNCH         | Side        | Dimsum;Chicken   | 5.94      |        3 | GROUP            |
| 2016-09-22 12:51:12    |           478189 | Outlet 9  |                19 |               1369710 | 753      | Iced Coffee-Tea      |     1 |    4.73 |       4.73 |        186553 |    26 | ADULT       | LUNCH         | Drink       | Drink;Cold       | 4.73      |        3 | GROUP            |


Table #13
Filename: source_2.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item     | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:---------|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|:----------|---------:|:-----------------|
| 2016-09-16 18:34:38    |           471617 | Outlet 21 |                18 |               1351799 | 23       | Luncheon Mushrm Cream Spag  |     1 |   12.73 |      12.73 |        182910 |    42 | MIDDLE      | DINNER        | Main        | Spaghetti;Pork                 | 12.73     |        3 | GROUP            |
| 2016-09-16 18:34:38    |           471617 | Outlet 21 |                18 |               1351800 | 45       | Chix Chop Bk Rice           |     1 |   15.15 |      15.15 |        182910 |    42 | MIDDLE      | DINNER        | Main        | Bakedrice;Chicken              | 15.15     |        3 | GROUP            |
| 2016-09-16 18:34:38    |           471617 | Outlet 21 |                18 |               1351802 | TAKEAWAY | TAKEAWAY                    |     4 |    0    |       0    |        182910 |    42 | MIDDLE      | DINNER        |             |                                |           |        3 | GROUP            |
| 2016-09-16 18:43:03    |           471635 | Outlet 8  |                22 |               1351851 | 251      | Yao Ma Tei Chix Rice        |     1 |   13.94 |      13.94 |        169745 |    34 | ADULT       | DINNER        | Main        | Rice;Chicken                   | 13.94     |        2 | COUPLE           |
| 2016-09-16 18:43:03    |           471635 | Outlet 8  |                22 |               1351850 | 215B     | Pork Chop Bee Hoon          |     1 |   13.94 |      13.94 |        169745 |    34 | ADULT       | DINNER        | Main        | Noodle;Pork                    | 13.94     |        2 | COUPLE           |
| 2016-09-16 19:52:53    |           471837 | Outlet 18 |                23 |               1352344 | TAKEAWAY | TAKEAWAY                    |     1 |    0    |       0    |        163840 |    28 | ADULT       | DINNER        |             |                                |           |        1 | SOLO             |
| 2016-09-16 19:52:53    |           471837 | Outlet 18 |                23 |               1352343 | 549      | Signature Fried Rice        |     1 |   13.94 |      13.94 |        163840 |    28 | ADULT       | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken | 13.94     |        1 | SOLO             |
| 2016-09-16 19:58:10    |           471842 | Outlet 11 |                27 |               1352353 | 715      | Milk Tea                    |     1 |    4.24 |       4.24 |        156079 |    36 | MIDDLE      | DINNER        | Drink       | Drink;Hot                      | 4.24      |        1 | SOLO             |
| 2016-09-16 19:59:05    |           471847 | Outlet 23 |                19 |               1352358 | 552      | Mango Pomelo                |     1 |    8.36 |       8.36 |        176708 |    53 | SENIOR      | DINNER        | Dessert     | Dessert;Cold                   | 8.36      |        1 | SOLO             |
| 2016-09-16 19:59:05    |           471847 | Outlet 23 |                19 |               1352357 | 216B     | Chicken Papaya Soup Beehoon |     2 |   13.94 |      27.88 |        176708 |    53 | SENIOR      | DINNER        | Main        | Noodlesoup;Chicken             | 13.94     |        1 | SOLO             |


Table #14
Filename: source_20.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet   |   outlet_district |   transact_details_id |   item | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:---------|------------------:|----------------------:|-------:|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|:----------|---------:|:-----------------|
| 2016-05-28 20:17:02    |           335812 | Outlet 7 |                10 |                968555 |     62 | Seafood Egg Hor Fun          |     1 |   12.73 |      12.73 |        159234 |    55 | SENIOR      | DINNER        | Main        | Noodle;Seafood                 | 12.73     |        3 | GROUP            |
| 2016-05-28 20:17:02    |           335812 | Outlet 7 |                10 |                968557 |    715 | Milk Tea                     |     1 |    4.24 |       4.24 |        159234 |    55 | SENIOR      | DINNER        | Drink       | Drink;Hot                      | 4.24      |        3 | GROUP            |
| 2016-05-28 20:17:02    |           335812 | Outlet 7 |                10 |                968559 |    780 | Iced Grass Jelly             |     1 |    3.52 |       3.52 |        159234 |    55 | SENIOR      | DINNER        |             |                                |           |        3 | GROUP            |
| 2016-05-28 20:17:02    |           335812 | Outlet 7 |                10 |                968560 |    909 | Sliced Empress Congee        |     1 |   12    |      12    |        159234 |    55 | SENIOR      | DINNER        | Main        | Porridge;Seafood               | 12.0      |        3 | GROUP            |
| 2016-05-28 20:17:02    |           335812 | Outlet 7 |                10 |                968556 |    546 | Diced Pork Fried Rice        |     1 |   12.73 |      12.73 |        159234 |    55 | SENIOR      | DINNER        | Main        | Friedrice;Pork                 | 12.73     |        3 | GROUP            |
| 2016-05-28 20:17:02    |           335812 | Outlet 7 |                10 |                968558 |    758 | Iced Soy Milk                |     1 |    4.73 |       4.73 |        159234 |    55 | SENIOR      | DINNER        | Drink       | Drink;Cold                     | 4.73      |        3 | GROUP            |
| 2016-05-28 20:20:41    |           335827 | Outlet 8 |                22 |                968609 |    808 | Chicken Dry Curry Ramen      |     1 |   13.94 |      13.94 |        173879 |    38 | MIDDLE      | DINNER        | Main        | Noodle;Chicken                 | 13.94     |        5 | GROUP            |
| 2016-05-28 20:20:41    |           335827 | Outlet 8 |                22 |                968604 |     43 | Pork Chop Bk Rice            |     1 |   15.15 |      15.15 |        173879 |    38 | MIDDLE      | DINNER        | Main        | Bakedrice;Pork                 | 15.15     |        5 | GROUP            |
| 2016-05-28 20:20:41    |           335827 | Outlet 8 |                22 |                968605 |    549 | Signature Fried Rice         |     2 |   13.94 |      83.64 |        173879 |    38 | MIDDLE      | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken | 13.94     |        5 | GROUP            |
| 2016-05-28 20:20:41    |           335827 | Outlet 8 |                22 |                968610 |    859 | SOY MILK WITH GLUTINOUS BALL |     1 |    6.67 |       6.67 |        173879 |    38 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold                   | 6.67      |        5 | GROUP            |


Table #15
Filename: source_21.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-01-11 21:14:08    |           193999 | Outlet 22 |                 4 |                569990 |     34 | Fish & Chips                |     1 |   13.94 |      13.94 |        155386 |    31 | ADULT       | DINNER        | Main        | Western;Fish        |     13.94 |        1 | SOLO             |
| 2016-01-11 21:14:08    |           193999 | Outlet 22 |                 4 |                569992 |    758 | Iced Soy Milk               |     1 |    4.73 |       4.73 |        155386 |    31 | ADULT       | DINNER        | Drink       | Drink;Cold          |      4.73 |        1 | SOLO             |
| 2016-01-12 11:39:22    |           194118 | Outlet 1  |                20 |                570305 |     78 | SPECIAL STIR FRIED BEE HOON |     1 |   12.73 |      12.73 |         77167 |    78 | SENIOR      | BREAKFAST     | Main        | Noodle;Pork;Seafood |     12.73 |        1 | SOLO             |
| 2016-01-12 11:39:22    |           194118 | Outlet 1  |                20 |                570308 |    713 | Hot Coffee-Tea              |     1 |    4.24 |       4.24 |         77167 |    78 | SENIOR      | BREAKFAST     | Drink       | Drink;Hot           |      4.24 |        1 | SOLO             |
| 2016-01-12 14:14:04    |           194331 | Outlet 12 |                 5 |                570850 |    546 | Diced Pork Fried Rice       |     2 |   12.73 |      25.46 |         57906 |    34 | ADULT       | LUNCH         | Main        | Friedrice;Pork      |     12.73 |        1 | SOLO             |
| 2016-01-12 19:45:27    |           194572 | Outlet 5  |                18 |                571376 |    751 | Iced Milk Tea               |     1 |    4.73 |       4.73 |         72143 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Cold          |      4.73 |        2 | COUPLE           |
| 2016-01-12 19:45:27    |           194572 | Outlet 5  |                18 |                571377 |    753 | Iced Coffee-Tea             |     1 |    4.73 |       4.73 |         72143 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Cold          |      4.73 |        2 | COUPLE           |
| 2016-01-12 20:22:03    |           194653 | Outlet 2  |                 3 |                571613 |    413 | SPRING ROLL                 |     1 |    5.94 |       5.94 |         63033 |    35 | ADULT       | DINNER        | Side        | Dimsum;Pork         |      5.94 |        1 | SOLO             |
| 2016-01-12 20:22:03    |           194653 | Outlet 2  |                 3 |                571614 |    552 | Mango Pomelo                |     1 |    8.36 |       8.36 |         63033 |    35 | ADULT       | DINNER        | Dessert     | Dessert;Cold        |      8.36 |        1 | SOLO             |
| 2016-01-12 20:22:03    |           194653 | Outlet 2  |                 3 |                571611 |     21 | Chicken Chop Cream Spag     |     1 |   14.42 |      14.42 |         63033 |    35 | ADULT       | DINNER        | Main        | Spaghetti;Chicken   |     14.42 |        1 | SOLO             |


Table #16
Filename: source_22.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                         |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-10-24 19:26:47    |           516439 | Outlet 12 |                 5 |               1478716 |    758 | Iced Soy Milk                     |     1 |    4.73 |       4.73 |        188350 |    34 | ADULT       | DINNER        | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-10-24 19:26:47    |           516439 | Outlet 12 |                 5 |               1478713 |     21 | Chicken Chop Cream Spag           |     1 |   14.42 |      14.42 |        188350 |    34 | ADULT       | DINNER        | Main        | Spaghetti;Chicken  |     14.42 |        1 | SOLO             |
| 2016-10-24 19:26:47    |           516439 | Outlet 12 |                 5 |               1478714 |    126 | L.Meat'N'Egg S'wich               |     1 |    4.73 |       4.73 |        188350 |    34 | ADULT       | DINNER        | Side        | Bread;Savoury      |      4.73 |        1 | SOLO             |
| 2016-10-24 19:26:47    |           516439 | Outlet 12 |                 5 |               1478715 |    312 | Chicken with Seaweed              |     1 |    7.15 |       7.15 |        188350 |    34 | ADULT       | DINNER        | Side        | Fingerfood;Chicken |      7.15 |        1 | SOLO             |
| 2016-10-24 19:33:59    |           516461 | Outlet 21 |                18 |               1478799 |    509 | Braised Beef Brisket Soup Noodles |     1 |   11.88 |      11.88 |         64532 |    49 | MIDDLE      | DINNER        | Main        | Noodlesoup;Beef    |     11.88 |        2 | COUPLE           |
| 2016-10-24 19:33:59    |           516461 | Outlet 21 |                18 |               1478800 |    718 | Hot Honey with Lemon              |     1 |    4.73 |       4.73 |         64532 |    49 | MIDDLE      | DINNER        | Drink       | Drink;Hot          |      4.73 |        2 | COUPLE           |
| 2016-10-24 19:33:59    |           516461 | Outlet 21 |                18 |               1478801 |    791 | Iced Yuzu Tea                     |     1 |    6.67 |       6.67 |         64532 |    49 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      6.67 |        2 | COUPLE           |
| 2016-10-24 19:33:59    |           516461 | Outlet 21 |                18 |               1478796 |    411 | Pan Fried Dumpling                |     1 |    7.88 |       7.88 |         64532 |    49 | MIDDLE      | DINNER        | Side        | Dimsum;Pork        |      7.88 |        2 | COUPLE           |
| 2016-10-24 19:33:59    |           516461 | Outlet 21 |                18 |               1478798 |    503 | Spy P.Dices Soup Ndl              |     1 |    9.45 |       9.45 |         64532 |    49 | MIDDLE      | DINNER        | Main        | Noodlesoup;Pork    |      9.45 |        2 | COUPLE           |
| 2016-10-24 19:33:59    |           516461 | Outlet 21 |                18 |               1478797 |    414 | Chix Feet                         |     1 |    5.94 |       5.94 |         64532 |    49 | MIDDLE      | DINNER        | Side        | Dimsum;Chicken     |      5.94 |        2 | COUPLE           |


Table #17
Filename: source_23.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat          |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:------------------|----------:|---------:|:-----------------|
| 2016-12-12 20:09:38    |           576840 | Outlet 12 |                 5 |               1653563 | 943    | WHITE RICE              |     1 |    1.82 |       1.82 |         57083 |    46 | MIDDLE      | DINNER        | Side        | Addons;Vegetarian |      1.82 |        1 | SOLO             |
| 2016-12-12 20:13:05    |           576854 | Outlet 15 |                19 |               1653582 | 414    | Chix Feet               |     1 |    5.94 |       5.94 |        203731 |    48 | MIDDLE      | DINNER        | Side        | Dimsum;Chicken    |      5.94 |        1 | SOLO             |
| 2016-12-12 20:13:05    |           576854 | Outlet 15 |                19 |               1653583 | 751    | Iced Milk Tea           |     1 |    4.73 |      14.18 |        203731 |    48 | MIDDLE      | DINNER        | Drink       | Drink;Cold        |      4.73 |        1 | SOLO             |
| 2016-12-12 20:14:50    |           576858 | Outlet 2  |                 3 |               1653604 | 701    | Chinese Tea             |     2 |    2.06 |       4.12 |         67448 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Hot         |      2.06 |        1 | SOLO             |
| 2016-12-12 20:14:50    |           576858 | Outlet 2  |                 3 |               1653603 | 546    | Diced Pork Fried Rice   |     1 |   12.73 |      12.73 |         67448 |    39 | MIDDLE      | DINNER        | Main        | Friedrice;Pork    |     12.73 |        1 | SOLO             |
| 2016-12-12 20:16:07    |           576866 | Outlet 1  |                20 |               1653631 | 753    | Iced Coffee-Tea         |     1 |    4.73 |       4.73 |        198917 |    35 | ADULT       | DINNER        | Drink       | Drink;Cold        |      4.73 |        1 | SOLO             |
| 2016-12-12 20:16:07    |           576866 | Outlet 1  |                20 |               1653630 | 21     | Chicken Chop Cream Spag |     1 |   14.42 |      14.42 |        198917 |    35 | ADULT       | DINNER        | Main        | Spaghetti;Chicken |     14.42 |        1 | SOLO             |
| 2016-12-12 20:20:33    |           576879 | Outlet 5  |                18 |               1653671 | 715    | Milk Tea                |     2 |    4.24 |       8.48 |        189522 |    48 | MIDDLE      | DINNER        | Drink       | Drink;Hot         |      4.24 |        2 | COUPLE           |
| 2016-12-12 20:20:33    |           576879 | Outlet 5  |                18 |               1653670 | 215A   | Pork Chop Noodle        |     1 |   13.94 |      13.94 |        189522 |    48 | MIDDLE      | DINNER        | Main        | Noodle;Pork       |     13.94 |        2 | COUPLE           |
| 2016-12-12 20:20:33    |           576879 | Outlet 5  |                18 |               1653669 | 11     | Chs Bk Pork Chop Spag   |     2 |   14.42 |      28.84 |        189522 |    48 | MIDDLE      | DINNER        | Main        | Spaghetti;Chicken |     14.42 |        2 | COUPLE           |


Table #18
Filename: source_24.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|----------:|---------:|:-----------------|
| 2016-04-23 19:38:50    |           291421 | Outlet 11 |                27 |                840923 |   1137 | Chix Wing Nachos Cheese |     1 |    5.94 |       5.94 |        165062 |    40 | MIDDLE      | DINNER        | Side        | Fingerfood;Chicken             |      5.94 |        3 | GROUP            |
| 2016-04-23 19:38:50    |           291421 | Outlet 11 |                27 |                840926 |    776 | Watermelon Ice          |     1 |    7.15 |       7.15 |        165062 |    40 | MIDDLE      | DINNER        | Drink       | Drink;Cold                     |      7.15 |        3 | GROUP            |
| 2016-04-23 19:47:42    |           291449 | Outlet 3  |                 9 |                841021 |    776 | Watermelon Ice          |     1 |    7.15 |       7.15 |        168685 |    28 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      7.15 |        1 | SOLO             |
| 2016-04-23 20:07:18    |           291496 | Outlet 21 |                18 |                841159 |    556 | Watermelon 'N' Jelly    |     1 |    7.88 |       7.88 |         63595 |    48 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold                   |      7.88 |        2 | COUPLE           |
| 2016-04-23 20:07:18    |           291496 | Outlet 21 |                18 |                841158 |    552 | Mango Pomelo            |     1 |    8.36 |       8.36 |         63595 |    48 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold                   |      8.36 |        2 | COUPLE           |
| 2016-04-23 20:07:18    |           291496 | Outlet 21 |                18 |                841157 |    549 | Signature Fried Rice    |     1 |   13.94 |      13.94 |         63595 |    48 | MIDDLE      | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        2 | COUPLE           |
| 2016-04-23 20:07:18    |           291496 | Outlet 21 |                18 |                841160 |    751 | Iced Milk Tea           |     1 |    4.73 |       4.73 |         63595 |    48 | MIDDLE      | DINNER        | Drink       | Drink;Cold                     |      4.73 |        2 | COUPLE           |
| 2016-04-23 20:07:18    |           291496 | Outlet 21 |                18 |                841156 |     62 | Seafood Sauteed HF      |     1 |   12.73 |      12.73 |         63595 |    48 | MIDDLE      | DINNER        | Main        | Noodle;Seafood                 |     12.73 |        2 | COUPLE           |
| 2016-04-23 20:17:34    |           291516 | Outlet 18 |                23 |                841220 |    781 | Lychee Ice-blended      |     1 |    7.15 |       7.15 |        164013 |    27 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      7.15 |        3 | GROUP            |
| 2016-04-23 20:17:34    |           291516 | Outlet 18 |                23 |                841217 |    401 | Siew Mai                |     1 |    5.45 |       5.45 |        164013 |    27 | ADULT       | DINNER        | Side        | Dimsum;Seafood;Pork            |      5.45 |        3 | GROUP            |


Table #19
Filename: source_25.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                          |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-----------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721318 |    767 | Iced Lychee Tea                    |     4 |   13.33 |      53.32 |        162553 |    42 | MIDDLE      | DINNER        | Drink       | Drink;Cold          |      6.67 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721320 |    776 | Watermelon Ice-Blended             |     1 |    7.15 |       7.15 |        162553 |    42 | MIDDLE      | DINNER        | Drink       | Drink;Cold          |      7.15 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721316 |    758 | Iced Soy Milk                      |     2 |    9.45 |      18.9  |        162553 |    42 | MIDDLE      | DINNER        | Drink       | Drink;Cold          |      4.73 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721308 |    401 | Siew Mai                           |     1 |    5.45 |       5.45 |        162553 |    42 | MIDDLE      | DINNER        | Side        | Dimsum;Seafood;Pork |      5.45 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721310 |    412 | Har Gao                            |     1 |    5.94 |       5.94 |        162553 |    42 | MIDDLE      | DINNER        | Side        | Dimsum;Seafood      |      5.94 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721321 |    797 | RAINBOW SPRITE                     |     2 |    5.94 |      11.88 |        162553 |    42 | MIDDLE      | DINNER        | Drink       | Drink;Cold          |      5.94 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721306 |    302 | Deep-fried Prawns with Mango sauce |     1 |   11.51 |      11.51 |        162553 |    42 | MIDDLE      | DINNER        | Side        | Fingerfood;Seafood  |     11.51 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721312 |    509 | Braised Beef Brisket Soup Noodles  |     2 |   23.76 |      47.52 |        162553 |    42 | MIDDLE      | DINNER        | Main        | Noodlesoup;Beef     |     11.88 |        6 | GROUP            |
| 2016-03-11 20:46:09    |           249278 | Outlet 17 |                 5 |                721305 |    112 | F.Toast Ice Cream                  |     1 |    7.88 |       7.88 |        162553 |    42 | MIDDLE      | DINNER        | Side        | Bread;Sweet         |     23.64 |        6 | GROUP            |
| 2016-03-11 20:50:35    |           249293 | Outlet 21 |                18 |                721373 |    808 | Chicken Dry Curry Ramen            |     1 |   13.94 |      13.94 |         65746 |    55 | SENIOR      | DINNER        | Main        | Noodle;Chicken      |     13.94 |        1 | SOLO             |


Table #20
Filename: source_26.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                         |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-07-11 13:14:29    |           390472 | Outlet 22 |                 4 |               1127449 |    709 | Teh                               |     2 |    2.06 |       4.12 |        170991 |    49 | MIDDLE      | LUNCH         | Drink       | Drink;Hot           |      2.06 |        2 | COUPLE           |
| 2016-07-11 13:14:29    |           390472 | Outlet 22 |                 4 |               1127447 |     14 | BP Chicken Chop Spag              |     1 |   12.73 |      12.73 |        170991 |    49 | MIDDLE      | LUNCH         | Main        | Spaghetti;Chicken   |     12.73 |        2 | COUPLE           |
| 2016-07-11 13:23:42    |           390493 | Outlet 8  |                22 |               1127488 |    902 | Cent Egg Pork Por                 |     1 |   10.3  |      10.3  |        167273 |    36 | MIDDLE      | LUNCH         | Main        | Porridge;Pork       |     10.3  |        1 | SOLO             |
| 2016-07-11 13:23:42    |           390493 | Outlet 8  |                22 |               1127484 |   1232 | Fried Wanton 3pcs                 |     3 |    0    |       0    |        167273 |    36 | MIDDLE      | LUNCH         | Side        | Fingerfood;Seafood  |      1.21 |        1 | SOLO             |
| 2016-07-11 13:55:15    |           390529 | Outlet 12 |                 5 |               1127594 |    720 | Yuzu Tea                          |     2 |    3.88 |       7.76 |        171565 |    43 | MIDDLE      | LUNCH         | Drink       | Drink;Hot           |      3.88 |        1 | SOLO             |
| 2016-07-11 14:00:17    |           390531 | Outlet 21 |                18 |               1127604 |    509 | Braised Beef Brisket Soup Noodles |     1 |   11.88 |      11.88 |        182772 |    34 | ADULT       | LUNCH         | Main        | Noodlesoup;Beef     |     11.88 |        3 | GROUP            |
| 2016-07-11 14:00:17    |           390531 | Outlet 21 |                18 |               1127601 |    129 | Wanton Soup                       |     1 |    7.15 |       7.15 |        182772 |    34 | ADULT       | LUNCH         | Side        | Soup;Pork;Seafood   |      7.15 |        3 | GROUP            |
| 2016-07-11 14:00:17    |           390531 | Outlet 21 |                18 |               1127599 |     35 | BP Chix Chop & Fries              |     1 |   12.73 |      12.73 |        182772 |    34 | ADULT       | LUNCH         | Main        | Western;Chicken     |     12.73 |        3 | GROUP            |
| 2016-07-11 14:00:17    |           390531 | Outlet 21 |                18 |               1127605 |    751 | Iced Milk Tea                     |     1 |    4.73 |       4.73 |        182772 |    34 | ADULT       | LUNCH         | Drink       | Drink;Cold          |      4.73 |        3 | GROUP            |
| 2016-07-11 14:00:17    |           390531 | Outlet 21 |                18 |               1127602 |    401 | Siew Mai                          |     2 |    5.45 |      10.9  |        182772 |    34 | ADULT       | LUNCH         | Side        | Dimsum;Seafood;Pork |      5.45 |        3 | GROUP            |


Table #21
Filename: source_27.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat              |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:----------------------|----------:|---------:|:-----------------|
| 2016-12-18 12:07:06    |           583505 | Outlet 17 |                 5 |               1672470 |    407 | Radish Cake             |     1 |    5.94 |       5.94 |         58594 |    58 | SENIOR      | LUNCH         | Side        | Dimsum;Pork           |      5.94 |        1 | SOLO             |
| 2016-12-18 12:07:06    |           583505 | Outlet 17 |                 5 |               1672471 |    751 | Iced Milk Tea           |     1 |    4.73 |       4.73 |         58594 |    58 | SENIOR      | LUNCH         | Drink       | Drink;Cold            |      4.73 |        1 | SOLO             |
| 2016-12-18 12:18:43    |           583529 | Outlet 2  |                 3 |               1672528 |    713 | Hot Coffee-Tea          |     1 |    4.24 |       4.24 |        200276 |    38 | MIDDLE      | LUNCH         | Drink       | Drink;Hot             |      4.24 |        2 | COUPLE           |
| 2016-12-18 12:18:43    |           583529 | Outlet 2  |                 3 |               1672527 |    704 | Fresh Soy Milk          |     1 |    3.52 |       3.52 |        200276 |    38 | MIDDLE      | LUNCH         | Drink       | Drink;Hot             |      3.52 |        2 | COUPLE           |
| 2016-12-18 12:18:43    |           583529 | Outlet 2  |                 3 |               1672525 |     47 | Mush Bk Rice            |     2 |   27.88 |      55.76 |        200276 |    38 | MIDDLE      | LUNCH         | Main        | Baked Rice;Vegetarian |     13.94 |        2 | COUPLE           |
| 2016-12-18 12:18:43    |           583529 | Outlet 2  |                 3 |               1672524 |     22 | Mushroom Cream Spag     |     3 |   12    |      36    |        200276 |    38 | MIDDLE      | LUNCH         | Main        | Spaghetti;Vegetarian  |     12    |        2 | COUPLE           |
| 2016-12-18 12:31:27    |           583569 | Outlet 13 |                 9 |               1672681 |     67 | Signature Fried Noodles |     2 |   13.94 |      27.88 |        187084 |    40 | MIDDLE      | LUNCH         | Main        | Noodle;Pork           |     13.94 |        4 | GROUP            |
| 2016-12-18 12:31:27    |           583569 | Outlet 13 |                 9 |               1672680 |     62 | Seafood Sauteed HF      |     1 |   12.73 |      12.73 |        187084 |    40 | MIDDLE      | LUNCH         | Main        | Noodle;Seafood        |     12.73 |        4 | GROUP            |
| 2016-12-18 12:31:27    |           583569 | Outlet 13 |                 9 |               1672677 |      2 | Warm Water              |     1 |    0.73 |       0.73 |        187084 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Hot             |      0.73 |        4 | GROUP            |
| 2016-12-18 12:31:27    |           583569 | Outlet 13 |                 9 |               1672683 |    705 | Kopi                    |     1 |    2.06 |       2.06 |        187084 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Hot             |      2.06 |        4 | GROUP            |


Table #22
Filename: source_28.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat             |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:---------------------|----------:|---------:|:-----------------|
| 2016-10-14 19:37:45    |           503335 | Outlet 7  |                10 |               1440736 |    909 | Sliced Empress Congee        |     1 |   12    |      12    |        172075 |    43 | MIDDLE      | DINNER        | Main        | Porridge;Seafood     |     12    |        2 | COUPLE           |
| 2016-10-14 19:37:45    |           503335 | Outlet 7  |                10 |               1440734 |    715 | Milk Tea                     |     1 |    4.24 |       4.24 |        172075 |    43 | MIDDLE      | DINNER        | Drink       | Drink;Hot            |      4.24 |        2 | COUPLE           |
| 2016-10-14 19:37:45    |           503335 | Outlet 7  |                10 |               1440735 |    820 | Minced Kai Lan W Silver Fish |     1 |   11.51 |      11.51 |        172075 |    43 | MIDDLE      | DINNER        | Side        | Vegetable;Seafood    |     11.51 |        2 | COUPLE           |
| 2016-10-14 19:37:45    |           503335 | Outlet 7  |                10 |               1440732 |    401 | Siew Mai                     |     1 |    5.45 |       5.45 |        172075 |    43 | MIDDLE      | DINNER        | Side        | Dimsum;Seafood;Pork  |      5.45 |        2 | COUPLE           |
| 2016-10-14 19:46:47    |           503366 | Outlet 5  |                18 |               1440817 |    808 | Chicken Dry Curry Ramen      |     1 |   13.94 |      13.94 |        163570 |    20 | ADULT       | DINNER        | Main        | Noodle;Chicken       |     13.94 |        3 | GROUP            |
| 2016-10-14 19:46:47    |           503366 | Outlet 5  |                18 |               1440815 |     22 | Mushroom Cream Spag          |     1 |   12    |      12    |        163570 |    20 | ADULT       | DINNER        | Main        | Spaghetti;Vegetarian |     12    |        3 | GROUP            |
| 2016-10-14 19:46:47    |           503366 | Outlet 5  |                18 |               1440816 |     61 | CRISPY PRAWN NOODLE          |     1 |   16.36 |      16.36 |        163570 |    20 | ADULT       | DINNER        | Main        | Noodle;Seafood       |     16.36 |        3 | GROUP            |
| 2016-10-14 19:46:47    |           503366 | Outlet 5  |                18 |               1440818 |    854 | Sesame Cream Glutinous Ball  |     1 |    6.67 |       6.67 |        163570 |    20 | ADULT       | DINNER        | Dessert     | Dessert;Cold         |      6.67 |        3 | GROUP            |
| 2016-10-14 19:46:47    |           503366 | Outlet 5  |                18 |               1440814 |      2 | Warm Water                   |     2 |    0.73 |       1.46 |        163570 |    20 | ADULT       | DINNER        | Drink       | Drink;Hot            |      0.73 |        3 | GROUP            |
| 2016-10-14 20:09:25    |           503453 | Outlet 15 |                19 |               1441067 |     66 | Fish Egg Sauteed HF          |     1 |   12.73 |      12.73 |        169970 |    33 | ADULT       | DINNER        | Main        | Noodle;Fish          |     12.73 |        2 | COUPLE           |


Table #23
Filename: source_29.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                                |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-----------------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-04-07 12:57:55    |           275178 | Outlet 13 |                 9 |                795010 |    418 | BBQ Pork Bun                             |     1 |    5.45 |       5.45 |        163200 |    41 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork        |      5.45 |        2 | COUPLE           |
| 2016-04-07 12:57:55    |           275178 | Outlet 13 |                 9 |                795012 |    509 | Braised Beef Brisket Soup Noodles        |     1 |   11.88 |      11.88 |        163200 |    41 | MIDDLE      | LUNCH         | Main        | Noodlesoup;Beef    |     11.88 |        2 | COUPLE           |
| 2016-04-07 12:57:55    |           275178 | Outlet 13 |                 9 |                795004 |   1110 | Chix Wing Home-made Sour 'N' Spicy Powde |     1 |    5.94 |       5.94 |        163200 |    41 | MIDDLE      | LUNCH         | Side        | Fingerfood;Chicken |      5.94 |        2 | COUPLE           |
| 2016-04-07 12:57:55    |           275178 | Outlet 13 |                 9 |                795016 |    818 | Belacan 4 S.Bean                         |     1 |   11.51 |      11.51 |        163200 |    41 | MIDDLE      | LUNCH         | Side        | Vegetable;Seafood  |     11.51 |        2 | COUPLE           |
| 2016-04-07 12:57:55    |           275178 | Outlet 13 |                 9 |                795009 |    414 | Chix Feet                                |     1 |    5.94 |       5.94 |        163200 |    41 | MIDDLE      | LUNCH         | Side        | Dimsum;Chicken     |      5.94 |        2 | COUPLE           |
| 2016-04-07 12:57:55    |           275178 | Outlet 13 |                 9 |                795013 |    701 | Chinese Tea                              |     1 |    2.06 |       2.06 |        163200 |    41 | MIDDLE      | LUNCH         | Drink       | Drink;Hot          |      2.06 |        2 | COUPLE           |
| 2016-04-07 12:57:55    |           275178 | Outlet 13 |                 9 |                795005 |   1216 | Chicken Hot Pot Rice                     |     1 |   13.21 |      13.21 |        163200 |    41 | MIDDLE      | LUNCH         | Main        | Rice;Chicken       |     13.21 |        2 | COUPLE           |
| 2016-04-07 12:59:57    |           275185 | Outlet 9  |                19 |                795037 |    411 | Pan Fried Dumpling                       |     1 |    7.88 |       7.88 |        162314 |    40 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork        |      7.88 |        1 | SOLO             |
| 2016-04-07 12:59:57    |           275185 | Outlet 9  |                19 |                795038 |    753 | Iced Coffee-Tea                          |     1 |   18.91 |      18.91 |        162314 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-04-07 12:59:57    |           275185 | Outlet 9  |                19 |                795036 |     68 | Fried Spare Ribs Bee Hoon                |     1 |   13.94 |      13.94 |        162314 |    40 | MIDDLE      | LUNCH         | Main        | Noodle;Pork        |     13.94 |        1 | SOLO             |


Table #24
Filename: source_3.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-09-10 14:06:09    |           464629 | Outlet 1  |                20 |               1332179 |    412 | Har Gao                     |     1 |    5.94 |       5.94 |        168566 |    40 | MIDDLE      | LUNCH         | Side        | Dimsum;Seafood     |      5.94 |        3 | GROUP            |
| 2016-09-10 14:06:40    |           464630 | Outlet 17 |                 5 |               1332183 |    254 | Pork Chop Frag Rice         |     1 |   13.94 |      13.94 |        184548 |    43 | MIDDLE      | LUNCH         | Main        | Rice;Pork          |     13.94 |        1 | SOLO             |
| 2016-09-10 14:14:00    |           464648 | Outlet 8  |                22 |               1332240 |    797 | RAINBOW SPRITE              |     1 |    5.94 |       5.94 |         60359 |    41 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         |      5.94 |        1 | SOLO             |
| 2016-09-10 14:14:00    |           464648 | Outlet 8  |                22 |               1332239 |   1109 | Chix Wing Honey Sweet Sauce |     1 |    5.94 |       5.94 |         60359 |    41 | MIDDLE      | LUNCH         | Side        | Fingerfood;Chicken |      5.94 |        1 | SOLO             |
| 2016-09-10 14:14:00    |           464648 | Outlet 8  |                22 |               1332241 |    909 | Sliced Empress Congee       |     1 |   12    |      12    |         60359 |    41 | MIDDLE      | LUNCH         | Main        | Porridge;Seafood   |     12    |        1 | SOLO             |
| 2016-09-10 14:18:40    |           464653 | Outlet 20 |                19 |               1332247 |    548 | Sambal Seafood Fried Rice   |     1 |   12.73 |      12.73 |        175230 |    38 | MIDDLE      | LUNCH         | Main        | Friedrice;Seafood  |     12.73 |        4 | GROUP            |
| 2016-09-10 14:18:40    |           464653 | Outlet 20 |                19 |               1332243 |     21 | Chicken Chop Cream Spag     |     1 |   14.42 |      14.42 |        175230 |    38 | MIDDLE      | LUNCH         | Main        | Spaghetti;Chicken  |     14.42 |        4 | GROUP            |
| 2016-09-10 14:18:40    |           464653 | Outlet 20 |                19 |               1332246 |    545 | Chicken Flos Fried Rice     |     1 |   12.73 |      12.73 |        175230 |    38 | MIDDLE      | LUNCH         | Main        | Friedrice;Chicken  |     12.73 |        4 | GROUP            |
| 2016-09-10 14:18:40    |           464653 | Outlet 20 |                19 |               1332248 |    701 | Chinese Tea                 |     1 |    2.06 |       2.06 |        175230 |    38 | MIDDLE      | LUNCH         | Drink       | Drink;Hot          |      2.06 |        4 | GROUP            |
| 2016-09-10 14:18:40    |           464653 | Outlet 20 |                19 |               1332242 |      2 | Warm Water                  |     1 |    0.73 |       0.73 |        175230 |    38 | MIDDLE      | LUNCH         | Drink       | Drink;Hot          |      0.73 |        4 | GROUP            |


Table #25
Filename: source_30.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                          |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-----------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-11-13 15:57:49    |           540441 | Outlet 1  |                20 |               1549946 |     68 | Pork Ribs BH                       |     1 |   13.94 |      13.94 |        181679 |    43 | MIDDLE      | LUNCH         | Main        | Noodle;Pork        |     13.94 |        1 | SOLO             |
| 2016-11-13 16:02:01    |           540450 | Outlet 2  |                 3 |               1549980 |    302 | Deep-fried Prawns with Mango sauce |     1 |   11.51 |      11.51 |        191029 |    41 | MIDDLE      | LUNCH         | Side        | Fingerfood;Seafood |     11.51 |        2 | COUPLE           |
| 2016-11-13 16:02:01    |           540450 | Outlet 2  |                 3 |               1549981 |    407 | Radish Cake                        |     1 |    5.94 |       5.94 |        191029 |    41 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork        |      5.94 |        2 | COUPLE           |
| 2016-11-13 16:02:01    |           540450 | Outlet 2  |                 3 |               1549982 |    753 | Iced Coffee-Tea                    |     1 |    9.45 |       9.45 |        191029 |    41 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         |      4.73 |        2 | COUPLE           |
| 2016-11-13 16:02:01    |           540450 | Outlet 2  |                 3 |               1549983 |    761 | Ice Milo Dinosaur                  |     1 |    5.45 |       5.45 |        191029 |    41 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         |      5.45 |        2 | COUPLE           |
| 2016-11-13 16:04:33    |           540459 | Outlet 8  |                22 |               1550016 |    705 | Kopi                               |     2 |    2.06 |       4.12 |         58075 |    37 | MIDDLE      | LUNCH         | Drink       | Drink;Hot          |      2.06 |        1 | SOLO             |
| 2016-11-13 16:04:33    |           540459 | Outlet 8  |                22 |               1550015 |    306 | Bo Lo Bun                          |     1 |    3.52 |       3.52 |         58075 |    37 | MIDDLE      | LUNCH         | Side        | Bread              |      3.52 |        1 | SOLO             |
| 2016-11-13 16:04:33    |           540459 | Outlet 8  |                22 |               1550014 |    109 | French Toast                       |     1 |    5.94 |       5.94 |         58075 |    37 | MIDDLE      | LUNCH         | Side        | Bread;Sweet        |      5.94 |        1 | SOLO             |
| 2016-11-13 16:28:25    |           540490 | Outlet 15 |                19 |               1550087 |    751 | Iced Milk Tea                      |     1 |    4.73 |       4.73 |        197053 |    26 | ADULT       | LUNCH         | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-11-13 16:37:23    |           540499 | Outlet 14 |                16 |               1550110 |    904 | Fish Slice Por                     |     1 |   10.3  |      10.3  |        176980 |    36 | MIDDLE      | LUNCH         | Main        | Porridge;Fish      |     10.3  |        1 | SOLO             |


Table #26
Filename: source_31.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                  |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:---------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|:----------|---------:|:-----------------|
| 2016-08-29 23:34:37    |           451235 | Outlet 14 |                16 |               1295594 | 1175   | Homemade Cold Beancurd     |     1 |    9.58 |       9.58 |        165006 |    43 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold       | 19.15     |        1 | SOLO             |
| 2016-08-29 23:34:37    |           451235 | Outlet 14 |                16 |               1295593 | 1135   | Soup of the Day            |     1 |    0    |       0    |        165006 |    43 | MIDDLE      | DINNER        |             |                    |           |        1 | SOLO             |
| 2016-08-29 23:34:37    |           451235 | Outlet 14 |                16 |               1295592 | 780    | Iced Grass Jelly           |     1 |    3.52 |       0    |        165006 |    43 | MIDDLE      | DINNER        |             |                    |           |        1 | SOLO             |
| 2016-08-30 00:00:45    |           451245 | Outlet 17 |                 5 |               1295610 | 705    | Kopi                       |     1 |    2.06 |       2.06 |        162456 |    41 | MIDDLE      | SUPPER        | Drink       | Drink;Hot          | 2.06      |        2 | COUPLE           |
| 2016-08-30 00:00:45    |           451245 | Outlet 17 |                 5 |               1295609 | 111    | F.Toast Chicken Floss      |     1 |    7.88 |       7.88 |        162456 |    41 | MIDDLE      | SUPPER        | Side        | Bread;Savoury      | 7.88      |        2 | COUPLE           |
| 2016-08-30 00:00:45    |           451245 | Outlet 17 |                 5 |               1295611 | 767    | Iced Lychee Tea            |     1 |    6.67 |       6.67 |        162456 |    41 | MIDDLE      | SUPPER        | Drink       | Drink;Cold         | 6.67      |        2 | COUPLE           |
| 2016-08-30 12:32:03    |           451305 | Outlet 2  |                 3 |               1295709 | 548    | Sambal Seafood Fried Rice  |     1 |   12.73 |      12.73 |        176382 |    36 | MIDDLE      | LUNCH         | Main        | Friedrice;Seafood  | 12.73     |        1 | SOLO             |
| 2016-08-30 12:32:03    |           451305 | Outlet 2  |                 3 |               1295707 | 1232   | Fried Wanton 3pcs          |     1 |    0    |       0    |        176382 |    36 | MIDDLE      | LUNCH         | Side        | Fingerfood;Seafood | 1.21      |        1 | SOLO             |
| 2016-08-30 12:46:34    |           451326 | Outlet 5  |                18 |               1295759 | 23     | Luncheon Mushrm Cream Spag |     1 |   12.73 |      12.73 |        185579 |    40 | MIDDLE      | LUNCH         | Main        | Spaghetti;Pork     | 12.73     |        1 | SOLO             |
| 2016-08-30 12:46:34    |           451326 | Outlet 5  |                18 |               1295760 | 759C   | Coke                       |     1 |    3.52 |       3.52 |        185579 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         | 3.52      |        1 | SOLO             |


Table #27
Filename: source_32.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                 |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:--------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:---------------|----------:|---------:|:-----------------|
| 2016-03-28 18:06:40    |           266813 | Outlet 15 |                19 |                772264 |    414 | Chix Feet                 |     1 |    5.94 |       5.94 |        165058 |    57 | SENIOR      | DINNER        | Side        | Dimsum;Chicken |      5.94 |        2 | COUPLE           |
| 2016-03-28 19:05:44    |           266870 | Outlet 15 |                19 |                772349 |    751 | Iced Milk Tea             |     1 |    4.73 |       4.73 |         73760 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Cold     |      4.73 |        2 | COUPLE           |
| 2016-03-28 19:05:44    |           266870 | Outlet 15 |                19 |                772348 |   1217 | Fermented Pork Dry Noodle |     1 |   12.73 |      12.73 |         73760 |    39 | MIDDLE      | DINNER        | Main        | Noodle;Pork    |     12.73 |        2 | COUPLE           |
| 2016-03-28 19:05:44    |           266870 | Outlet 15 |                19 |                772350 |    902 | Cent Egg Pork Por         |     1 |   10.3  |      10.3  |         73760 |    39 | MIDDLE      | DINNER        | Main        | Porridge;Pork  |     10.3  |        2 | COUPLE           |
| 2016-03-28 19:05:44    |           266870 | Outlet 15 |                19 |                772347 |    109 | French Toast              |     1 |    5.94 |       5.94 |         73760 |    39 | MIDDLE      | DINNER        | Side        | Bread;Sweet    |      5.94 |        2 | COUPLE           |
| 2016-03-28 19:07:38    |           266875 | Outlet 13 |                 9 |                772367 |    751 | Iced Milk Tea             |     1 |    4.73 |       9.45 |        163132 |    19 | ADULT       | DINNER        | Drink       | Drink;Cold     |      4.73 |        2 | COUPLE           |
| 2016-03-28 19:07:38    |           266875 | Outlet 13 |                 9 |                772364 |    556 | Watermelon 'N' Jelly      |     1 |    7.88 |       7.88 |        163132 |    19 | ADULT       | DINNER        | Dessert     | Dessert;Cold   |      7.88 |        2 | COUPLE           |
| 2016-03-28 19:07:38    |           266875 | Outlet 13 |                 9 |                772358 |      1 | Cold / Iced Water         |     2 |    0.73 |       1.46 |        163132 |    19 | ADULT       | DINNER        | Drink       | Drink;Cold     |      0.73 |        2 | COUPLE           |
| 2016-03-28 19:07:38    |           266875 | Outlet 13 |                 9 |                772362 |    412 | Har Gao                   |     2 |    5.94 |      11.88 |        163132 |    19 | ADULT       | DINNER        | Side        | Dimsum;Seafood |      5.94 |        2 | COUPLE           |
| 2016-03-28 19:07:38    |           266875 | Outlet 13 |                 9 |                772366 |    704 | Fresh Soy Milk            |     1 |    3.52 |       3.52 |        163132 |    19 | ADULT       | DINNER        | Drink       | Drink;Hot      |      3.52 |        2 | COUPLE           |


Table #28
Filename: source_33.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                      |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-10-02 15:28:12    |           490320 | Outlet 1  |                20 |               1403335 | 2      | Warm Water                     |     1 |    0.73 |       0.73 |        188258 |    36 | MIDDLE      | LUNCH         | Drink       | Drink;Hot           |      0.73 |        1 | SOLO             |
| 2016-10-02 16:27:26    |           490381 | Outlet 17 |                 5 |               1403516 | 215B   | Pork Chop Bee Hoon             |     1 |   13.94 |      13.94 |        181239 |    47 | MIDDLE      | LUNCH         | Main        | Noodle;Pork         |     13.94 |        2 | COUPLE           |
| 2016-10-02 16:27:26    |           490381 | Outlet 17 |                 5 |               1403515 | 68     | Fried Spare Ribs Bee Hoon      |     1 |   13.94 |      13.94 |        181239 |    47 | MIDDLE      | LUNCH         | Main        | Noodle;Pork         |     13.94 |        2 | COUPLE           |
| 2016-10-02 16:44:58    |           490401 | Outlet 14 |                16 |               1403532 | 111    | F.Toast Chicken Floss          |     1 |    7.88 |       7.88 |        166258 |    50 | MIDDLE      | LUNCH         | Side        | Bread;Savoury       |      7.88 |        1 | SOLO             |
| 2016-10-02 16:44:58    |           490401 | Outlet 14 |                16 |               1403533 | 401    | Siew Mai                       |     1 |    5.45 |       5.45 |        166258 |    50 | MIDDLE      | LUNCH         | Side        | Dimsum;Seafood;Pork |      5.45 |        1 | SOLO             |
| 2016-10-02 16:44:58    |           490401 | Outlet 14 |                16 |               1403534 | 715    | Milk Tea                       |     1 |    4.24 |       4.24 |        166258 |    50 | MIDDLE      | LUNCH         | Drink       | Drink;Hot           |      4.24 |        1 | SOLO             |
| 2016-10-02 16:49:35    |           490409 | Outlet 16 |                 3 |               1403552 | 215B   | Pork Chop Bee Hoon             |     1 |   13.94 |      13.94 |        188043 |    37 | MIDDLE      | LUNCH         | Main        | Noodle;Pork         |     13.94 |        2 | COUPLE           |
| 2016-10-02 16:49:35    |           490409 | Outlet 16 |                 3 |               1403553 | 411    | Pan Fried Dumpling             |     1 |    7.88 |       7.88 |        188043 |    37 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork         |      7.88 |        2 | COUPLE           |
| 2016-10-02 16:49:35    |           490409 | Outlet 16 |                 3 |               1403551 | 106    | Peanut Butter Milk Thick Toast |     1 |    5.94 |       5.94 |        188043 |    37 | MIDDLE      | LUNCH         | Side        | Bread;Sweet         |      5.94 |        2 | COUPLE           |
| 2016-10-02 16:49:35    |           490409 | Outlet 16 |                 3 |               1403556 | 906    | Spicy Pork Por                 |     1 |   10.3  |      10.3  |        188043 |    37 | MIDDLE      | LUNCH         | Main        | Porridge;Pork       |     10.3  |        2 | COUPLE           |


Table #29
Filename: source_34.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet   |   outlet_district |   transact_details_id |   item | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat              |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:---------|------------------:|----------------------:|-------:|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:----------------------|----------:|---------:|:-----------------|
| 2016-08-04 18:56:00    |           418212 | Outlet 1 |                20 |               1204439 |    251 | Yao Ma Tei Chix Rice    |     1 |   13.94 |      13.94 |        184923 |    40 | MIDDLE      | DINNER        | Main        | Rice;Chicken          |     13.94 |        4 | GROUP            |
| 2016-08-04 18:56:00    |           418212 | Outlet 1 |                20 |               1204441 |    521 | VEGETARIAN HOR FUN      |     1 |   10.3  |      10.3  |        184923 |    40 | MIDDLE      | DINNER        | Main        | Noodle;Vegetarian     |     10.3  |        4 | GROUP            |
| 2016-08-04 18:56:00    |           418212 | Outlet 1 |                20 |               1204440 |    503 | Spy P.Dices Soup Ndl    |     1 |    9.45 |       9.45 |        184923 |    40 | MIDDLE      | DINNER        | Main        | Noodlesoup;Pork       |      9.45 |        4 | GROUP            |
| 2016-08-04 18:56:00    |           418212 | Outlet 1 |                20 |               1204438 |     14 | BP Chix Spag            |     1 |   12.73 |      12.73 |        184923 |    40 | MIDDLE      | DINNER        | Main        | Spaghetti;Chicken     |     12.73 |        4 | GROUP            |
| 2016-08-04 19:16:38    |           418256 | Outlet 9 |                19 |               1204569 |    753 | Iced Coffee-Tea         |     1 |    4.73 |       4.73 |         65081 |    35 | ADULT       | DINNER        | Drink       | Drink;Cold            |      4.73 |        2 | COUPLE           |
| 2016-08-04 19:16:38    |           418256 | Outlet 9 |                19 |               1204567 |    305 | F.Fries Curry Mayo      |     1 |    5.94 |       5.94 |         65081 |    35 | ADULT       | DINNER        | Side        | Fingerfood;Vegetarian |      5.94 |        2 | COUPLE           |
| 2016-08-04 19:16:38    |           418256 | Outlet 9 |                19 |               1204568 |    751 | Iced Milk Tea           |     1 |    4.73 |       4.73 |         65081 |    35 | ADULT       | DINNER        | Drink       | Drink;Cold            |      4.73 |        2 | COUPLE           |
| 2016-08-04 19:18:27    |           418260 | Outlet 1 |                20 |               1204584 |    413 | SPRING ROLL             |     1 |    5.94 |       5.94 |        181798 |    42 | MIDDLE      | DINNER        | Side        | Dimsum;Pork           |      5.94 |        1 | SOLO             |
| 2016-08-04 19:18:27    |           418260 | Outlet 1 |                20 |               1204583 |    112 | F.Toast Ice Cream       |     1 |    7.88 |       7.88 |        181798 |    42 | MIDDLE      | DINNER        | Side        | Bread;Sweet           |     23.64 |        1 | SOLO             |
| 2016-08-04 19:18:27    |           418260 | Outlet 1 |                20 |               1204582 |     21 | Chicken Chop Cream Spag |     2 |   28.85 |      57.7  |        181798 |    42 | MIDDLE      | DINNER        | Main        | Spaghetti;Chicken     |     14.42 |        1 | SOLO             |


Table #30
Filename: source_35.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                         |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-12-31 21:09:55    |           601611 | Outlet 18 |                23 |               1724582 |    307 | Prawn Paste Chicken               |     1 |    8.36 |       8.36 |        200918 |    35 | ADULT       | DINNER        | Side        | Fingerfood;Chicken |      8.36 |        1 | SOLO             |
| 2016-12-31 21:21:47    |           601633 | Outlet 3  |                 9 |               1724634 |    782 | Peach Ice-blended                 |     1 |    7.15 |       7.15 |        179149 |    23 | ADULT       | DINNER        | Drink       | Drink;Cold         |     14.3  |        2 | COUPLE           |
| 2016-12-31 21:21:47    |           601633 | Outlet 3  |                 9 |               1724631 |     14 | BP Chix Spag                      |     1 |   12.73 |      12.73 |        179149 |    23 | ADULT       | DINNER        | Main        | Spaghetti;Chicken  |     12.73 |        2 | COUPLE           |
| 2016-12-31 21:21:47    |           601633 | Outlet 3  |                 9 |               1724632 |     43 | Pork Chop Bk Rice                 |     1 |   15.15 |      15.15 |        179149 |    23 | ADULT       | DINNER        | Main        | Bakedrice;Pork     |     15.15 |        2 | COUPLE           |
| 2016-12-31 21:21:47    |           601633 | Outlet 3  |                 9 |               1724633 |    315 | HONEY CHICKEN WING (5pcs)         |     1 |    7.15 |       7.15 |        179149 |    23 | ADULT       | DINNER        | Side        | Fingerfood;Chicken |      7.15 |        2 | COUPLE           |
| 2016-12-31 22:48:00    |           601752 | Outlet 9  |                19 |               1724953 |     21 | Chicken Chop Cream Spag           |     1 |   14.42 |      14.42 |        193858 |    52 | SENIOR      | DINNER        | Main        | Spaghetti;Chicken  |     14.42 |        2 | COUPLE           |
| 2016-12-31 22:48:00    |           601752 | Outlet 9  |                19 |               1724957 |    797 | RAINBOW SPRITE                    |     1 |    5.94 |       5.94 |        193858 |    52 | SENIOR      | DINNER        | Drink       | Drink;Cold         |      5.94 |        2 | COUPLE           |
| 2016-12-31 22:48:00    |           601752 | Outlet 9  |                19 |               1724954 |    413 | SPRING ROLL                       |     1 |    5.94 |       5.94 |        193858 |    52 | SENIOR      | DINNER        | Side        | Dimsum;Pork        |      5.94 |        2 | COUPLE           |
| 2016-12-31 22:48:00    |           601752 | Outlet 9  |                19 |               1724955 |    509 | Braised Beef Brisket Soup Noodles |     1 |   11.88 |      11.88 |        193858 |    52 | SENIOR      | DINNER        | Main        | Noodlesoup;Beef    |     11.88 |        2 | COUPLE           |
| 2016-12-31 22:48:38    |           601754 | Outlet 14 |                16 |               1724964 |     23 | Luncheon Mushrm Cream Spag        |     1 |   12.73 |      12.73 |        173042 |    22 | ADULT       | DINNER        | Main        | Spaghetti;Pork     |     12.73 |        1 | SOLO             |


Table #31
Filename: source_36.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                            |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat          |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:-------------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:------------------|----------:|---------:|:-----------------|
| 2016-06-09 22:04:35    |           349924 | Outlet 1  |                20 |               1009081 |    552 | Mango Pomelo                         |     1 |    8.36 |       8.36 |        167217 |    53 | SENIOR      | DINNER        | Dessert     | Dessert;Cold      |      8.36 |        3 | GROUP            |
| 2016-06-09 22:04:35    |           349924 | Outlet 1  |                20 |               1009079 |    411 | Pan Fried Dumpling                   |     1 |    7.88 |       7.88 |        167217 |    53 | SENIOR      | DINNER        | Side        | Dimsum;Pork       |      7.88 |        3 | GROUP            |
| 2016-06-09 22:24:32    |           349941 | Outlet 3  |                 9 |               1009121 |     21 | Chicken Chop Cream Spag              |     1 |   14.42 |      14.42 |        171377 |    34 | ADULT       | DINNER        | Main        | Spaghetti;Chicken |     14.42 |        2 | COUPLE           |
| 2016-06-09 22:24:32    |           349941 | Outlet 3  |                 9 |               1009122 |    545 | Chicken Flos Fried Rice              |     1 |   12.73 |      12.73 |        171377 |    34 | ADULT       | DINNER        | Main        | Friedrice;Chicken |     12.73 |        2 | COUPLE           |
| 2016-06-09 22:39:57    |           349954 | Outlet 14 |                16 |               1009176 |     76 | Braised Beef brisket Noodles         |     1 |   12    |      12    |        173140 |    25 | ADULT       | DINNER        | Main        | Noodle;Beef       |     12    |        1 | SOLO             |
| 2016-06-09 22:45:16    |           349956 | Outlet 18 |                23 |               1009183 |    203 | CURRY BEEF BRISKET HOT POT WITH RICE |     1 |   13.94 |      13.94 |        174122 |    30 | ADULT       | DINNER        | Main        | Rice;Beef         |     13.94 |        1 | SOLO             |
| 2016-06-09 22:45:16    |           349956 | Outlet 18 |                23 |               1009184 |    768 | Iced Peach Tea                       |     1 |    6.67 |       6.67 |        174122 |    30 | ADULT       | DINNER        | Drink       | Drink;Cold        |      6.67 |        1 | SOLO             |
| 2016-06-09 22:59:24    |           349984 | Outlet 14 |                16 |               1009276 |    548 | Sambal Seafood Fried Rice            |     1 |   12.73 |      12.73 |         56031 |    25 | ADULT       | DINNER        | Main        | Friedrice;Seafood |     12.73 |        2 | COUPLE           |
| 2016-06-09 22:59:24    |           349984 | Outlet 14 |                16 |               1009275 |    411 | Pan Fried Dumpling                   |     1 |    7.88 |       7.88 |         56031 |    25 | ADULT       | DINNER        | Side        | Dimsum;Pork       |      7.88 |        2 | COUPLE           |
| 2016-06-09 22:59:24    |           349984 | Outlet 14 |                16 |               1009273 |      2 | Warm Water                           |     1 |    0.73 |       0.73 |         56031 |    25 | ADULT       | DINNER        | Drink       | Drink;Hot         |      0.73 |        2 | COUPLE           |


Table #32
Filename: source_37.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet   |   outlet_district |   transact_details_id | item     | item_desc                     |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:---------|------------------:|----------------------:|:---------|:------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|:----------|---------:|:-----------------|
| 2016-08-24 12:44:41    |           443690 | Outlet 2 |                 3 |               1275558 | 1232     | Fried Wanton 3pcs             |     1 |    0    |       0    |        176505 |    36 | MIDDLE      | LUNCH         | Side        | Fingerfood;Seafood | 1.21      |        1 | SOLO             |
| 2016-08-24 13:25:17    |           443743 | Outlet 2 |                 3 |               1275722 | 545      | Chicken Flos Fried Rice       |     1 |   12.73 |      12.73 |         58688 |    47 | MIDDLE      | LUNCH         | Main        | Friedrice;Chicken  | 12.73     |        2 | COUPLE           |
| 2016-08-24 13:25:17    |           443743 | Outlet 2 |                 3 |               1275719 | 1232     | Fried Wanton 3pcs             |    10 |    0    |       0    |         58688 |    47 | MIDDLE      | LUNCH         | Side        | Fingerfood;Seafood | 1.21      |        2 | COUPLE           |
| 2016-08-24 13:25:17    |           443743 | Outlet 2 |                 3 |               1275724 | 808      | Chicken Dry Curry Ramen       |     1 |   13.94 |      13.94 |         58688 |    47 | MIDDLE      | LUNCH         | Main        | Noodle;Chicken     | 13.94     |        2 | COUPLE           |
| 2016-08-24 13:25:17    |           443743 | Outlet 2 |                 3 |               1275714 | 1109     | Chix Wing Honey Sweet Sauce   |     4 |    5.94 |      23.76 |         58688 |    47 | MIDDLE      | LUNCH         | Side        | Fingerfood;Chicken | 5.94      |        2 | COUPLE           |
| 2016-08-24 13:25:17    |           443743 | Outlet 2 |                 3 |               1275713 | 2        | Warm Water                    |     3 |    0.73 |       2.19 |         58688 |    47 | MIDDLE      | LUNCH         | Drink       | Drink;Hot          | 0.73      |        2 | COUPLE           |
| 2016-08-24 13:30:50    |           443754 | Outlet 2 |                 3 |               1275763 | TAKEAWAY | TAKEAWAY                      |     1 |    0    |       0    |         63521 |    44 | MIDDLE      | LUNCH         |             |                    |           |        3 | GROUP            |
| 2016-08-24 13:30:50    |           443754 | Outlet 2 |                 3 |               1275755 | 548      | Sambal Seafood Fried Rice     |     1 |   12.73 |      12.73 |         63521 |    44 | MIDDLE      | LUNCH         | Main        | Friedrice;Seafood  | 12.73     |        3 | GROUP            |
| 2016-08-24 13:30:50    |           443754 | Outlet 2 |                 3 |               1275758 | 809      | F'mented Pork Dry Curry Ramen |     1 |   13.94 |      13.94 |         63521 |    44 | MIDDLE      | LUNCH         | Main        | Noodle;Chicken     | 13.94     |        3 | GROUP            |
| 2016-08-24 13:30:50    |           443754 | Outlet 2 |                 3 |               1275752 | 1232     | Fried Wanton 3pcs             |     1 |    0    |       0    |         63521 |    44 | MIDDLE      | LUNCH         | Side        | Fingerfood;Seafood | 1.21      |        3 | GROUP            |


Table #33
Filename: source_38.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698248 | 503    | Spy P.Dices Soup Ndl         |     1 |    9.45 |       9.45 |        162923 |    31 | ADULT       | DINNER        | Main        | Noodlesoup;Pork    |      9.45 |        4 | GROUP            |
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698249 | 560    | Coffee-Tea Snow Ice          |     1 |    8.36 |       8.36 |        162923 |    31 | ADULT       | DINNER        | Dessert     | Dessert;Cold       |      8.36 |        4 | GROUP            |
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698247 | 307    | Prawn Paste Chicken          |     1 |    8.36 |       8.36 |        162923 |    31 | ADULT       | DINNER        | Side        | Fingerfood;Chicken |      8.36 |        4 | GROUP            |
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698246 | 215B   | Pork Chop Bee Hoon           |     2 |   13.94 |      27.88 |        162923 |    31 | ADULT       | DINNER        | Main        | Noodle;Pork        |     13.94 |        4 | GROUP            |
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698252 | 820    | Minced Kai Lan W Silver Fish |     2 |   11.51 |      23.02 |        162923 |    31 | ADULT       | DINNER        | Side        | Vegetable;Seafood  |     11.51 |        4 | GROUP            |
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698244 | 76     | Braised Beef brisket Noodles |     1 |   12    |      12    |        162923 |    31 | ADULT       | DINNER        | Main        | Noodle;Beef        |     12    |        4 | GROUP            |
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698251 | 720    | Yuzu Tea                     |     2 |    3.88 |       7.76 |        162923 |    31 | ADULT       | DINNER        | Drink       | Drink;Hot          |      3.88 |        4 | GROUP            |
| 2016-03-02 21:45:07    |           241112 | Outlet 13 |                 9 |                698245 | 1201   | Seafood Ee Noodle            |     1 |   13.21 |      13.21 |        162923 |    31 | ADULT       | DINNER        | Main        | Noodle;Seafood     |     13.21 |        4 | GROUP            |
| 2016-03-02 22:37:59    |           241142 | Outlet 3  |                 9 |                698324 | 767    | Iced Lychee Tea              |     1 |    6.67 |       6.67 |        159545 |    34 | ADULT       | DINNER        | Drink       | Drink;Cold         |      6.67 |        1 | SOLO             |
| 2016-03-02 22:37:59    |           241142 | Outlet 3  |                 9 |                698323 | 315    | HONEY CHICKEN WING (5pcs)    |     1 |    7.15 |       7.15 |        159545 |    34 | ADULT       | DINNER        | Side        | Fingerfood;Chicken |      7.15 |        1 | SOLO             |


Table #34
Filename: source_39.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-08-19 18:13:32    |           437231 | Outlet 3  |                 9 |               1257927 |    909 | Sliced Empress Congee       |     1 |   12    |      12    |        171313 |    21 | ADULT       | DINNER        | Main        | Porridge;Seafood   |     12    |        2 | COUPLE           |
| 2016-08-19 18:13:32    |           437231 | Outlet 3  |                 9 |               1257922 |    411 | Pan Fried Dumpling          |     1 |    7.88 |       7.88 |        171313 |    21 | ADULT       | DINNER        | Side        | Dimsum;Pork        |      7.88 |        2 | COUPLE           |
| 2016-08-19 19:08:05    |           437325 | Outlet 1  |                20 |               1258125 |   1109 | Chix Wing Honey Sweet Sauce |     1 |    5.94 |       5.94 |        181777 |    12 | YOUTH       | DINNER        | Side        | Fingerfood;Chicken |      5.94 |        1 | SOLO             |
| 2016-08-19 19:08:05    |           437325 | Outlet 1  |                20 |               1258126 |    545 | Chicken Flos Fried Rice     |     1 |   12.73 |      12.73 |        181777 |    12 | YOUTH       | DINNER        | Main        | Friedrice;Chicken  |     12.73 |        1 | SOLO             |
| 2016-08-19 19:08:05    |           437325 | Outlet 1  |                20 |               1258127 |    751 | Iced Milk Tea               |     1 |    4.73 |       4.73 |        181777 |    12 | YOUTH       | DINNER        | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-08-19 19:08:08    |           437340 | Outlet 18 |                23 |               1258151 |    904 | Fish Slice Por              |     1 |   10.3  |      10.3  |        166797 |    39 | MIDDLE      | DINNER        | Main        | Porridge;Fish      |     10.3  |        2 | COUPLE           |
| 2016-08-19 19:08:08    |           437340 | Outlet 18 |                23 |               1258147 |    412 | Har Gao                     |     1 |    5.94 |       5.94 |        166797 |    39 | MIDDLE      | DINNER        | Side        | Dimsum;Seafood     |      5.94 |        2 | COUPLE           |
| 2016-08-19 19:08:08    |           437340 | Outlet 18 |                23 |               1258150 |    776 | Watermelon Ice              |     1 |    7.15 |       7.15 |        166797 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      7.15 |        2 | COUPLE           |
| 2016-08-19 19:08:08    |           437340 | Outlet 18 |                23 |               1258148 |    702 | Milo                        |     1 |    2.3  |       2.3  |        166797 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Hot          |      2.3  |        2 | COUPLE           |
| 2016-08-19 19:08:08    |           437340 | Outlet 18 |                23 |               1258146 |     67 | Signature Fried Noodles     |     1 |   13.94 |      13.94 |        166797 |    39 | MIDDLE      | DINNER        | Main        | Noodle;Pork        |     13.94 |        2 | COUPLE           |


Table #35
Filename: source_4.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|----------:|---------:|:-----------------|
| 2016-06-15 21:15:19    |           357548 | Outlet 22 |                 4 |               1031362 |    411 | Pan Fried Dumpling      |     1 |    7.88 |       7.88 |        158868 |    35 | ADULT       | DINNER        | Side        | Dimsum;Pork                    |      7.88 |        1 | SOLO             |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031432 |    797 | RAINBOW SPRITE          |     1 |    5.94 |       5.94 |         58659 |    61 | SENIOR      | DINNER        | Drink       | Drink;Cold                     |      5.94 |        5 | GROUP            |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031433 |    904 | Fish Slice Por          |     1 |   10.3  |      10.3  |         58659 |    61 | SENIOR      | DINNER        | Main        | Porridge;Fish                  |     10.3  |        5 | GROUP            |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031430 |    701 | Chinese Tea             |     1 |    2.06 |       2.06 |         58659 |    61 | SENIOR      | DINNER        | Drink       | Drink;Hot                      |      2.06 |        5 | GROUP            |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031426 |     61 | CRISPY PRAWN NOODLE     |     1 |   16.36 |      16.36 |         58659 |    61 | SENIOR      | DINNER        | Main        | Noodle;Seafood                 |     16.36 |        5 | GROUP            |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031431 |    718 | Hot Honey with Lemon    |     1 |    4.73 |       4.73 |         58659 |    61 | SENIOR      | DINNER        | Drink       | Drink;Hot                      |      4.73 |        5 | GROUP            |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031428 |    507 | Ham & Egg Soup Ndl      |     1 |    9.45 |       9.45 |         58659 |    61 | SENIOR      | DINNER        | Main        | Noodlesoup;Pork                |      9.45 |        5 | GROUP            |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031429 |    549 | Signature Fried Rice    |     1 |   13.94 |      13.94 |         58659 |    61 | SENIOR      | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        5 | GROUP            |
| 2016-06-15 21:21:28    |           357567 | Outlet 17 |                 5 |               1031427 |     66 | Sliced Fish Egg Hor Fun |     1 |   12.73 |      12.73 |         58659 |    61 | SENIOR      | DINNER        | Main        | Noodle;Fish                    |     12.73 |        5 | GROUP            |
| 2016-06-15 21:34:42    |           357586 | Outlet 5  |                18 |               1031479 |    768 | Iced Peach Tea          |     3 |    6.67 |      20.01 |        161216 |    31 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      6.67 |        2 | COUPLE           |


Table #36
Filename: source_40.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:---------------|----------:|---------:|:-----------------|
| 2016-04-16 11:43:58    |           283794 | Outlet 9  |                19 |                819100 | 776    | Watermelon Ice-Blended   |     1 |    7.15 |       7.15 |        162348 |    43 | MIDDLE      | BREAKFAST     | Drink       | Drink;Cold     |      7.15 |        4 | GROUP            |
| 2016-04-16 11:43:58    |           283794 | Outlet 9  |                19 |                819093 | 126    | Luncheon N Egg Sandwich  |     1 |    4.73 |       4.73 |        162348 |    43 | MIDDLE      | BREAKFAST     | Side        | Bread;Savoury  |      4.73 |        4 | GROUP            |
| 2016-04-16 12:01:05    |           283811 | Outlet 15 |                19 |                819144 | 111    | F.Toast Chicken Floss    |     1 |    7.88 |       7.88 |        167585 |    42 | MIDDLE      | LUNCH         | Side        | Bread;Savoury  |      7.88 |        1 | SOLO             |
| 2016-04-16 12:01:05    |           283811 | Outlet 15 |                19 |                819145 | 251    | Yao Ma Tei Chix Rice     |     1 |   13.94 |      13.94 |        167585 |    42 | MIDDLE      | LUNCH         | Main        | Rice;Chicken   |     13.94 |        1 | SOLO             |
| 2016-04-16 12:01:05    |           283811 | Outlet 15 |                19 |                819147 | 414    | Chix Feet                |     1 |    5.94 |       5.94 |        167585 |    42 | MIDDLE      | LUNCH         | Side        | Dimsum;Chicken |      5.94 |        1 | SOLO             |
| 2016-04-16 12:01:05    |           283811 | Outlet 15 |                19 |                819146 | 412    | Har Gao                  |     1 |    5.94 |       5.94 |        167585 |    42 | MIDDLE      | LUNCH         | Side        | Dimsum;Seafood |      5.94 |        1 | SOLO             |
| 2016-04-16 12:06:56    |           283823 | Outlet 11 |                27 |                819174 | 215B   | Pork Chop Bee Hoon       |     2 |   13.94 |      27.88 |        164435 |    17 | YOUTH       | LUNCH         | Main        | Noodle;Pork    |     13.94 |        1 | SOLO             |
| 2016-04-16 12:06:56    |           283823 | Outlet 11 |                27 |                819176 | 782    | Peach Ice-blended        |     1 |    7.15 |       7.15 |        164435 |    17 | YOUTH       | LUNCH         | Drink       | Drink;Cold     |     14.3  |        1 | SOLO             |
| 2016-04-16 12:06:56    |           283823 | Outlet 11 |                27 |                819175 | 403    | Beancurd Skin Prawn Roll |     1 |    6.67 |       6.67 |        164435 |    17 | YOUTH       | LUNCH         | Side        | Dimsum;Pork    |      6.67 |        1 | SOLO             |
| 2016-04-16 12:14:47    |           283843 | Outlet 11 |                27 |                819227 | 215A   | Pork Chop Noodle         |     1 |   13.94 |      13.94 |         54796 |    38 | MIDDLE      | LUNCH         | Main        | Noodle;Pork    |     13.94 |        2 | COUPLE           |


Table #37
Filename: source_41.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|:----------|---------:|:-----------------|
| 2016-03-20 12:09:27    |           258217 | Outlet 18 |                23 |                747342 |     11 | Chs Bk Pork Chop Spag       |     1 |   14.42 |      14.42 |         58124 |    40 | MIDDLE      | LUNCH         | Main        | Spaghetti;Chicken              | 14.42     |        2 | COUPLE           |
| 2016-03-20 12:09:27    |           258217 | Outlet 18 |                23 |                747345 |    766 | Iced Honey Green Tea        |     2 |    5.94 |      11.88 |         58124 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Cold                     | 5.94      |        2 | COUPLE           |
| 2016-03-20 12:09:27    |           258217 | Outlet 18 |                23 |                747344 |    293 | Chicken Macaroni Soup       |     1 |    9.09 |       9.09 |         58124 |    40 | MIDDLE      | LUNCH         | Main        | Soup;Chicken                   | 9.09      |        2 | COUPLE           |
| 2016-03-20 12:36:13    |           258266 | Outlet 5  |                18 |                747501 |    549 | Signature Fried Rice        |     1 |   13.94 |      13.94 |        161117 |    32 | ADULT       | LUNCH         | Main        | Friedrice;Pork;Seafood;Chicken | 13.94     |        1 | SOLO             |
| 2016-03-20 12:36:13    |           258266 | Outlet 5  |                18 |                747502 |    780 | Iced Grass Jelly            |     2 |    3.52 |       7.04 |        161117 |    32 | ADULT       | LUNCH         |             |                                |           |        1 | SOLO             |
| 2016-03-20 12:37:28    |           258268 | Outlet 11 |                27 |                747507 |    713 | Hot Coffee-Tea              |     1 |    4.24 |       4.24 |         68517 |    44 | MIDDLE      | LUNCH         | Drink       | Drink;Hot                      | 4.24      |        2 | COUPLE           |
| 2016-03-20 12:37:28    |           258268 | Outlet 11 |                27 |                747506 |    418 | BBQ Pork Bun                |     1 |    5.45 |       5.45 |         68517 |    44 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork                    | 5.45      |        2 | COUPLE           |
| 2016-03-20 12:37:28    |           258268 | Outlet 11 |                27 |                747509 |    769 | Iced Lemon Tea              |     1 |    5.94 |       5.94 |         68517 |    44 | MIDDLE      | LUNCH         | Drink       | Drink;Cold                     | 5.94      |        2 | COUPLE           |
| 2016-03-20 12:37:28    |           258268 | Outlet 11 |                27 |                747508 |    751 | Iced Milk Tea               |     3 |    4.73 |      14.19 |         68517 |    44 | MIDDLE      | LUNCH         | Drink       | Drink;Cold                     | 4.73      |        2 | COUPLE           |
| 2016-03-20 12:37:28    |           258268 | Outlet 11 |                27 |                747511 |    810 | SMOKED DUCK DRY CURRY RAMEN |     3 |   15.15 |      45.45 |         68517 |    44 | MIDDLE      | LUNCH         | Main        | Noodle;Duck                    | 15.15     |        2 | COUPLE           |


Table #38
Filename: source_42.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet   |   outlet_district |   transact_details_id | item   | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:---------|------------------:|----------------------:|:-------|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-12-26 15:38:43    |           595460 | Outlet 3 |                 9 |               1707458 | 68     | Pork Ribs BH            |     1 |   13.94 |      13.94 |        200989 |    29 | ADULT       | LUNCH         | Main        | Noodle;Pork        |     13.94 |        1 | SOLO             |
| 2016-12-26 15:38:43    |           595460 | Outlet 3 |                 9 |               1707459 | 307    | Prawn Paste Chicken     |     1 |    8.36 |       8.36 |        200989 |    29 | ADULT       | LUNCH         | Side        | Fingerfood;Chicken |      8.36 |        1 | SOLO             |
| 2016-12-26 15:38:43    |           595460 | Outlet 3 |                 9 |               1707461 | 552    | Mango Pomelo            |     1 |    8.36 |       8.36 |        200989 |    29 | ADULT       | LUNCH         | Dessert     | Dessert;Cold       |      8.36 |        1 | SOLO             |
| 2016-12-26 15:38:43    |           595460 | Outlet 3 |                 9 |               1707460 | 411    | Pan Fried Dumpling      |     1 |    7.88 |       7.88 |        200989 |    29 | ADULT       | LUNCH         | Side        | Dimsum;Pork        |      7.88 |        1 | SOLO             |
| 2016-12-26 15:49:06    |           595487 | Outlet 5 |                18 |               1707544 | 407    | Radish Cake             |     1 |    5.94 |       5.94 |        202156 |    38 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork        |      5.94 |        2 | COUPLE           |
| 2016-12-26 15:49:06    |           595487 | Outlet 5 |                18 |               1707545 | 705    | Kopi                    |     1 |    2.06 |       2.06 |        202156 |    38 | MIDDLE      | LUNCH         | Drink       | Drink;Hot          |      2.06 |        2 | COUPLE           |
| 2016-12-26 15:49:06    |           595487 | Outlet 5 |                18 |               1707546 | 753    | Iced Coffee-Tea         |     1 |    4.73 |       4.73 |        202156 |    38 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         |      4.73 |        2 | COUPLE           |
| 2016-12-26 15:56:27    |           595497 | Outlet 3 |                 9 |               1707588 | 67     | Signature Fried Noodles |     1 |   13.94 |      13.94 |        169297 |    28 | ADULT       | LUNCH         | Main        | Noodle;Pork        |     13.94 |        2 | COUPLE           |
| 2016-12-26 15:56:27    |           595497 | Outlet 3 |                 9 |               1707590 | 215B   | Pork Chop Bee Hoon      |     1 |   13.94 |      13.94 |        169297 |    28 | ADULT       | LUNCH         | Main        | Noodle;Pork        |     13.94 |        2 | COUPLE           |
| 2016-12-26 15:56:27    |           595497 | Outlet 3 |                 9 |               1707589 | 111    | F.Toast Chicken Floss   |     1 |    7.88 |       7.88 |        169297 |    28 | ADULT       | LUNCH         | Side        | Bread;Savoury      |      7.88 |        2 | COUPLE           |


Table #39
Filename: source_43.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-08-09 11:55:40    |           425027 | Outlet 11 |                27 |               1223807 |    713 | Hot Coffee-Tea          |     1 |    4.24 |       0    |         54796 |    38 | MIDDLE      | BREAKFAST     | Drink       | Drink;Hot           |      4.24 |        2 | COUPLE           |
| 2016-08-09 11:55:40    |           425027 | Outlet 11 |                27 |               1223808 |    251 | Yao Ma Tei Chix Rice    |     1 |   13.94 |      13.94 |         54796 |    38 | MIDDLE      | BREAKFAST     | Main        | Rice;Chicken        |     13.94 |        2 | COUPLE           |
| 2016-08-09 11:55:40    |           425027 | Outlet 11 |                27 |               1223806 |     74 | Wanton Soup Noodle      |     1 |   10.79 |      10.79 |         54796 |    38 | MIDDLE      | BREAKFAST     | Main        | Noodle;Pork;Seafood |     10.79 |        2 | COUPLE           |
| 2016-08-09 12:10:20    |           425048 | Outlet 1  |                20 |               1223856 |    254 | SH Pork Chop Rice       |     2 |   13.94 |      27.88 |        181630 |    34 | ADULT       | LUNCH         | Main        | Rice;Pork           |     13.94 |        1 | SOLO             |
| 2016-08-09 12:10:20    |           425048 | Outlet 1  |                20 |               1223857 |    306 | Bo Lo Bun               |     1 |    3.52 |       3.52 |        181630 |    34 | ADULT       | LUNCH         | Side        | Bread               |      3.52 |        1 | SOLO             |
| 2016-08-09 12:10:20    |           425048 | Outlet 1  |                20 |               1223858 |    715 | Milk Tea                |     1 |    4.24 |       4.24 |        181630 |    34 | ADULT       | LUNCH         | Drink       | Drink;Hot           |      4.24 |        1 | SOLO             |
| 2016-08-09 12:39:11    |           425115 | Outlet 15 |                19 |               1224028 |     41 | BAKED RICE EBI          |     1 |   15.15 |      15.15 |        167003 |    36 | MIDDLE      | LUNCH         | Main        | BakedRice;Seafood   |     15.15 |        3 | GROUP            |
| 2016-08-09 12:39:11    |           425115 | Outlet 15 |                19 |               1224030 |    127 | Borsch Soup             |     1 |    5.94 |       5.94 |        167003 |    36 | MIDDLE      | LUNCH         | Side        | Soup;Beef           |      5.94 |        3 | GROUP            |
| 2016-08-09 12:39:11    |           425115 | Outlet 15 |                19 |               1224031 |    545 | Chicken Flos Fried Rice |     1 |   12.73 |      12.73 |        167003 |    36 | MIDDLE      | LUNCH         | Main        | Friedrice;Chicken   |     12.73 |        3 | GROUP            |
| 2016-08-09 12:39:11    |           425115 | Outlet 15 |                19 |               1224032 |    553 | Mango SnowIce           |     1 |    9.09 |       9.09 |        167003 |    36 | MIDDLE      | LUNCH         | Dessert     | Dessert;Cold        |      9.09 |        3 | GROUP            |


Table #40
Filename: source_44.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|:----------|---------:|:-----------------|
| 2016-11-08 20:12:23    |           534385 | Outlet 19 |                 5 |               1531637 | 1136   | Fruit Jelly Pudding         |     1 |    9.58 |       9.58 |        188846 |    20 | ADULT       | DINNER        | Dessert     | Dessert;Cold       | 9.58      |        2 | COUPLE           |
| 2016-11-08 20:21:24    |           534408 | Outlet 7  |                10 |               1531697 | 548    | Sambal Seafood Fried Rice   |     1 |   12.73 |      12.73 |        184698 |    25 | ADULT       | DINNER        | Main        | Friedrice;Seafood  | 12.73     |        1 | SOLO             |
| 2016-11-08 20:21:24    |           534408 | Outlet 7  |                10 |               1531698 | 759C   | Coke                        |     1 |    3.52 |       3.52 |        184698 |    25 | ADULT       | DINNER        | Drink       | Drink;Cold         | 3.52      |        1 | SOLO             |
| 2016-11-08 20:31:37    |           534439 | Outlet 3  |                 9 |               1531774 | 705    | Kopi                        |     1 |    2.06 |       2.06 |        169001 |    28 | ADULT       | DINNER        | Drink       | Drink;Hot          | 2.06      |        5 | GROUP            |
| 2016-11-08 20:31:37    |           534439 | Outlet 3  |                 9 |               1531776 | 753    | Iced Coffee-Tea             |     1 |    4.73 |       4.73 |        169001 |    28 | ADULT       | DINNER        | Drink       | Drink;Cold         | 4.73      |        5 | GROUP            |
| 2016-11-08 20:31:37    |           534439 | Outlet 3  |                 9 |               1531777 | 765    | Fresh  Lime Juice           |     1 |    5.94 |       5.94 |        169001 |    28 | ADULT       | DINNER        | Drink       | Drink;Cold         | 5.94      |        5 | GROUP            |
| 2016-11-08 20:31:37    |           534439 | Outlet 3  |                 9 |               1531778 | 780    | Iced Grass Jelly            |     1 |    3.52 |       3.52 |        169001 |    28 | ADULT       | DINNER        |             |                    |           |        5 | GROUP            |
| 2016-11-08 20:31:37    |           534439 | Outlet 3  |                 9 |               1531780 | 810    | SMOKED DUCK DRY CURRY RAMEN |     1 |   15.15 |      15.15 |        169001 |    28 | ADULT       | DINNER        | Main        | Noodle;Duck        | 15.15     |        5 | GROUP            |
| 2016-11-08 20:31:37    |           534439 | Outlet 3  |                 9 |               1531775 | 751    | Iced Milk Tea               |     1 |    4.73 |       4.73 |        169001 |    28 | ADULT       | DINNER        | Drink       | Drink;Cold         | 4.73      |        5 | GROUP            |
| 2016-11-08 20:31:37    |           534439 | Outlet 3  |                 9 |               1531772 | 307    | Prawn Paste Chicken         |     1 |    8.36 |       8.36 |        169001 |    28 | ADULT       | DINNER        | Side        | Fingerfood;Chicken | 8.36      |        5 | GROUP            |


Table #41
Filename: source_45.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item     | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat          | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:---------|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:------------------|:----------|---------:|:-----------------|
| 2016-07-02 17:19:33    |           377824 | Outlet 3  |                 9 |               1089829 | 705      | Kopi                    |     1 |    2.06 |       2.06 |        176167 |    53 | SENIOR      | LUNCH         | Drink       | Drink;Hot         | 2.06      |        2 | COUPLE           |
| 2016-07-02 18:01:28    |           377895 | Outlet 5  |                18 |               1090002 | 545      | Chicken Flos Fried Rice |     1 |   12.73 |      12.73 |        175493 |    67 | SENIOR      | DINNER        | Main        | Friedrice;Chicken | 12.73     |        3 | GROUP            |
| 2016-07-02 18:01:28    |           377895 | Outlet 5  |                18 |               1090001 | 68       | Pork Ribs BH            |     1 |   13.94 |      13.94 |        175493 |    67 | SENIOR      | DINNER        | Main        | Noodle;Pork       | 13.94     |        3 | GROUP            |
| 2016-07-02 18:01:28    |           377895 | Outlet 5  |                18 |               1090006 | TAKEAWAY | TAKEAWAY                |     1 |    0    |       0    |        175493 |    67 | SENIOR      | DINNER        |             |                   |           |        3 | GROUP            |
| 2016-07-02 18:01:28    |           377895 | Outlet 5  |                18 |               1090000 | 21       | Chicken Chop Cream Spag |     2 |   14.42 |      28.84 |        175493 |    67 | SENIOR      | DINNER        | Main        | Spaghetti;Chicken | 14.42     |        3 | GROUP            |
| 2016-07-02 18:31:43    |           377957 | Outlet 15 |                19 |               1090192 | 781      | Lychee Ice-blended      |     1 |    7.15 |       7.15 |        158264 |    43 | MIDDLE      | DINNER        | Drink       | Drink;Cold        | 7.15      |        1 | SOLO             |
| 2016-07-02 18:31:43    |           377957 | Outlet 15 |                19 |               1090189 | 43       | Pork Chop Bk Rice       |     1 |   15.15 |      15.15 |        158264 |    43 | MIDDLE      | DINNER        | Main        | Bakedrice;Pork    | 15.15     |        1 | SOLO             |
| 2016-07-02 18:53:00    |           378010 | Outlet 20 |                19 |               1090335 | 718      | Hot Honey with Lemon    |     1 |    4.73 |       4.73 |        175235 |    44 | MIDDLE      | DINNER        | Drink       | Drink;Hot         | 4.73      |        1 | SOLO             |
| 2016-07-02 18:53:00    |           378010 | Outlet 20 |                19 |               1090331 | 1136     | Fruit Jelly Pudding     |     1 |    9.58 |       9.58 |        175235 |    44 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold      | 9.58      |        1 | SOLO             |
| 2016-07-02 18:53:00    |           378010 | Outlet 20 |                19 |               1090329 | 780      | Iced Grass Jelly        |     1 |    3.52 |       0    |        175235 |    44 | MIDDLE      | DINNER        |             |                   |           |        1 | SOLO             |


Table #42
Filename: source_46.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                                |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-----------------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-05-16 15:30:06    |           320984 | Outlet 11 |                27 |                926675 | 767    | Iced Lychee Tea                          |     1 |    6.67 |       6.67 |        164744 |    41 | MIDDLE      | LUNCH         | Drink       | Drink;Cold         |      6.67 |        2 | COUPLE           |
| 2016-05-16 16:16:08    |           321001 | Outlet 3  |                 9 |                926723 | 632    | Fish Slice Muifan                        |     1 |   12.73 |      12.73 |        171164 |    25 | ADULT       | LUNCH         | Main        | Rice;Fish          |     12.73 |        1 | SOLO             |
| 2016-05-16 16:16:08    |           321001 | Outlet 3  |                 9 |                926724 | 759C   | Coke                                     |     1 |    3.52 |       3.52 |        171164 |    25 | ADULT       | LUNCH         | Drink       | Drink;Cold         |      3.52 |        1 | SOLO             |
| 2016-05-16 17:22:57    |           321027 | Outlet 5  |                18 |                926774 | 292    | Soft Boiled Eggs                         |     1 |    3.52 |       3.52 |        170067 |    32 | ADULT       | LUNCH         | Side        | Bread              |      3.52 |        1 | SOLO             |
| 2016-05-16 17:22:57    |           321027 | Outlet 5  |                18 |                926773 | 215B   | Pork Chop Bee Hoon                       |     1 |   13.94 |      13.94 |        170067 |    32 | ADULT       | LUNCH         | Main        | Noodle;Pork        |     13.94 |        1 | SOLO             |
| 2016-05-16 17:22:57    |           321027 | Outlet 5  |                18 |                926776 | 758    | Iced Soy Milk                            |     1 |    4.73 |       4.73 |        170067 |    32 | ADULT       | LUNCH         | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-05-16 17:22:57    |           321027 | Outlet 5  |                18 |                926775 | 753    | Iced Coffee-Tea                          |     1 |    4.73 |       4.73 |        170067 |    32 | ADULT       | LUNCH         | Drink       | Drink;Cold         |      4.73 |        1 | SOLO             |
| 2016-05-16 19:20:24    |           321142 | Outlet 3  |                 9 |                927051 | 509    | Braised Beef Brisket Soup Noodles        |     1 |   11.88 |      11.88 |        171166 |    21 | ADULT       | DINNER        | Main        | Noodlesoup;Beef    |     11.88 |        1 | SOLO             |
| 2016-05-16 19:26:21    |           321160 | Outlet 22 |                 4 |                927108 | 1175   | Homemade Cold Beancurd                   |     1 |    9.58 |       9.58 |         66774 |    44 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold       |     19.15 |        1 | SOLO             |
| 2016-05-16 19:26:21    |           321160 | Outlet 22 |                 4 |                927105 | 1110   | Chix Wing Home-made Sour 'N' Spicy Powde |     1 |    5.94 |       5.94 |         66774 |    44 | MIDDLE      | DINNER        | Side        | Fingerfood;Chicken |      5.94 |        1 | SOLO             |


Table #43
Filename: source_47.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                                |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-----------------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|----------:|---------:|:-----------------|
| 2016-11-27 20:37:28    |           558508 | Outlet 21 |                18 |               1601850 | 215B   | Pork Chop Bee Hoon                       |     2 |   13.94 |      27.88 |         72541 |    20 | ADULT       | DINNER        | Main        | Noodle;Pork                    |     13.94 |        3 | GROUP            |
| 2016-11-27 20:37:28    |           558508 | Outlet 21 |                18 |               1601852 | 549    | Signature Fried Rice                     |     1 |   13.94 |      13.94 |         72541 |    20 | ADULT       | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        3 | GROUP            |
| 2016-11-27 20:37:28    |           558508 | Outlet 21 |                18 |               1601849 | 1110   | Chix Wing Home-made Sour 'N' Spicy Powde |     1 |    5.94 |       5.94 |         72541 |    20 | ADULT       | DINNER        | Side        | Fingerfood;Chicken             |      5.94 |        3 | GROUP            |
| 2016-11-27 20:37:28    |           558508 | Outlet 21 |                18 |               1601851 | 404    | Custard Bun                              |     1 |    5.94 |       5.94 |         72541 |    20 | ADULT       | DINNER        | Side        | Dimsum;Chicken                 |      4.73 |        3 | GROUP            |
| 2016-11-27 20:37:28    |           558508 | Outlet 21 |                18 |               1601853 | 766    | Iced Honey Green Tea                     |     1 |    5.94 |       5.94 |         72541 |    20 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      5.94 |        3 | GROUP            |
| 2016-11-27 20:37:28    |           558508 | Outlet 21 |                18 |               1601847 | 1      | Cold / Iced Water                        |     3 |    0.73 |       2.19 |         72541 |    20 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      0.73 |        3 | GROUP            |
| 2016-11-27 20:37:28    |           558508 | Outlet 21 |                18 |               1601848 | 62     | Seafood Sauteed HF                       |     1 |   12.73 |      12.73 |         72541 |    20 | ADULT       | DINNER        | Main        | Noodle;Seafood                 |     12.73 |        3 | GROUP            |
| 2016-11-27 20:47:19    |           558533 | Outlet 11 |                27 |               1601918 | 21     | Chicken Chop Cream Spag                  |     1 |   14.42 |      14.42 |         66434 |    38 | MIDDLE      | DINNER        | Main        | Spaghetti;Chicken              |     14.42 |        3 | GROUP            |
| 2016-11-27 20:47:19    |           558533 | Outlet 11 |                27 |               1601921 | 702    | Milo                                     |     1 |    2.3  |       2.3  |         66434 |    38 | MIDDLE      | DINNER        | Drink       | Drink;Hot                      |      2.3  |        3 | GROUP            |
| 2016-11-27 20:47:19    |           558533 | Outlet 11 |                27 |               1601923 | 761    | Ice Milo Dinosaur                        |     1 |    5.45 |       5.45 |         66434 |    38 | MIDDLE      | DINNER        | Drink       | Drink;Cold                     |      5.45 |        3 | GROUP            |


Table #44
Filename: source_48.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                 |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat         |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:--------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-----------------|----------:|---------:|:-----------------|
| 2016-07-29 22:55:53    |           411590 | Outlet 3  |                 9 |               1186155 |    412 | Har Gao                   |     1 |    5.94 |       5.94 |         57027 |    46 | MIDDLE      | DINNER        | Side        | Dimsum;Seafood   |      5.94 |        1 | SOLO             |
| 2016-07-29 22:55:53    |           411590 | Outlet 3  |                 9 |               1186154 |    402 | Steam Pork Spare Ribs     |     1 |    5.94 |       5.94 |         57027 |    46 | MIDDLE      | DINNER        | Side        | Dimsum;Pork      |      5.94 |        1 | SOLO             |
| 2016-07-29 22:55:53    |           411590 | Outlet 3  |                 9 |               1186156 |    450 | Chicken In A Basket(3PCS) |     1 |   13.94 |      13.94 |         57027 |    46 | MIDDLE      | DINNER        | Side        | Dimsum;Chicken   |     13.94 |        1 | SOLO             |
| 2016-07-29 22:55:53    |           411590 | Outlet 3  |                 9 |               1186158 |    909 | Sliced Empress Congee     |     1 |   12    |      12    |         57027 |    46 | MIDDLE      | DINNER        | Main        | Porridge;Seafood |     12    |        1 | SOLO             |
| 2016-07-29 22:55:53    |           411590 | Outlet 3  |                 9 |               1186157 |    769 | Iced Lemon Tea            |     1 |    5.94 |       5.94 |         57027 |    46 | MIDDLE      | DINNER        | Drink       | Drink;Cold       |      5.94 |        1 | SOLO             |
| 2016-07-29 23:14:35    |           411615 | Outlet 17 |                 5 |               1186234 |    450 | Chicken In A Basket(3PCS) |     1 |   13.94 |      13.94 |        179129 |    32 | ADULT       | DINNER        | Side        | Dimsum;Chicken   |     13.94 |        2 | COUPLE           |
| 2016-07-29 23:14:35    |           411615 | Outlet 17 |                 5 |               1186236 |    766 | Iced Honey Green Tea      |     1 |    5.94 |       5.94 |        179129 |    32 | ADULT       | DINNER        | Drink       | Drink;Cold       |      5.94 |        2 | COUPLE           |
| 2016-07-29 23:14:35    |           411615 | Outlet 17 |                 5 |               1186233 |    109 | French Toast              |     1 |    5.94 |       5.94 |        179129 |    32 | ADULT       | DINNER        | Side        | Bread;Sweet      |      5.94 |        2 | COUPLE           |
| 2016-07-29 23:14:35    |           411615 | Outlet 17 |                 5 |               1186235 |    715 | Milk Tea                  |     1 |    4.24 |       4.24 |        179129 |    32 | ADULT       | DINNER        | Drink       | Drink;Hot        |      4.24 |        2 | COUPLE           |
| 2016-07-29 23:32:12    |           411635 | Outlet 17 |                 5 |               1186276 |    507 | Ham & Egg Soup Ndl        |     1 |    9.45 |       9.45 |         63072 |    45 | MIDDLE      | DINNER        | Main        | Noodlesoup;Pork  |      9.45 |        3 | GROUP            |


Table #45
Filename: source_49.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet   |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:---------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-10-19 21:01:19    |           509997 | Outlet 5 |                18 |               1459912 |    413 | SPRING ROLL                 |     1 |    5.94 |       5.94 |        185610 |    43 | MIDDLE      | DINNER        | Side        | Dimsum;Pork        |      5.94 |        1 | SOLO             |
| 2016-10-19 21:01:19    |           509997 | Outlet 5 |                18 |               1459910 |    407 | Radish Cake                 |     1 |    5.94 |       5.94 |        185610 |    43 | MIDDLE      | DINNER        | Side        | Dimsum;Pork        |      5.94 |        1 | SOLO             |
| 2016-10-19 21:01:19    |           509997 | Outlet 5 |                18 |               1459909 |    402 | Steam Pork Spare Ribs       |     1 |    5.94 |       5.94 |        185610 |    43 | MIDDLE      | DINNER        | Side        | Dimsum;Pork        |      5.94 |        1 | SOLO             |
| 2016-10-19 21:01:19    |           509997 | Outlet 5 |                18 |               1459915 |    713 | Hot Coffee-Tea              |     1 |    4.24 |       4.24 |        185610 |    43 | MIDDLE      | DINNER        | Drink       | Drink;Hot          |      4.24 |        1 | SOLO             |
| 2016-10-19 21:40:22    |           510046 | Outlet 2 |                 3 |               1460050 |   1283 | Deep Fried Prawn (3pcs)     |     1 |    0    |       0    |         67448 |    39 | MIDDLE      | DINNER        | Side        | Fingerfood;Seafood |   1000    |        1 | SOLO             |
| 2016-10-19 21:40:22    |           510046 | Outlet 2 |                 3 |               1460051 |    769 | Iced Lemon Tea              |     1 |    5.94 |       1.21 |         67448 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      5.94 |        1 | SOLO             |
| 2016-10-19 21:40:22    |           510046 | Outlet 2 |                 3 |               1460053 |    709 | Teh                         |     1 |    2.06 |       2.06 |         67448 |    39 | MIDDLE      | DINNER        | Drink       | Drink;Hot          |      2.06 |        1 | SOLO             |
| 2016-10-19 21:40:22    |           510046 | Outlet 2 |                 3 |               1460054 |    902 | Pork N Century Egg Congee   |     1 |   10.3  |      10.3  |         67448 |    39 | MIDDLE      | DINNER        | Main        | Porridge;Pork      |     10.3  |        1 | SOLO             |
| 2016-10-19 21:49:36    |           510057 | Outlet 2 |                 3 |               1460099 |    857 | Home-Made Cold Beancurd     |     1 |    3.52 |       3.52 |         51071 |    34 | ADULT       | DINNER        | Dessert     | Dessert;Cold       |      3.52 |        1 | SOLO             |
| 2016-10-19 22:28:03    |           510104 | Outlet 5 |                18 |               1460221 |    810 | SMOKED DUCK DRY CURRY RAMEN |     1 |   15.15 |      15.15 |        189532 |    29 | ADULT       | DINNER        | Main        | Noodle;Duck        |     15.15 |        1 | SOLO             |


Table #46
Filename: source_5.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-06-21 13:09:46    |           364133 | Outlet 15 |                19 |               1051055 |    854 | Sesame Cream Glutinous Ball |     2 |    6.67 |      13.34 |        181952 |    39 | MIDDLE      | LUNCH         | Dessert     | Dessert;Cold        |      6.67 |        1 | SOLO             |
| 2016-06-21 13:09:46    |           364133 | Outlet 15 |                19 |               1051054 |    753 | Iced Coffee-Tea             |     1 |    4.73 |       4.73 |        181952 |    39 | MIDDLE      | LUNCH         | Drink       | Drink;Cold          |      4.73 |        1 | SOLO             |
| 2016-06-21 13:09:46    |           364133 | Outlet 15 |                19 |               1051052 |     61 | CRISPY PRAWN NOODLE         |     1 |   16.36 |      16.36 |        181952 |    39 | MIDDLE      | LUNCH         | Main        | Noodle;Seafood      |     16.36 |        1 | SOLO             |
| 2016-06-21 13:13:08    |           364136 | Outlet 15 |                19 |               1051066 |    403 | Beancurd Skin Prawn Roll    |     1 |    6.67 |       6.67 |        181953 |    49 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork         |      6.67 |        2 | COUPLE           |
| 2016-06-21 13:13:08    |           364136 | Outlet 15 |                19 |               1051064 |     41 | BAKED RICE EBI              |     1 |   15.15 |      15.15 |        181953 |    49 | MIDDLE      | LUNCH         | Main        | BakedRice;Seafood   |     15.15 |        2 | COUPLE           |
| 2016-06-21 13:13:08    |           364136 | Outlet 15 |                19 |               1051065 |     74 | Wanton Soup Noodle          |     1 |   10.79 |      10.79 |        181953 |    49 | MIDDLE      | LUNCH         | Main        | Noodle;Pork;Seafood |     10.79 |        2 | COUPLE           |
| 2016-06-21 13:13:08    |           364136 | Outlet 15 |                19 |               1051068 |    753 | Iced Coffee-Tea             |     2 |    4.73 |       9.46 |        181953 |    49 | MIDDLE      | LUNCH         | Drink       | Drink;Cold          |      4.73 |        2 | COUPLE           |
| 2016-06-21 13:20:00    |           364151 | Outlet 6  |                22 |               1051121 |    767 | Iced Lychee Tea             |     2 |    6.67 |      13.34 |        160979 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Cold          |      6.67 |        7 | GROUP            |
| 2016-06-21 13:20:00    |           364151 | Outlet 6  |                22 |               1051112 |     17 | Fish Fillet Spag            |     1 |   12.73 |      12.73 |        160979 |    40 | MIDDLE      | LUNCH         | Main        | Spaghetti;Fish      |     12.73 |        7 | GROUP            |
| 2016-06-21 13:20:00    |           364151 | Outlet 6  |                22 |               1051113 |     21 | Chicken Chop Cream Spag     |     1 |   14.42 |      14.42 |        160979 |    40 | MIDDLE      | LUNCH         | Main        | Spaghetti;Chicken   |     14.42 |        7 | GROUP            |


Table #47
Filename: source_50.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc               |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       | d_price   |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|:----------|---------:|:-----------------|
| 2016-06-03 21:16:05    |           342631 | Outlet 21 |                18 |                987770 |    751 | Iced Milk Tea           |     1 |    4.73 |       4.73 |         63940 |    21 | ADULT       | DINNER        | Drink       | Drink;Cold                     | 4.73      |        2 | COUPLE           |
| 2016-06-03 21:16:05    |           342631 | Outlet 21 |                18 |                987769 |    549 | Signature Fried Rice    |     1 |   13.94 |      13.94 |         63940 |    21 | ADULT       | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken | 13.94     |        2 | COUPLE           |
| 2016-06-03 21:16:05    |           342631 | Outlet 21 |                18 |                987771 |    766 | Iced Honey Green Tea    |     1 |    5.94 |       5.94 |         63940 |    21 | ADULT       | DINNER        | Drink       | Drink;Cold                     | 5.94      |        2 | COUPLE           |
| 2016-06-03 21:16:05    |           342631 | Outlet 21 |                18 |                987768 |     21 | Chicken Chop Cream Spag |     1 |   14.42 |      14.42 |         63940 |    21 | ADULT       | DINNER        | Main        | Spaghetti;Chicken              | 14.42     |        2 | COUPLE           |
| 2016-06-03 21:17:40    |           342635 | Outlet 17 |                 5 |                987785 |   1175 | Homemade Cold Beancurd  |     1 |    9.58 |       9.58 |         58918 |    37 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold                   | 19.15     |        1 | SOLO             |
| 2016-06-03 21:17:40    |           342635 | Outlet 17 |                 5 |                987787 |    767 | Iced Lychee Tea         |     1 |    6.67 |       6.67 |         58918 |    37 | MIDDLE      | DINNER        | Drink       | Drink;Cold                     | 6.67      |        1 | SOLO             |
| 2016-06-03 21:17:40    |           342635 | Outlet 17 |                 5 |                987786 |    549 | Signature Fried Rice    |     1 |   13.94 |      13.94 |         58918 |    37 | MIDDLE      | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken | 13.94     |        1 | SOLO             |
| 2016-06-03 21:17:40    |           342635 | Outlet 17 |                 5 |                987783 |    769 | Iced Lemon Tea          |     1 |    5.94 |       0    |         58918 |    37 | MIDDLE      | DINNER        | Drink       | Drink;Cold                     | 5.94      |        1 | SOLO             |
| 2016-06-03 21:17:40    |           342635 | Outlet 17 |                 5 |                987784 |   1135 | Soup of the Day         |     1 |    0    |       0    |         58918 |    37 | MIDDLE      | DINNER        |             |                                |           |        1 | SOLO             |
| 2016-06-03 21:24:56    |           342652 | Outlet 21 |                18 |                987824 |    307 | Prawn Paste Chicken     |     1 |    8.36 |       8.36 |        172654 |    57 | SENIOR      | DINNER        | Side        | Fingerfood;Chicken             | 8.36      |        1 | SOLO             |


Table #48
Filename: source_51.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|----------:|---------:|:-----------------|
| 2016-10-08 20:16:29    |           497233 | Outlet 20 |                19 |               1422864 | 112    | F.Toast Ice Cream           |     1 |    7.88 |       7.88 |        160680 |    41 | MIDDLE      | DINNER        | Side        | Bread;Sweet                    |     23.64 |        2 | COUPLE           |
| 2016-10-08 20:16:29    |           497233 | Outlet 20 |                19 |               1422866 | 549    | Signature Fried Rice        |     2 |   13.94 |      27.88 |        160680 |    41 | MIDDLE      | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        2 | COUPLE           |
| 2016-10-08 20:16:29    |           497233 | Outlet 20 |                19 |               1422868 | 720    | Yuzu Tea                    |     1 |    3.88 |       3.88 |        160680 |    41 | MIDDLE      | DINNER        | Drink       | Drink;Hot                      |      3.88 |        2 | COUPLE           |
| 2016-10-08 20:16:29    |           497233 | Outlet 20 |                19 |               1422865 | 217B   | Fish Papaya Soup Beehoon    |     1 |   13.94 |      13.94 |        160680 |    41 | MIDDLE      | DINNER        | Main        | Noodlesoup;Fish                |     13.94 |        2 | COUPLE           |
| 2016-10-08 20:19:08    |           497243 | Outlet 1  |                20 |               1422893 | 767    | Iced Lychee Tea             |     1 |    6.67 |       6.67 |        187373 |    25 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      6.67 |        2 | COUPLE           |
| 2016-10-08 20:19:08    |           497243 | Outlet 1  |                20 |               1422890 | 403    | Beancurd Skin Prawn Roll    |     1 |    6.67 |       6.67 |        187373 |    25 | ADULT       | DINNER        | Side        | Dimsum;Pork                    |      6.67 |        2 | COUPLE           |
| 2016-10-08 20:19:08    |           497243 | Outlet 1  |                20 |               1422889 | 251    | Yao Ma Tei Chix Rice        |     1 |   13.94 |      13.94 |        187373 |    25 | ADULT       | DINNER        | Main        | Rice;Chicken                   |     13.94 |        2 | COUPLE           |
| 2016-10-08 20:19:08    |           497243 | Outlet 1  |                20 |               1422891 | 413    | SPRING ROLL                 |     1 |    5.94 |       5.94 |        187373 |    25 | ADULT       | DINNER        | Side        | Dimsum;Pork                    |      5.94 |        2 | COUPLE           |
| 2016-10-08 20:19:08    |           497243 | Outlet 1  |                20 |               1422892 | 608    | CHICKEN CHOP EGG DRY NOODLE |     1 |   12    |      12    |        187373 |    25 | ADULT       | DINNER        | Main        | Noodle;Chicken                 |     12    |        2 | COUPLE           |
| 2016-10-08 20:23:55    |           497262 | Outlet 14 |                16 |               1422944 | 1      | Cold / Iced Water           |     1 |    0.73 |       0.73 |        170617 |    49 | MIDDLE      | DINNER        | Drink       | Drink;Cold                     |      0.73 |        1 | SOLO             |


Table #49
Filename: source_52.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-09-04 19:18:22    |           458392 | Outlet 7  |                10 |               1315144 | 767    | Iced Lychee Tea          |     1 |    6.67 |       6.67 |        181558 |    38 | MIDDLE      | DINNER        | Drink       | Drink;Cold          |      6.67 |        4 | GROUP            |
| 2016-09-04 19:18:22    |           458392 | Outlet 7  |                10 |               1315137 | 74     | Wanton Soup Noodle       |     1 |   10.79 |      10.79 |        181558 |    38 | MIDDLE      | DINNER        | Main        | Noodle;Pork;Seafood |     10.79 |        4 | GROUP            |
| 2016-09-04 19:18:22    |           458392 | Outlet 7  |                10 |               1315134 | 2      | Warm Water               |     2 |    1.45 |       2.9  |        181558 |    38 | MIDDLE      | DINNER        | Drink       | Drink;Hot           |      0.73 |        4 | GROUP            |
| 2016-09-04 19:18:22    |           458392 | Outlet 7  |                10 |               1315143 | 552    | Mango Pomelo             |     1 |    8.36 |       8.36 |        181558 |    38 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold        |      8.36 |        4 | GROUP            |
| 2016-09-04 19:18:22    |           458392 | Outlet 7  |                10 |               1315139 | 217B   | Fish Papaya Soup Beehoon |     1 |   13.94 |      13.94 |        181558 |    38 | MIDDLE      | DINNER        | Main        | Noodlesoup;Fish     |     13.94 |        4 | GROUP            |
| 2016-09-04 19:18:22    |           458392 | Outlet 7  |                10 |               1315138 | 112    | F.Toast Ice Cream        |     1 |    7.88 |       7.88 |        181558 |    38 | MIDDLE      | DINNER        | Side        | Bread;Sweet         |     23.64 |        4 | GROUP            |
| 2016-09-04 19:18:26    |           458393 | Outlet 23 |                19 |               1315155 | 720    | Yuzu Tea                 |     1 |    3.88 |       3.88 |        177185 |    26 | ADULT       | DINNER        | Drink       | Drink;Hot           |      3.88 |        2 | COUPLE           |
| 2016-09-04 19:18:26    |           458393 | Outlet 23 |                19 |               1315153 | 67     | Signature Fried Noodles  |     2 |   13.94 |      27.88 |        177185 |    26 | ADULT       | DINNER        | Main        | Noodle;Pork         |     13.94 |        2 | COUPLE           |
| 2016-09-04 19:18:26    |           458393 | Outlet 23 |                19 |               1315158 | 776    | Watermelon Ice-Blended   |     1 |    7.15 |       7.15 |        177185 |    26 | ADULT       | DINNER        | Drink       | Drink;Cold          |      7.15 |        2 | COUPLE           |
| 2016-09-04 19:18:26    |           458393 | Outlet 23 |                19 |               1315156 | 765    | Lime Juice               |     1 |    5.94 |       5.94 |        177185 |    26 | ADULT       | DINNER        | Drink       | Drink;Cold          |      5.94 |        2 | COUPLE           |


Table #50
Filename: source_53.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-10-30 12:33:08    |           522684 | Outlet 23 |                19 |               1497005 |     78 | SPECIAL STIR FRIED BEE HOON |     1 |   12.73 |      12.73 |        167621 |    31 | ADULT       | LUNCH         | Main        | Noodle;Pork;Seafood |     12.73 |        2 | COUPLE           |
| 2016-10-30 12:35:57    |           522688 | Outlet 13 |                 9 |               1497032 |    418 | BBQ Pork Bun                |     1 |    5.45 |       5.45 |        192156 |    60 | SENIOR      | LUNCH         | Side        | Dimsum;Pork         |      5.45 |        2 | COUPLE           |
| 2016-10-30 12:35:57    |           522688 | Outlet 13 |                 9 |               1497034 |    783 | Iced Coffee-Tea Float       |     1 |    8.36 |       8.36 |        192156 |    60 | SENIOR      | LUNCH         | Drink       | Drink;Cold          |      8.36 |        2 | COUPLE           |
| 2016-10-30 12:35:57    |           522688 | Outlet 13 |                 9 |               1497035 |    903 | Sampan Congee               |     1 |   11.51 |      11.51 |        192156 |    60 | SENIOR      | LUNCH         | Main        | Porridge;Seafood    |     11.51 |        2 | COUPLE           |
| 2016-10-30 12:35:57    |           522688 | Outlet 13 |                 9 |               1497030 |     61 | CRISPY PRAWN NOODLE         |     1 |   16.36 |      16.36 |        192156 |    60 | SENIOR      | LUNCH         | Main        | Noodle;Seafood      |     16.36 |        2 | COUPLE           |
| 2016-10-30 12:35:57    |           522688 | Outlet 13 |                 9 |               1497031 |    404 | Custard Bun                 |     1 |    5.94 |       5.94 |        192156 |    60 | SENIOR      | LUNCH         | Side        | Dimsum;Chicken      |      4.73 |        2 | COUPLE           |
| 2016-10-30 12:51:36    |           522730 | Outlet 15 |                19 |               1497147 |    701 | Chinese Tea                 |     1 |    2.06 |       2.06 |        182265 |    42 | MIDDLE      | LUNCH         | Drink       | Drink;Hot           |      2.06 |        4 | GROUP            |
| 2016-10-30 12:51:36    |           522730 | Outlet 15 |                19 |               1497140 |      1 | Cold / Iced Water           |     3 |    0.73 |       2.19 |        182265 |    42 | MIDDLE      | LUNCH         | Drink       | Drink;Cold          |      0.73 |        4 | GROUP            |
| 2016-10-30 12:51:36    |           522730 | Outlet 15 |                19 |               1497146 |    608 | CHICKEN CHOP EGG DRY NOODLE |     1 |   12    |      12    |        182265 |    42 | MIDDLE      | LUNCH         | Main        | Noodle;Chicken      |     12    |        4 | GROUP            |
| 2016-10-30 12:51:36    |           522730 | Outlet 15 |                19 |               1497144 |    521 | VEGETARIAN HOR FUN          |     1 |   10.3  |      10.3  |        182265 |    42 | MIDDLE      | LUNCH         | Main        | Noodle;Vegetarian   |     10.3  |        4 | GROUP            |


Table #51
Filename: source_54.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                            |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat          |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-------------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:------------------|----------:|---------:|:-----------------|
| 2016-11-04 19:59:41    |           528847 | Outlet 15 |                19 |               1515059 | 758    | Iced Soy Milk                        |     1 |    4.73 |       4.73 |        165252 |    32 | ADULT       | DINNER        | Drink       | Drink;Cold        |      4.73 |        1 | SOLO             |
| 2016-11-04 19:59:41    |           528847 | Outlet 15 |                19 |               1515056 | 215A   | Pork Chop Noodle                     |     1 |   13.94 |      13.94 |        165252 |    32 | ADULT       | DINNER        | Main        | Noodle;Pork       |     13.94 |        1 | SOLO             |
| 2016-11-04 20:02:04    |           528857 | Outlet 21 |                18 |               1515085 | 545    | Chicken Flos Fried Rice              |     1 |   12.73 |      12.73 |        196184 |    41 | MIDDLE      | DINNER        | Main        | Friedrice;Chicken |     12.73 |        2 | COUPLE           |
| 2016-11-04 20:02:04    |           528857 | Outlet 21 |                18 |               1515084 | 21     | Chicken Chop Cream Spag              |     1 |   14.42 |      14.42 |        196184 |    41 | MIDDLE      | DINNER        | Main        | Spaghetti;Chicken |     14.42 |        2 | COUPLE           |
| 2016-11-04 20:02:04    |           528857 | Outlet 21 |                18 |               1515086 | 753    | Iced Coffee-Tea                      |     1 |    4.73 |       4.73 |        196184 |    41 | MIDDLE      | DINNER        | Drink       | Drink;Cold        |      4.73 |        2 | COUPLE           |
| 2016-11-04 20:02:51    |           528859 | Outlet 9  |                19 |               1515101 | 251    | Yao Ma Tei Chix Rice                 |     1 |   13.94 |      13.94 |        190875 |    40 | MIDDLE      | DINNER        | Main        | Rice;Chicken      |     13.94 |        2 | COUPLE           |
| 2016-11-04 20:02:51    |           528859 | Outlet 9  |                19 |               1515104 | 782    | Peach Ice-blended                    |     1 |    7.15 |       7.15 |        190875 |    40 | MIDDLE      | DINNER        | Drink       | Drink;Cold        |     14.3  |        2 | COUPLE           |
| 2016-11-04 20:02:51    |           528859 | Outlet 9  |                19 |               1515103 | 418    | BBQ Pork Bun                         |     1 |    5.45 |       5.45 |        190875 |    40 | MIDDLE      | DINNER        | Side        | Dimsum;Pork       |      5.45 |        2 | COUPLE           |
| 2016-11-04 20:02:51    |           528859 | Outlet 9  |                19 |               1515102 | 294    | Seafood and Slice Pork Macaroni Soup |     1 |   10.3  |      10.3  |        190875 |    40 | MIDDLE      | DINNER        | Main        | Soup;Seafood;Pork |     10.3  |        2 | COUPLE           |
| 2016-11-04 20:04:04    |           528865 | Outlet 11 |                27 |               1515109 | 1136   | Fruit Jelly Pudding                  |     1 |    9.58 |       9.58 |        180110 |    40 | MIDDLE      | DINNER        | Dessert     | Dessert;Cold      |      9.58 |        2 | COUPLE           |


Table #52
Filename: source_55.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                 |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat                       |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:--------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------------------|----------:|---------:|:-----------------|
| 2016-12-22 19:21:04    |           589354 | Outlet 18 |                23 |               1689277 | 718    | Hot Honey with Lemon      |     1 |    4.73 |       4.73 |         70168 |    29 | ADULT       | DINNER        | Drink       | Drink;Hot                      |      4.73 |        2 | COUPLE           |
| 2016-12-22 19:21:04    |           589354 | Outlet 18 |                23 |               1689278 | 906    | Spicy Pork Por            |     1 |   10.3  |      10.3  |         70168 |    29 | ADULT       | DINNER        | Main        | Porridge;Pork                  |     10.3  |        2 | COUPLE           |
| 2016-12-22 19:35:36    |           589399 | Outlet 14 |                16 |               1689387 | 704    | Fresh Soy Milk            |     1 |    3.52 |       3.52 |         67802 |    43 | MIDDLE      | DINNER        | Drink       | Drink;Hot                      |      3.52 |        1 | SOLO             |
| 2016-12-22 19:35:36    |           589399 | Outlet 14 |                16 |               1689386 | 215B   | Pork Chop Bee Hoon        |     1 |   13.94 |      13.94 |         67802 |    43 | MIDDLE      | DINNER        | Main        | Noodle;Pork                    |     13.94 |        1 | SOLO             |
| 2016-12-22 19:38:06    |           589414 | Outlet 21 |                18 |               1689417 | 68     | Pork Ribs BH              |     1 |   13.94 |      13.94 |        170777 |    23 | ADULT       | DINNER        | Main        | Noodle;Pork                    |     13.94 |        2 | COUPLE           |
| 2016-12-22 19:38:06    |           589414 | Outlet 21 |                18 |               1689418 | 548    | Sambal Seafood Fried Rice |     1 |   12.73 |      12.73 |        170777 |    23 | ADULT       | DINNER        | Main        | Friedrice;Seafood              |     12.73 |        2 | COUPLE           |
| 2016-12-22 19:38:06    |           589414 | Outlet 21 |                18 |               1689421 | 751    | Iced Milk Tea             |     1 |    4.73 |       4.73 |        170777 |    23 | ADULT       | DINNER        | Drink       | Drink;Cold                     |      4.73 |        2 | COUPLE           |
| 2016-12-22 19:38:06    |           589414 | Outlet 21 |                18 |               1689420 | 715    | Milk Tea                  |     1 |    4.24 |       4.24 |        170777 |    23 | ADULT       | DINNER        | Drink       | Drink;Hot                      |      4.24 |        2 | COUPLE           |
| 2016-12-22 19:41:49    |           589423 | Outlet 12 |                 5 |               1689447 | 403    | Beancurd Skin Prawn Roll  |     1 |    6.67 |       6.67 |        191808 |    24 | ADULT       | DINNER        | Side        | Dimsum;Pork                    |      6.67 |        2 | COUPLE           |
| 2016-12-22 19:41:49    |           589423 | Outlet 12 |                 5 |               1689449 | 549    | Signature Fried Rice      |     1 |   13.94 |      13.94 |        191808 |    24 | ADULT       | DINNER        | Main        | Friedrice;Pork;Seafood;Chicken |     13.94 |        2 | COUPLE           |


Table #53
Filename: source_56.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat        |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:----------------|----------:|---------:|:-----------------|
| 2016-12-08 18:46:02    |           570759 | Outlet 6  |                22 |               1635915 | 713    | Hot Coffee-Tea           |     1 |    4.24 |       4.24 |        158002 |    52 | SENIOR      | DINNER        | Drink       | Drink;Hot       |      4.24 |        1 | SOLO             |
| 2016-12-08 19:11:26    |           570808 | Outlet 18 |                23 |               1636026 | 2      | Warm Water               |     2 |    1.45 |       2.9  |        183437 |    53 | SENIOR      | DINNER        | Drink       | Drink;Hot       |      0.73 |        1 | SOLO             |
| 2016-12-08 19:11:26    |           570808 | Outlet 18 |                23 |               1636027 | 67     | Signature Fried Noodles  |     1 |   13.94 |      13.94 |        183437 |    53 | SENIOR      | DINNER        | Main        | Noodle;Pork     |     13.94 |        1 | SOLO             |
| 2016-12-08 19:13:55    |           570812 | Outlet 18 |                23 |               1636045 | 46     | Fish Bk Rice             |     1 |   13.94 |      13.94 |        200710 |    30 | ADULT       | DINNER        | Main        | Bakedrice;Fish  |     13.94 |        1 | SOLO             |
| 2016-12-08 19:16:08    |           570820 | Outlet 9  |                19 |               1636068 | 306    | Bo Lo Bun                |     1 |    3.52 |       3.52 |         60538 |    38 | MIDDLE      | DINNER        | Side        | Bread           |      3.52 |        3 | GROUP            |
| 2016-12-08 19:16:08    |           570820 | Outlet 9  |                19 |               1636065 | 67     | Signature Fried Noodles  |     1 |   13.94 |      13.94 |         60538 |    38 | MIDDLE      | DINNER        | Main        | Noodle;Pork     |     13.94 |        3 | GROUP            |
| 2016-12-08 19:16:08    |           570820 | Outlet 9  |                19 |               1636067 | 217B   | Fish Papaya Soup Beehoon |     1 |   13.94 |      13.94 |         60538 |    38 | MIDDLE      | DINNER        | Main        | Noodlesoup;Fish |     13.94 |        3 | GROUP            |
| 2016-12-08 19:16:08    |           570820 | Outlet 9  |                19 |               1636069 | 507    | Ham & Egg Soup Ndl       |     1 |    9.45 |       9.45 |         60538 |    38 | MIDDLE      | DINNER        | Main        | Noodlesoup;Pork |      9.45 |        3 | GROUP            |
| 2016-12-08 20:00:55    |           570952 | Outlet 5  |                18 |               1636437 | 795    | SOUR PLUM COKE           |     1 |    5.94 |       5.94 |        201975 |    34 | ADULT       | DINNER        | Drink       | Drink;Cold      |      5.94 |        1 | SOLO             |
| 2016-12-08 20:00:55    |           570952 | Outlet 5  |                18 |               1636436 | 769    | Iced Lemon Tea           |     1 |    5.94 |       5.94 |        201975 |    34 | ADULT       | DINNER        | Drink       | Drink;Cold      |      5.94 |        1 | SOLO             |


Table #54
Filename: source_6.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                     |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat           |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:------------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:-------------------|----------:|---------:|:-----------------|
| 2016-11-23 19:46:26    |           552628 | Outlet 13 |                 9 |               1584795 | 215B   | Pork Chop Bee Hoon            |     1 |   27.88 |      27.88 |        195208 |    31 | ADULT       | DINNER        | Main        | Noodle;Pork        |     13.94 |        4 | GROUP            |
| 2016-11-23 19:55:35    |           552665 | Outlet 15 |                19 |               1584914 | 411    | Pan Fried Dumpling            |     1 |    7.88 |       7.88 |        201680 |    41 | MIDDLE      | DINNER        | Side        | Dimsum;Pork        |      7.88 |        2 | COUPLE           |
| 2016-11-23 19:55:35    |           552665 | Outlet 15 |                19 |               1584913 | 769    | Iced Lemon Tea                |     1 |    5.94 |       1.21 |        201680 |    41 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      5.94 |        2 | COUPLE           |
| 2016-11-23 19:55:35    |           552665 | Outlet 15 |                19 |               1584916 | 767    | Iced Lychee Tea               |     1 |    6.67 |       6.67 |        201680 |    41 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      6.67 |        2 | COUPLE           |
| 2016-11-23 19:55:35    |           552665 | Outlet 15 |                19 |               1584912 | 1283   | Deep Fried Prawn (3pcs)       |     1 |    0    |       0    |        201680 |    41 | MIDDLE      | DINNER        | Side        | Fingerfood;Seafood |   1000    |        2 | COUPLE           |
| 2016-11-23 19:55:35    |           552665 | Outlet 15 |                19 |               1584917 | 904    | Fish Slice Por                |     1 |   10.3  |      10.3  |        201680 |    41 | MIDDLE      | DINNER        | Main        | Porridge;Fish      |     10.3  |        2 | COUPLE           |
| 2016-11-23 19:55:35    |           552665 | Outlet 15 |                19 |               1584915 | 412    | Har Gao                       |     1 |    5.94 |       5.94 |        201680 |    41 | MIDDLE      | DINNER        | Side        | Dimsum;Seafood     |      5.94 |        2 | COUPLE           |
| 2016-11-23 19:55:35    |           552665 | Outlet 15 |                19 |               1584909 | 24     | SCALLOP CREAM SAUCE SPAGHETTI |     1 |   17.58 |      17.58 |        201680 |    41 | MIDDLE      | DINNER        | Main        | Spaghetti;Seafood  |     17.58 |        2 | COUPLE           |
| 2016-11-23 19:56:43    |           552672 | Outlet 11 |                27 |               1584942 | 753    | Iced Coffee-Tea               |     3 |    4.73 |      14.19 |        195037 |    49 | MIDDLE      | DINNER        | Drink       | Drink;Cold         |      4.73 |        3 | GROUP            |
| 2016-11-23 19:56:43    |           552672 | Outlet 11 |                27 |               1584941 | 632    | Fish Slice Muifan             |     1 |   12.73 |      12.73 |        195037 |    49 | MIDDLE      | DINNER        | Main        | Rice;Fish          |     12.73 |        3 | GROUP            |


Table #55
Filename: source_7.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat             |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:---------------------|----------:|---------:|:-----------------|
| 2016-05-22 14:14:03    |           328329 | Outlet 5  |                18 |                947498 | 859    | SOY MILK WITH GLUTINOUS BALL |     1 |    6.67 |       6.67 |        161368 |    51 | SENIOR      | LUNCH         | Dessert     | Dessert;Cold         |      6.67 |        2 | COUPLE           |
| 2016-05-22 14:29:36    |           328377 | Outlet 17 |                 5 |                947612 | 720    | Yuzu Tea                     |     1 |    3.88 |       3.88 |        162657 |    50 | MIDDLE      | LUNCH         | Drink       | Drink;Hot            |      3.88 |        1 | SOLO             |
| 2016-05-22 14:29:36    |           328377 | Outlet 17 |                 5 |                947611 | 215B   | Pork Chop Bee Hoon           |     1 |   13.94 |      13.94 |        162657 |    50 | MIDDLE      | LUNCH         | Main        | Noodle;Pork          |     13.94 |        1 | SOLO             |
| 2016-05-22 14:29:36    |           328377 | Outlet 17 |                 5 |                947610 | 109    | French Toast                 |     1 |    5.94 |       5.94 |        162657 |    50 | MIDDLE      | LUNCH         | Side        | Bread;Sweet          |      5.94 |        1 | SOLO             |
| 2016-05-22 14:36:00    |           328395 | Outlet 5  |                18 |                947672 | 418    | BBQ Pork Bun                 |     1 |    5.45 |       5.45 |         61281 |    39 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork          |      5.45 |        2 | COUPLE           |
| 2016-05-22 14:36:00    |           328395 | Outlet 5  |                18 |                947671 | 414    | Chix Feet                    |     1 |    5.94 |       5.94 |         61281 |    39 | MIDDLE      | LUNCH         | Side        | Dimsum;Chicken       |      5.94 |        2 | COUPLE           |
| 2016-05-22 14:36:00    |           328395 | Outlet 5  |                18 |                947673 | 715    | Milk Tea                     |     1 |    4.24 |       4.24 |         61281 |    39 | MIDDLE      | LUNCH         | Drink       | Drink;Hot            |      4.24 |        2 | COUPLE           |
| 2016-05-22 14:36:00    |           328395 | Outlet 5  |                18 |                947669 | 22     | Mushroom Cream Spag          |     1 |   12    |      12    |         61281 |    39 | MIDDLE      | LUNCH         | Main        | Spaghetti;Vegetarian |     12    |        2 | COUPLE           |
| 2016-05-22 14:36:00    |           328395 | Outlet 5  |                18 |                947675 | 854    | Sesame Cream Glutinous Ball  |     1 |    6.67 |       6.67 |         61281 |    39 | MIDDLE      | LUNCH         | Dessert     | Dessert;Cold         |      6.67 |        2 | COUPLE           |
| 2016-05-22 14:36:00    |           328395 | Outlet 5  |                18 |                947676 | 902    | Cent Egg Pork Por            |     1 |   10.3  |      10.3  |         61281 |    39 | MIDDLE      | LUNCH         | Main        | Porridge;Pork        |     10.3  |        2 | COUPLE           |


Table #56
Filename: source_8.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id |   item | item_desc                   |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|-------:|:----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-06-26 13:53:02    |           370630 | Outlet 19 |                 5 |               1069669 |    412 | Har Gao                     |     1 |    5.94 |       5.94 |        158779 |    30 | ADULT       | LUNCH         | Side        | Dimsum;Seafood      |      5.94 |        1 | SOLO             |
| 2016-06-26 13:53:02    |           370630 | Outlet 19 |                 5 |               1069670 |    701 | Chinese Tea                 |     2 |    2.06 |       4.12 |        158779 |    30 | ADULT       | LUNCH         | Drink       | Drink;Hot           |      2.06 |        1 | SOLO             |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069673 |     78 | SPECIAL STIR FRIED BEE HOON |     1 |   12.73 |      12.73 |         60135 |    40 | MIDDLE      | LUNCH         | Main        | Noodle;Pork;Seafood |     12.73 |        5 | GROUP            |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069678 |    407 | Radish Cake                 |     1 |    5.94 |       5.94 |         60135 |    40 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork         |      5.94 |        5 | GROUP            |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069679 |    411 | Pan Fried Dumpling          |     1 |    7.88 |       7.88 |         60135 |    40 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork         |      7.88 |        5 | GROUP            |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069671 |     43 | Pork Chop Bk Rice           |     1 |   15.15 |      15.15 |         60135 |    40 | MIDDLE      | LUNCH         | Main        | Bakedrice;Pork      |     15.15 |        5 | GROUP            |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069683 |    767 | Iced Lychee Tea             |     2 |    6.67 |      13.34 |         60135 |    40 | MIDDLE      | LUNCH         | Drink       | Drink;Cold          |      6.67 |        5 | GROUP            |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069672 |     45 | Chix Chop Bk Rice           |     1 |   15.15 |      15.15 |         60135 |    40 | MIDDLE      | LUNCH         | Main        | Bakedrice;Chicken   |     15.15 |        5 | GROUP            |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069674 |    126 | L.Meat'N'Egg S'wich         |     1 |    4.73 |       4.73 |         60135 |    40 | MIDDLE      | LUNCH         | Side        | Bread;Savoury       |      4.73 |        5 | GROUP            |
| 2016-06-26 13:53:14    |           370631 | Outlet 8  |                22 |               1069680 |    413 | SPRING ROLL                 |     1 |    5.94 |       5.94 |         60135 |    40 | MIDDLE      | LUNCH         | Side        | Dimsum;Pork         |      5.94 |        5 | GROUP            |


Table #57
Filename: source_9.csv
Sample Rows in Markdown:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc                    |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat              |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:-----------------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:----------------------|----------:|---------:|:-----------------|
| 2016-07-06 17:43:47    |           383934 | Outlet 18 |                23 |               1108331 | 1211   | Spicy Sour Fries             |     1 |    2.42 |       2.42 |        174037 |    20 | ADULT       | LUNCH         | Side        | Fingerfood;Vegetarian |      2.42 |        1 | SOLO             |
| 2016-07-06 17:43:47    |           383934 | Outlet 18 |                23 |               1108329 | 14     | BP Chix Spag                 |     1 |   12.73 |      12.73 |        174037 |    20 | ADULT       | LUNCH         | Main        | Spaghetti;Chicken     |     12.73 |        1 | SOLO             |
| 2016-07-06 17:43:47    |           383934 | Outlet 18 |                23 |               1108332 | 413    | SPRING ROLL                  |     1 |    5.94 |       5.94 |        174037 |    20 | ADULT       | LUNCH         | Side        | Dimsum;Pork           |      5.94 |        1 | SOLO             |
| 2016-07-06 17:46:25    |           383938 | Outlet 6  |                22 |               1108355 | 820    | Minced Kai Lan W Silver Fish |     1 |   11.51 |      11.51 |        174811 |    36 | MIDDLE      | LUNCH         | Side        | Vegetable;Seafood     |     11.51 |        1 | SOLO             |
| 2016-07-06 17:46:25    |           383938 | Outlet 6  |                22 |               1108354 | 216B   | Chicken Papaya Soup Beehoon  |     1 |   13.94 |      13.94 |        174811 |    36 | MIDDLE      | LUNCH         | Main        | Noodlesoup;Chicken    |     13.94 |        1 | SOLO             |
| 2016-07-06 17:53:49    |           383946 | Outlet 20 |                19 |               1108389 | 68     | Pork Ribs BH                 |     1 |   13.94 |      13.94 |        175311 |    46 | MIDDLE      | LUNCH         | Main        | Noodle;Pork           |     13.94 |        1 | SOLO             |
| 2016-07-06 17:53:49    |           383946 | Outlet 20 |                19 |               1108392 | 767    | Iced Lychee Tea              |     1 |    6.67 |       6.67 |        175311 |    46 | MIDDLE      | LUNCH         | Drink       | Drink;Cold            |      6.67 |        1 | SOLO             |
| 2016-07-06 17:53:49    |           383946 | Outlet 20 |                19 |               1108390 | 106    | Condensed & Peanut TT        |     1 |    5.94 |       5.94 |        175311 |    46 | MIDDLE      | LUNCH         | Side        | Bread;Sweet           |      5.94 |        1 | SOLO             |
| 2016-07-06 17:53:49    |           383946 | Outlet 20 |                19 |               1108391 | 720    | Yuzu Tea                     |     1 |    3.88 |       3.88 |        175311 |    46 | MIDDLE      | LUNCH         | Drink       | Drink;Hot             |      3.88 |        1 | SOLO             |
| 2016-07-06 18:23:37    |           384018 | Outlet 22 |                 4 |               1108574 | 608    | CHICKEN CHOP EGG DRY NOODLE  |     1 |   12    |      12    |        183111 |    33 | ADULT       | DINNER        | Main        | Noodle;Chicken        |     12    |        1 | SOLO             |


Target Schema:
| transaction_datetime   |   transaction_id | outlet    |   outlet_district |   transact_details_id | item   | item_desc           |   qty |   price |   spending |   customer_id |   age | age_group   | time_of_day   | item_type   | item_cat            |   d_price |   numpax | group_category   |
|:-----------------------|-----------------:|:----------|------------------:|----------------------:|:-------|:--------------------|------:|--------:|-----------:|--------------:|------:|:------------|:--------------|:------------|:--------------------|----------:|---------:|:-----------------|
| 2016-01-01 00:03:32    |           183005 | Outlet 11 |                27 |                537565 | 552    | Mango Pomelo        |     1 |    8.36 |       8.36 |         54234 |    40 | MIDDLE      | SUPPER        | Dessert     | Dessert;Cold        |      8.36 |        1 | SOLO             |
| 2016-01-01 00:03:32    |           183005 | Outlet 11 |                27 |                537564 | 215B   | Pork Chop Bee Hoon  |     1 |   13.94 |      13.94 |         54234 |    40 | MIDDLE      | SUPPER        | Main        | Noodle;Pork         |     13.94 |        1 | SOLO             |
| 2016-01-01 09:51:39    |           183062 | Outlet 11 |                27 |                537715 | 407    | Radish Cake         |     1 |    5.94 |       5.94 |         54242 |    35 | ADULT       | BREAKFAST     | Side        | Dimsum;Pork         |      5.94 |        2 | COUPLE           |
| 2016-01-01 09:51:39    |           183062 | Outlet 11 |                27 |                537712 | 713    | Hot Coffee-Tea      |     1 |    4.24 |       0    |         54242 |    35 | ADULT       | BREAKFAST     | Drink       | Drink;Hot           |      4.24 |        2 | COUPLE           |
| 2016-01-01 09:51:39    |           183062 | Outlet 11 |                27 |                537713 | 126    | L.Meat'N'Egg S'wich |     1 |    4.73 |       4.73 |         54242 |    35 | ADULT       | BREAKFAST     | Side        | Bread;Savoury       |      4.73 |        2 | COUPLE           |
| 2016-01-01 09:51:39    |           183062 | Outlet 11 |                27 |                537717 | 751    | Iced Milk Tea       |     1 |    4.73 |       4.73 |         54242 |    35 | ADULT       | BREAKFAST     | Drink       | Drink;Cold          |      4.73 |        2 | COUPLE           |
| 2016-01-01 09:51:39    |           183062 | Outlet 11 |                27 |                537714 | 401    | Siew Mai            |     1 |    5.45 |       5.45 |         54242 |    35 | ADULT       | BREAKFAST     | Side        | Dimsum;Seafood;Pork |      5.45 |        2 | COUPLE           |
| 2016-01-01 10:19:52    |           183070 | Outlet 11 |                27 |                537743 | 713    | Hot Coffee-Tea      |     1 |    4.24 |       4.24 |         79349 |    48 | MIDDLE      | BREAKFAST     | Drink       | Drink;Hot           |      4.24 |        1 | SOLO             |
| 2016-01-01 10:19:52    |           183070 | Outlet 11 |                27 |                537739 | 401    | Siew Mai            |     1 |    5.45 |       5.45 |         79349 |    48 | MIDDLE      | BREAKFAST     | Side        | Dimsum;Seafood;Pork |      5.45 |        1 | SOLO             |
| 2016-01-01 10:19:52    |           183070 | Outlet 11 |                27 |                537744 | 751    | Iced Milk Tea       |     1 |    4.73 |       4.73 |         79349 |    48 | MIDDLE      | BREAKFAST     | Drink       | Drink;Cold          |      4.73 |        1 | SOLO             |

Return only the final code in markdown codeblock format, without any additional text or explanation. 



target: target.csv
train: source_0.csv
source_1.csv
source_10.csv
source_11.csv
source_12.csv
source_13.csv
source_14.csv
source_15.csv
source_16.csv
source_17.csv
source_18.csv
source_19.csv
source_2.csv
source_20.csv
source_21.csv
source_22.csv
source_23.csv
source_24.csv
source_25.csv
source_26.csv
source_27.csv
source_28.csv
source_29.csv
source_3.csv
source_30.csv
source_31.csv
source_32.csv
source_33.csv
source_34.csv
source_35.csv
source_36.csv
source_37.csv
source_38.csv
source_39.csv
source_4.csv
source_40.csv
source_41.csv
source_42.csv
source_43.csv
source_44.csv
source_45.csv
source_46.csv
source_47.csv
source_48.csv
source_49.csv
source_5.csv
source_50.csv
source_51.csv
source_52.csv
source_53.csv
source_54.csv
source_55.csv
source_56.csv
source_6.csv
source_7.csv
source_8.csv
source_9.csv
test: test_0.csv
test_1.csv
test_10.csv
test_11.csv
test_12.csv
test_13.csv
test_14.csv
test_15.csv
test_16.csv
test_17.csv
test_18.csv
test_19.csv
test_2.csv
test_20.csv
test_21.csv
test_22.csv
test_23.csv
test_24.csv
test_25.csv
test_26.csv
test_27.csv
test_28.csv
test_29.csv
test_3.csv
test_30.csv
test_31.csv
test_32.csv
test_33.csv
test_34.csv
test_35.csv
test_36.csv
test_37.csv
test_38.csv
test_39.csv
test_4.csv
test_40.csv
test_41.csv
test_42.csv
test_43.csv
test_44.csv
test_45.csv
test_46.csv
test_47.csv
test_48.csv
test_49.csv
test_5.csv
test_50.csv
test_51.csv
test_52.csv
test_53.csv
test_54.csv
test_55.csv
test_56.csv
test_6.csv
test_7.csv
test_8.csv
test_9.csv