Belajar Data_Chapter 2.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	customer_id	customer_name	gender	age	home_address	zip_code	city	state	country	orders.order_id	orders.payment	orders.order_date	orders.delivery_date
2	1	fulan 1	Female	30	8606 Victoria TerraceSuite 560	5464	Johnstonhaven	Northern Territory	Australia	455	24550	4/4/2021	4/6/2021
3	1	fulan 1	Female	30	8606 Victoria TerraceSuite 560	5464	Johnstonhaven	Northern Territory	Australia	670	10246	3/6/2021	4/1/2021
4	1	fulan 1	Female	30	8606 Victoria TerraceSuite 560	5464	Johnstonhaven	Northern Territory	Australia	729	35593	2/18/2021	3/1/2021
5	64	fulan 64	Prefer not to say	75	4927 Alice MeadowApt. 960	7787	Sanfordborough	South Australia	Australia	1	30811	8/30/2021	9/24/2021
6	473	fulan 473	Male	61	531 Schmitt BoulevardApt. 010	1744	Annaton	South Australia	Australia	2	50490	2/3/2021	2/13/2021
7	473	fulan 473	Male	61	531 Schmitt BoulevardApt. 010	1744	Annaton	South Australia	Australia	221	49366	8/3/2021	8/17/2021
8	774	fulan 774	Prefer not to say	34	2096 Wilson MewsApt. 714	8590	West Jonathanshire	Tasmania	Australia	3	46763	10/8/2021	11/3/2021
9	774	fulan 774	Prefer not to say	34	2096 Wilson MewsApt. 714	8590	West Jonathanshire	Tasmania	Australia	353	46198	3/30/2021	4/5/2021
10	774	fulan 774	Prefer not to say	34	2096 Wilson MewsApt. 714	8590	West Jonathanshire	Tasmania	Australia	944	27648	7/17/2021	8/9/2021
11	433	fulan 433	Prefer not to say	46	5777 Mayer PassApt. 881	9728	West Michaelport	Tasmania	Australia	4	39782	5/6/2021	5/19/2021
12	433	fulan 433	Prefer not to say	46	5777 Mayer PassApt. 881	9728	West Michaelport	Tasmania	Australia	251	30132	7/31/2021	8/27/2021
13	433	fulan 433	Prefer not to say	46	5777 Mayer PassApt. 881	9728	West Michaelport	Tasmania	Australia	318	39332	1/31/2021	2/17/2021
14	441	fulan 441	Prefer not to say	53	33 Richards JunctionApt. 478	7650	South Rileyview	Western Australia	Australia	5	14719	3/23/2021	3/24/2021
15	441	fulan 441	Prefer not to say	53	33 Richards JunctionApt. 478	7650	South Rileyview	Western Australia	Australia	454	40423	3/29/2021	4/12/2021
16	800	fulan 800	Prefer not to say	49	3570 Sarah AvenueApt. 092	4505	Daughertyport	Queensland	Australia	6	16197	9/9/2021	10/5/2021
17	800	fulan 800	Prefer not to say	49	3570 Sarah AvenueApt. 092	4505	Daughertyport	Queensland	Australia	680	43491	5/4/2021	5/22/2021
18	7	fulan 7	Prefer not to say	76	92 Hills Station StApt. 683	793	Masonfurt	Queensland	Australia	465	48935	5/21/2021	5/23/2021
19	626	fulan 626	Prefer not to say	64	72 Hunter Station StApt. 220	1807	Walterstad	New South Wales	Australia	7	37666	4/5/2021	4/11/2021
20	58	fulan 58	Prefer not to say	39	260 Lily PassSuite 549	2783	Amelieburgh	New South Wales	Australia	8	28484	4/12/2021	5/1/2021
21	58	fulan 58	Prefer not to say	39	260 Lily PassSuite 549	2783	Amelieburgh	New South Wales	Australia	298	55984	9/11/2021	9/20/2021
22	58	fulan 58	Prefer not to say	39	260 Lily PassSuite 549	2783	Amelieburgh	New South Wales	Australia	507	29761	6/20/2021	7/11/2021
23	852	fulan 852	Prefer not to say	67	079 Chase MallApt. 902	8460	O'connertown	Tasmania	Australia	9	12896	5/1/2021	5/11/2021
24	852	fulan 852	Prefer not to say	67	079 Chase MallApt. 902	8460	O'connertown	Tasmania	Australia	323	11437	3/23/2021	4/13/2021
25	852	fulan 852	Prefer not to say	67	079 Chase MallApt. 902	8460	O'connertown	Tasmania	Australia	727	56021	5/1/2021	5/18/2021
26	10	fulan 10	Prefer not to say	70	615 Hayley KnollSuite 454	2118	Joelburgh	Western Australia	Australia	595	45626	3/9/2021	3/29/2021
27	659	fulan 659	Prefer not to say	57	14 O'neill View RdApt. 908	9653	Sophiemouth	Tasmania	Australia	10	21922	10/15/2021	10/16/2021
28	659	fulan 659	Prefer not to say	57	14 O'neill View RdApt. 908	9653	Sophiemouth	Tasmania	Australia	277	48337	4/5/2021	4/6/2021
29	659	fulan 659	Prefer not to say	57	14 O'neill View RdApt. 908	9653	Sophiemouth	Tasmania	Australia	701	40717	8/28/2021	9/10/2021
30	11	fulan 11	Prefer not to say	39	96 Daniel PlaceSuite 898	7400	Georgeland	Northern Territory	Australia	560	41952	5/28/2021	6/5/2021
31	785	fulan 785	Prefer not to say	54	82 Beahan BoulevardSuite 281	2683	Port Adamburgh	Northern Territory	Australia	11	36624	6/15/2021	6/30/2021
32	12	fulan 12	Prefer not to say	78	66 Kayla MewsSuite 951	6334	Taylorburgh	South Australia	Australia	134	39451	6/19/2021	7/1/2021
33	120	fulan 120	Prefer not to say	60	13 Ivy BoulevardSuite 234	3554	Carterbury	Queensland	Australia	12	55507	6/30/2021	7/11/2021
34	13	fulan 13	Male	42	16 Kuhn LoopSuite 442	6170	Maddisonmouth	Queensland	Australia	398	31626	9/28/2021	10/13/2021
35	204	fulan 204	Female	60	889 Hermann Station StApt. 026	5120	East Jakeberg	New South Wales	Australia	13	57810	10/15/2021	10/31/2021
36	957	fulan 957	Male	75	5215 Mitchell TrackSuite 778	4220	Samanthaberg	South Australia	Australia	14	21270	3/29/2021	4/12/2021
37	15	fulan 15	Prefer not to say	34	254 Ali RidgeApt. 350	491	Kiehnburgh	Western Australia	Australia	200	50335	8/24/2021	9/7/2021
38	15	fulan 15	Prefer not to say	34	254 Ali RidgeApt. 350	491	Kiehnburgh	Western Australia	Australia	995	43588	4/14/2021	4/28/2021
39	468	fulan 468	Prefer not to say	67	06 Ebert CrestSuite 385	5607	West Isla	Tasmania	Australia	15	15488	9/22/2021	10/8/2021
40	16	fulan 16	Male	75	424 Mason PlaceApt. 181	6438	New Kai	Victoria	Australia	885	27561	10/18/2021	11/13/2021
41	564	fulan 564	Prefer not to say	34	65 Schroeder WayApt. 552	4054	North Marcusland	Northern Territory	Australia	16	36479	7/7/2021	7/8/2021
42	614	fulan 614	Prefer not to say	45	627 Weber PassApt. 498	7529	Samuelside	New South Wales	Australia	17	51822	2/9/2021	2/11/2021
43	614	fulan 614	Prefer not to say	45	627 Weber PassApt. 498	7529	Samuelside	New South Wales	Australia	566	21778	7/24/2021	8/10/2021
44	614	fulan 614	Prefer not to say	45	627 Weber PassApt. 498	7529	Samuelside	New South Wales	Australia	620	41599	7/19/2021	8/1/2021
45	18	fulan 18	Male	79	13 Bailey ManorApt. 848	7171	Walterland	New South Wales	Australia	191	31002	1/22/2021	2/15/2021
46	18	fulan 18	Male	79	13 Bailey ManorApt. 848	7171	Walterland	New South Wales	Australia	354	33908	2/26/2021	3/8/2021
47	299	fulan 299	Prefer not to say	32	810 Jasper CircleSuite 777	89	Lake Amelia	Victoria	Australia	18	22902	1/1/2021	1/3/2021
48	299	fulan 299	Prefer not to say	32	810 Jasper CircleSuite 777	89	Lake Amelia	Victoria	Australia	747	22099	5/11/2021	5/28/2021
49	19	fulan 19	Prefer not to say	41	002 Beau PlazaApt. 308	7053	West Bailey	Victoria	Australia	274	50173	4/13/2021	4/27/2021
50	513	fulan 513	Prefer not to say	39	051 White WayApt. 392	2358	Port Ali	Tasmania	Australia	19	56754	8/30/2021	9/10/2021
51	20	fulan 20	Prefer not to say	55	2069 Phoebe MallApt. 543	6318	East Audrey	South Australia	Australia	432	37821	10/20/2021	11/3/2021
52	20	fulan 20	Prefer not to say	55	2069 Phoebe MallApt. 543	6318	East Audrey	South Australia	Australia	641	54363	3/10/2021	3/22/2021
53	789	fulan 789	Prefer not to say	36	638 Thomas ManorApt. 038	1438	Aliceland	Western Australia	Australia	20	45129	1/13/2021	1/20/2021
54	789	fulan 789	Prefer not to say	36	638 Thomas ManorApt. 038	1438	Aliceland	Western Australia	Australia	903	21721	1/5/2021	1/21/2021
55	21	fulan 21	Prefer not to say	31	93 Doherty MewsSuite 649	1133	South Callum	Tasmania	Australia	377	24815	5/19/2021	5/28/2021
56	21	fulan 21	Prefer not to say	31	93 Doherty MewsSuite 649	1133	South Callum	Tasmania	Australia	616	28727	5/13/2021	5/14/2021
57	21	fulan 21	Prefer not to say	31	93 Doherty MewsSuite 649	1133	South Callum	Tasmania	Australia	664	11960	1/7/2021	1/20/2021
58	124	fulan 124	Prefer not to say	54	65 Eli AvenueApt. 473	4983	Donnellyfort	New South Wales	Australia	21	11261	4/4/2021	4/17/2021
59	22	fulan 22	Prefer not to say	20	292 Casper IslandSuite 778	6624	Maxberg	Victoria	Australia	668	40483	3/15/2021	3/30/2021
60	180	fulan 180	Prefer not to say	21	58 Jett RoadApt. 448	932	Chasemouth	Western Australia	Australia	22	36088	5/28/2021	6/9/2021
61	180	fulan 180	Prefer not to say	21	58 Jett RoadApt. 448	932	Chasemouth	Western Australia	Australia	68	20552	2/12/2021	2/18/2021
62	180	fulan 180	Prefer not to say	21	58 Jett RoadApt. 448	932	Chasemouth	Western Australia	Australia	480	38248	7/15/2021	8/5/2021
63	23	fulan 23	Female	32	682 Rose CircleApt. 514	1832	North Mia	Tasmania	Australia	515	20627	5/23/2021	6/13/2021
64	652	fulan 652	Male	63	59 Abbott CircuitApt. 084	9830	North Isabelleside	South Australia	Australia	23	45711	5/17/2021	5/22/2021
65	469	fulan 469	Female	78	783 Olivia CrescentSuite 877	5011	Andrewborough	New South Wales	Australia	24	14566	9/4/2021	9/20/2021
66	469	fulan 469	Female	78	783 Olivia CrescentSuite 877	5011	Andrewborough	New South Wales	Australia	180	14617	5/29/2021	6/22/2021
67	469	fulan 469	Female	78	783 Olivia CrescentSuite 877	5011	Andrewborough	New South Wales	Australia	271	39282	6/7/2021	6/9/2021
68	469	fulan 469	Female	78	783 Olivia CrescentSuite 877	5011	Andrewborough	New South Wales	Australia	383	36564	9/8/2021	9/14/2021
69	25	fulan 25	Prefer not to say	75	02 Gabriella PlazaApt. 474	9311	Olivershire	Victoria	Australia	609	21514	4/22/2021	5/8/2021
70	562	fulan 562	Prefer not to say	58	04 Spencer MallApt. 910	8257	West Rubyland	Queensland	Australia	25	47075	7/4/2021	7/8/2021
71	562	fulan 562	Prefer not to say	58	04 Spencer MallApt. 910	8257	West Rubyland	Queensland	Australia	132	10396	4/17/2021	5/1/2021
72	26	fulan 26	Prefer not to say	50	499 Darcy CrestApt. 192	8816	New Oliverside	New South Wales	Australia	550	52719	8/4/2021	8/9/2021
73	732	fulan 732	Prefer not to say	80	905 Stephanie BoulevardApt. 217	8114	Port Aaronton	Queensland	Australia	26	15964	4/25/2021	5/4/2021
74	732	fulan 732	Prefer not to say	80	905 Stephanie BoulevardApt. 217	8114	Port Aaronton	Queensland	Australia	122	29226	4/13/2021	5/4/2021
75	732	fulan 732	Prefer not to say	80	905 Stephanie BoulevardApt. 217	8114	Port Aaronton	Queensland	Australia	348	42741	10/7/2021	10/28/2021
76	732	fulan 732	Prefer not to say	80	905 Stephanie BoulevardApt. 217	8114	Port Aaronton	Queensland	Australia	614	35663	4/18/2021	5/3/2021
77	27	fulan 27	Prefer not to say	55	6578 Kayla AvenueSuite 812	3462	Lake Alanafort	Western Australia	Australia	748	49811	5/16/2021	6/6/2021
78	443	fulan 443	Prefer not to say	49	033 Mitchell IslandApt. 732	9651	Crooksshire	Victoria	Australia	27	35513	5/16/2021	5/28/2021
79	443	fulan 443	Prefer not to say	49	033 Mitchell IslandApt. 732	9651	Crooksshire	Victoria	Australia	171	19467	9/14/2021	9/16/2021
80	28	fulan 28	Prefer not to say	79	360 Heller DriveApt. 052	5820	West Noah	Queensland	Australia	208	39533	10/10/2021	10/15/2021
81	28	fulan 28	Prefer not to say	79	360 Heller DriveApt. 052	5820	West Noah	Queensland	Australia	226	44799	7/9/2021	7/23/2021
82	206	fulan 206	Prefer not to say	66	09 Kiehn View RdApt. 209	2155	South Clairetown	Queensland	Australia	28	29968	8/19/2021	9/4/2021
83	206	fulan 206	Prefer not to say	66	09 Kiehn View RdApt. 209	2155	South Clairetown	Queensland	Australia	199	58054	5/17/2021	5/18/2021
84	206	fulan 206	Prefer not to say	66	09 Kiehn View RdApt. 209	2155	South Clairetown	Queensland	Australia	390	57651	1/20/2021	1/24/2021
85	206	fulan 206	Prefer not to say	66	09 Kiehn View RdApt. 209	2155	South Clairetown	Queensland	Australia	409	15453	5/3/2021	5/11/2021
86	993	fulan 993	Prefer not to say	24	327 Abby CircleApt. 055	536	Michaelberg	Victoria	Australia	29	57645	3/22/2021	3/28/2021
87	260	fulan 260	Female	27	01 D'amore ManorSuite 692	3012	Trompview	Tasmania	Australia	30	59350	7/7/2021	7/26/2021
88	260	fulan 260	Female	27	01 D'amore ManorSuite 692	3012	Trompview	Tasmania	Australia	704	45954	7/21/2021	7/27/2021
89	727	fulan 727	Female	26	2752 Lily RoadApt. 721	3249	Jacobport	New South Wales	Australia	31	15722	3/11/2021	4/5/2021
90	727	fulan 727	Female	26	2752 Lily RoadApt. 721	3249	Jacobport	New South Wales	Australia	153	49677	10/21/2021	11/17/2021
91	727	fulan 727	Female	26	2752 Lily RoadApt. 721	3249	Jacobport	New South Wales	Australia	156	37878	7/10/2021	7/29/2021
92	727	fulan 727	Female	26	2752 Lily RoadApt. 721	3249	Jacobport	New South Wales	Australia	371	28931	8/29/2021	9/15/2021
93	627	fulan 627	Prefer not to say	51	66 Isla CrescentApt. 573	7404	Port Christopher	South Australia	Australia	32	24976	6/17/2021	7/14/2021
94	627	fulan 627	Prefer not to say	51	66 Isla CrescentApt. 573	7404	Port Christopher	South Australia	Australia	832	52583	9/6/2021	9/27/2021
95	588	fulan 588	Prefer not to say	48	550 Alexis BoulevardSuite 124	9614	West Danieltown	Victoria	Australia	33	52945	7/1/2021	7/7/2021
96	588	fulan 588	Prefer not to say	48	550 Alexis BoulevardSuite 124	9614	West Danieltown	Victoria	Australia	591	39095	6/18/2021	7/6/2021
97	34	fulan 34	Prefer not to say	55	09 Robinson SquareApt. 647	5387	Sauerfort	Western Australia	Australia	267	44791	9/11/2021	9/12/2021
98	412	fulan 412	Prefer not to say	21	7048 Barrows CrescentSuite 562	238	Hackettchester	South Australia	Australia	34	36244	5/23/2021	5/30/2021
99	412	fulan 412	Prefer not to say	21	7048 Barrows CrescentSuite 562	238	Hackettchester	South Australia	Australia	164	26249	5/21/2021	6/3/2021
100	412	fulan 412	Prefer not to say	21	7048 Barrows CrescentSuite 562	238	Hackettchester	South Australia	Australia	295	55019	3/5/2021	3/19/2021