In [94]:
import pandas as pd
import numpy as np
import random
In [78]:
names = pd.read_csv('transaction.csv')['name']
names = pd.DataFrame(list(set(names)), columns=['name'])
transaction = pd.read_csv('transaction.csv')
In [101]:
salaryList= []
for i in range(names.shape[0]):
if i %1000 == 0: print(i)
name = names.iloc[i]['name']
total = sum(transaction.loc[transaction['name'] == name, 'amount'])
percentage = random.randrange(-10,10000)
total += total * (percentage/100.0)
# print(total, percentage)
salaryList.append(int(total))
names['salary'] = salaryList
names
0
1000
2000
3000
4000
5000
6000
7000
8000
9000
Out[101]:
name
salary
0
Tracy Galvan
123378
1
Melinda Brown
585481
2
Mary Schneider
39351
3
Amy Norman
315047
4
Rebecca Suarez
686830
5
Robert Edwards
559446
6
Billy Wagner
55990
7
Erika Thomas
64886
8
Dustin Wiggins
370653
9
Tina Saunders
427168
10
Sarah Barnes
402484
11
Kevin Sullivan
38082
12
Brenda Williams
353457
13
Michael Mcmillan
501968
14
Paul Fowler
15887
15
Sabrina Smith
472095
16
Tommy Roberts
431883
17
James Anderson
22249
18
Samuel Norton
222369
19
Ana Bruce MD
115619
20
Sharon Wright
215743
21
Jacob Baker
83788
22
Sara Austin
226901
23
Cameron Steele
26630
24
Kelly Barber
387674
25
Daniel Lane
664577
26
Linda Johnson
189243
27
Mary Morris
82227
28
Angela Peterson
279858
29
Chris Aguilar
321344
...
...
...
9970
Linda Washington
173528
9971
Brian Mendoza
420138
9972
Alejandro Andrade
224849
9973
Tim Sanford
547676
9974
Katelyn Reyes
264505
9975
Erin Howard
167589
9976
Mark Jones
8659
9977
Sandra Smith
281178
9978
Summer Roman
31661
9979
Glenda Ramirez
598587
9980
Michael Wagner
509436
9981
Daniel Soto
270190
9982
Charles Carter
429463
9983
Amanda Stanley
611657
9984
Allen Weaver
342845
9985
Ashley Salazar
207962
9986
Jordan Washington
26094
9987
Julie Vasquez
488450
9988
Nicole Wiley
356930
9989
Mark Cervantes
559732
9990
Michael Bryant
147031
9991
Martha Sherman
452172
9992
John Marshall
352828
9993
Selena Anderson
432681
9994
Glen Stone
240626
9995
Dean Robbins
540593
9996
David Rodriguez
31176
9997
Sara Barajas
506388
9998
Donna Knox
67329
9999
Keith Barnes
106001
10000 rows × 2 columns
In [89]:
---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
<ipython-input-89-579a01eff03e> in <module>()
----> 1 names['salary'] = names['salary'][0]
/usr/local/lib/python3.6/site-packages/pandas/core/frame.py in __setitem__(self, key, value)
2329 else:
2330 # set column
-> 2331 self._set_item(key, value)
2332
2333 def _setitem_slice(self, key, value):
/usr/local/lib/python3.6/site-packages/pandas/core/frame.py in _set_item(self, key, value)
2395
2396 self._ensure_valid_index(value)
-> 2397 value = self._sanitize_column(key, value)
2398 NDFrame._set_item(self, key, value)
2399
/usr/local/lib/python3.6/site-packages/pandas/core/frame.py in _sanitize_column(self, key, value, broadcast)
2566
2567 # turn me into an ndarray
-> 2568 value = _sanitize_index(value, self.index, copy=False)
2569 if not isinstance(value, (np.ndarray, Index)):
2570 if isinstance(value, list) and len(value) > 0:
/usr/local/lib/python3.6/site-packages/pandas/core/series.py in _sanitize_index(data, index, copy)
2877
2878 if len(data) != len(index):
-> 2879 raise ValueError('Length of values does not match length of ' 'index')
2880
2881 if isinstance(data, PeriodIndex):
ValueError: Length of values does not match length of index
In [102]:
transaction = pd.read_csv('transaction.csv')
transaction
Out[102]:
time
name
gender
age
company name
company label
amount
salary
0
2017-07-02 22:27:48
Rachel Trujillo
male
36
Coursera Inc.
Education
111.22
347740
1
2017-06-10 12:37:05
Rachel Trujillo
male
36
Laura Mercier Cosmetics.
Beauty
108.46
347740
2
2017-06-07 14:24:02
Rachel Trujillo
male
36
Synovus Financial Corp.
Investment
208.21
347740
3
2017-06-25 15:36:22
Rachel Trujillo
male
36
Peak Tramways Company Limited
Transport
222.79
347740
4
2017-06-30 03:34:48
Rachel Trujillo
male
36
McDonald' s
Dining
86.28
347740
5
2017-06-29 18:00:00
Rachel Trujillo
male
36
Pearson plc
Education
47.68
347740
6
2017-06-30 21:34:26
Rachel Trujillo
male
36
Wal-Mart Stores Inc
Grocery
93.69
347740
7
2017-07-04 11:57:56
Rachel Trujillo
male
36
Principal Financial Group Inc
Investment
115.46
347740
8
2017-06-13 06:54:58
Rachel Trujillo
male
36
Voya Financial, Inc.
Investment
142.11
347740
9
2017-07-02 18:23:56
Rachel Trujillo
male
36
The Dairy Farm Company, Limited
Grocery
61.87
347740
10
2017-06-17 03:32:26
Rachel Trujillo
male
36
2U, Inc.
Education
280.35
347740
11
2017-07-03 13:44:19
Rachel Trujillo
male
36
City Super Limited
Grocery
281.82
347740
12
2017-06-16 16:16:17
Rachel Trujillo
male
36
GAP
Clothing
9.13
347740
13
2017-06-17 01:17:02
Rachel Trujillo
male
36
Subway
Dining
104.77
347740
14
2017-06-21 11:14:37
Rachel Trujillo
male
36
KOKUYO Co.,Ltd.
Stationery
300.88
347740
15
2017-06-11 21:15:08
Rachel Trujillo
male
36
Raymond James Financial, Inc.
Investment
33.22
347740
16
2017-06-14 11:45:03
Rachel Trujillo
male
36
KOKUYO Co.,Ltd.
Stationery
297.04
347740
17
2017-07-03 21:29:17
Rachel Trujillo
male
36
Liberty Stationery Corp.
Stationery
133.08
347740
18
2017-06-20 09:04:47
Rachel Trujillo
male
36
Ikari Area
Entertainment
9.43
347740
19
2017-06-10 18:31:22
Rachel Trujillo
male
36
The 'Star' Ferry Company, Limited
Transport
201.96
347740
20
2017-07-05 20:58:23
Rachel Trujillo
male
36
Tim Ho Wan
Dining
292.67
347740
21
2017-06-23 20:15:43
Rachel Trujillo
male
36
BB Liquidating Inc
Media
163.39
347740
22
2017-06-24 15:32:14
Rachel Trujillo
male
36
Parker Pen Company
Stationery
260.15
347740
23
2017-06-24 04:00:43
Rachel Trujillo
male
36
Le.com
Media
149.06
347740
24
2017-07-04 03:13:19
Rachel Trujillo
male
36
J. Crew
Clothing
273.85
347740
25
2017-06-12 00:30:44
Rachel Trujillo
male
36
Voya Financial, Inc.
Investment
93.04
347740
26
2017-06-20 09:50:33
Rachel Trujillo
male
36
Neway Karaoke Box Limited
Entertainment
239.05
347740
27
2017-06-22 22:08:41
Rachel Trujillo
male
36
TCF Financial Corporation
Investment
244.24
347740
28
2017-06-11 13:26:35
Rachel Trujillo
male
36
Principal Financial Group Inc
Investment
117.48
347740
29
2017-07-04 09:40:59
Rachel Trujillo
male
36
Laura Mercier Cosmetics.
Beauty
134.45
347740
...
...
...
...
...
...
...
...
...
399970
2017-06-12 23:41:20
Kelsey Jones
male
50
Sumitomo Mitsui Financial Group Inc
Investment
16.89
570823
399971
2017-06-29 22:55:52
Kelsey Jones
male
50
Udacity, Inc.
Education
197.18
570823
399972
2017-06-08 21:36:12
Kelsey Jones
male
50
Staedtler Mars GmbH & Co. KG
Stationery
81.63
570823
399973
2017-06-07 07:32:09
Kelsey Jones
male
50
Waddell & Reed Financial, Inc.
Investment
258.03
570823
399974
2017-06-30 10:49:34
Kelsey Jones
male
50
Shenzhen Comix Stationery Co., Ltd.
Stationery
200.22
570823
399975
2017-06-29 10:25:22
Kelsey Jones
male
50
Hong Kong Dragon Airlines Ltd
Transport
16.32
570823
399976
2017-07-02 23:05:33
Kelsey Jones
male
50
Maxim' s Catering
Dining
265.12
570823
399977
2017-06-14 09:14:25
Kelsey Jones
male
50
Shinhan Financial Group Co Ltd
Investment
113.96
570823
399978
2017-06-16 23:01:34
Kelsey Jones
male
50
The Kowloon Motor Bus Company Limited
Transport
51.15
570823
399979
2017-06-30 20:05:53
Kelsey Jones
male
50
Xbox
Entertainment
233.69
570823
399980
2017-06-14 11:43:47
Kelsey Jones
male
50
J. Crew
Clothing
141.99
570823
399981
2017-06-07 09:19:46
Kelsey Jones
male
50
New World First Bus Services Limited
Transport
197.35
570823
399982
2017-06-28 11:42:38
Kelsey Jones
male
50
edX Inc.
Education
294.94
570823
399983
2017-06-13 14:28:37
Kelsey Jones
male
50
Yadkin Financial Corporation
Investment
52.28
570823
399984
2017-06-17 13:29:12
Kelsey Jones
male
50
Netflix, Inc.
Media
31.73
570823
399985
2017-06-15 06:16:08
Kelsey Jones
male
50
Ikari Area
Entertainment
201.77
570823
399986
2017-06-23 18:05:50
Kelsey Jones
male
50
Levi Strauss & Co.
Clothing
272.93
570823
399987
2017-06-16 12:47:34
Kelsey Jones
male
50
Spotify AB
Media
114.97
570823
399988
2017-06-22 20:57:56
Kelsey Jones
male
50
Cathay Pacific Airways
Transport
71.12
570823
399989
2017-06-26 04:56:07
Kelsey Jones
male
50
Coursera Inc.
Education
275.30
570823
399990
2017-07-02 17:11:21
Kelsey Jones
male
50
Code School LLC.
Education
92.36
570823
399991
2017-06-16 02:28:35
Kelsey Jones
male
50
Ryze Ultimate Trampoline Park Hong Kong
Entertainment
283.62
570823
399992
2017-07-04 20:10:37
Kelsey Jones
male
50
Redbox Automated Retail, LLC.
Media
169.40
570823
399993
2017-06-17 02:49:32
Kelsey Jones
male
50
McDonald' s
Dining
55.72
570823
399994
2017-06-28 08:49:46
Kelsey Jones
male
50
Long Win Bus Company Limited
Transport
156.04
570823
399995
2017-07-02 21:33:10
Kelsey Jones
male
50
New Oriental Education & Tech Grp
Education
39.57
570823
399996
2017-06-26 10:09:42
Kelsey Jones
male
50
Xbox
Entertainment
222.35
570823
399997
2017-06-13 04:40:07
Kelsey Jones
male
50
Tim Ho Wan
Dining
163.53
570823
399998
2017-06-13 16:58:51
Kelsey Jones
male
50
G2000
Clothing
16.58
570823
399999
2017-07-05 07:28:44
Kelsey Jones
male
50
FANCL International, Inc.
Beauty
211.63
570823
400000 rows × 8 columns
In [113]:
names = names[['name', 'salary']]
np.mean(names.salary)
Out[113]:
313423.64640000003
In [112]:
transaction = transaction.join(names.set_index('name'), on=['name'])
Out[112]:
time
name
gender
age
company name
company label
amount
salary
0
2017-07-02 22:27:48
Rachel Trujillo
male
36
Coursera Inc.
Education
111.22
347740
1
2017-06-10 12:37:05
Rachel Trujillo
male
36
Laura Mercier Cosmetics.
Beauty
108.46
347740
2
2017-06-07 14:24:02
Rachel Trujillo
male
36
Synovus Financial Corp.
Investment
208.21
347740
3
2017-06-25 15:36:22
Rachel Trujillo
male
36
Peak Tramways Company Limited
Transport
222.79
347740
4
2017-06-30 03:34:48
Rachel Trujillo
male
36
McDonald' s
Dining
86.28
347740
5
2017-06-29 18:00:00
Rachel Trujillo
male
36
Pearson plc
Education
47.68
347740
6
2017-06-30 21:34:26
Rachel Trujillo
male
36
Wal-Mart Stores Inc
Grocery
93.69
347740
7
2017-07-04 11:57:56
Rachel Trujillo
male
36
Principal Financial Group Inc
Investment
115.46
347740
8
2017-06-13 06:54:58
Rachel Trujillo
male
36
Voya Financial, Inc.
Investment
142.11
347740
9
2017-07-02 18:23:56
Rachel Trujillo
male
36
The Dairy Farm Company, Limited
Grocery
61.87
347740
10
2017-06-17 03:32:26
Rachel Trujillo
male
36
2U, Inc.
Education
280.35
347740
11
2017-07-03 13:44:19
Rachel Trujillo
male
36
City Super Limited
Grocery
281.82
347740
12
2017-06-16 16:16:17
Rachel Trujillo
male
36
GAP
Clothing
9.13
347740
13
2017-06-17 01:17:02
Rachel Trujillo
male
36
Subway
Dining
104.77
347740
14
2017-06-21 11:14:37
Rachel Trujillo
male
36
KOKUYO Co.,Ltd.
Stationery
300.88
347740
15
2017-06-11 21:15:08
Rachel Trujillo
male
36
Raymond James Financial, Inc.
Investment
33.22
347740
16
2017-06-14 11:45:03
Rachel Trujillo
male
36
KOKUYO Co.,Ltd.
Stationery
297.04
347740
17
2017-07-03 21:29:17
Rachel Trujillo
male
36
Liberty Stationery Corp.
Stationery
133.08
347740
18
2017-06-20 09:04:47
Rachel Trujillo
male
36
Ikari Area
Entertainment
9.43
347740
19
2017-06-10 18:31:22
Rachel Trujillo
male
36
The 'Star' Ferry Company, Limited
Transport
201.96
347740
20
2017-07-05 20:58:23
Rachel Trujillo
male
36
Tim Ho Wan
Dining
292.67
347740
21
2017-06-23 20:15:43
Rachel Trujillo
male
36
BB Liquidating Inc
Media
163.39
347740
22
2017-06-24 15:32:14
Rachel Trujillo
male
36
Parker Pen Company
Stationery
260.15
347740
23
2017-06-24 04:00:43
Rachel Trujillo
male
36
Le.com
Media
149.06
347740
24
2017-07-04 03:13:19
Rachel Trujillo
male
36
J. Crew
Clothing
273.85
347740
25
2017-06-12 00:30:44
Rachel Trujillo
male
36
Voya Financial, Inc.
Investment
93.04
347740
26
2017-06-20 09:50:33
Rachel Trujillo
male
36
Neway Karaoke Box Limited
Entertainment
239.05
347740
27
2017-06-22 22:08:41
Rachel Trujillo
male
36
TCF Financial Corporation
Investment
244.24
347740
28
2017-06-11 13:26:35
Rachel Trujillo
male
36
Principal Financial Group Inc
Investment
117.48
347740
29
2017-07-04 09:40:59
Rachel Trujillo
male
36
Laura Mercier Cosmetics.
Beauty
134.45
347740
...
...
...
...
...
...
...
...
...
399970
2017-06-12 23:41:20
Kelsey Jones
male
50
Sumitomo Mitsui Financial Group Inc
Investment
16.89
570823
399971
2017-06-29 22:55:52
Kelsey Jones
male
50
Udacity, Inc.
Education
197.18
570823
399972
2017-06-08 21:36:12
Kelsey Jones
male
50
Staedtler Mars GmbH & Co. KG
Stationery
81.63
570823
399973
2017-06-07 07:32:09
Kelsey Jones
male
50
Waddell & Reed Financial, Inc.
Investment
258.03
570823
399974
2017-06-30 10:49:34
Kelsey Jones
male
50
Shenzhen Comix Stationery Co., Ltd.
Stationery
200.22
570823
399975
2017-06-29 10:25:22
Kelsey Jones
male
50
Hong Kong Dragon Airlines Ltd
Transport
16.32
570823
399976
2017-07-02 23:05:33
Kelsey Jones
male
50
Maxim' s Catering
Dining
265.12
570823
399977
2017-06-14 09:14:25
Kelsey Jones
male
50
Shinhan Financial Group Co Ltd
Investment
113.96
570823
399978
2017-06-16 23:01:34
Kelsey Jones
male
50
The Kowloon Motor Bus Company Limited
Transport
51.15
570823
399979
2017-06-30 20:05:53
Kelsey Jones
male
50
Xbox
Entertainment
233.69
570823
399980
2017-06-14 11:43:47
Kelsey Jones
male
50
J. Crew
Clothing
141.99
570823
399981
2017-06-07 09:19:46
Kelsey Jones
male
50
New World First Bus Services Limited
Transport
197.35
570823
399982
2017-06-28 11:42:38
Kelsey Jones
male
50
edX Inc.
Education
294.94
570823
399983
2017-06-13 14:28:37
Kelsey Jones
male
50
Yadkin Financial Corporation
Investment
52.28
570823
399984
2017-06-17 13:29:12
Kelsey Jones
male
50
Netflix, Inc.
Media
31.73
570823
399985
2017-06-15 06:16:08
Kelsey Jones
male
50
Ikari Area
Entertainment
201.77
570823
399986
2017-06-23 18:05:50
Kelsey Jones
male
50
Levi Strauss & Co.
Clothing
272.93
570823
399987
2017-06-16 12:47:34
Kelsey Jones
male
50
Spotify AB
Media
114.97
570823
399988
2017-06-22 20:57:56
Kelsey Jones
male
50
Cathay Pacific Airways
Transport
71.12
570823
399989
2017-06-26 04:56:07
Kelsey Jones
male
50
Coursera Inc.
Education
275.30
570823
399990
2017-07-02 17:11:21
Kelsey Jones
male
50
Code School LLC.
Education
92.36
570823
399991
2017-06-16 02:28:35
Kelsey Jones
male
50
Ryze Ultimate Trampoline Park Hong Kong
Entertainment
283.62
570823
399992
2017-07-04 20:10:37
Kelsey Jones
male
50
Redbox Automated Retail, LLC.
Media
169.40
570823
399993
2017-06-17 02:49:32
Kelsey Jones
male
50
McDonald' s
Dining
55.72
570823
399994
2017-06-28 08:49:46
Kelsey Jones
male
50
Long Win Bus Company Limited
Transport
156.04
570823
399995
2017-07-02 21:33:10
Kelsey Jones
male
50
New Oriental Education & Tech Grp
Education
39.57
570823
399996
2017-06-26 10:09:42
Kelsey Jones
male
50
Xbox
Entertainment
222.35
570823
399997
2017-06-13 04:40:07
Kelsey Jones
male
50
Tim Ho Wan
Dining
163.53
570823
399998
2017-06-13 16:58:51
Kelsey Jones
male
50
G2000
Clothing
16.58
570823
399999
2017-07-05 07:28:44
Kelsey Jones
male
50
FANCL International, Inc.
Beauty
211.63
570823
400000 rows × 8 columns
In [75]:
transaction.to_csv('transaction.csv', index = False)
In [77]:
df = pd.read_csv('transaction.csv')
df
Out[77]:
time
name
gender
age
company name
company label
amount
salary
0
2017-07-02 22:27:48
Rachel Trujillo
male
36
Coursera Inc.
Education
111.22
347740
1
2017-06-10 12:37:05
Rachel Trujillo
male
36
Laura Mercier Cosmetics.
Beauty
108.46
347740
2
2017-06-07 14:24:02
Rachel Trujillo
male
36
Synovus Financial Corp.
Investment
208.21
347740
3
2017-06-25 15:36:22
Rachel Trujillo
male
36
Peak Tramways Company Limited
Transport
222.79
347740
4
2017-06-30 03:34:48
Rachel Trujillo
male
36
McDonald' s
Dining
86.28
347740
5
2017-06-29 18:00:00
Rachel Trujillo
male
36
Pearson plc
Education
47.68
347740
6
2017-06-30 21:34:26
Rachel Trujillo
male
36
Wal-Mart Stores Inc
Grocery
93.69
347740
7
2017-07-04 11:57:56
Rachel Trujillo
male
36
Principal Financial Group Inc
Investment
115.46
347740
8
2017-06-13 06:54:58
Rachel Trujillo
male
36
Voya Financial, Inc.
Investment
142.11
347740
9
2017-07-02 18:23:56
Rachel Trujillo
male
36
The Dairy Farm Company, Limited
Grocery
61.87
347740
10
2017-06-17 03:32:26
Rachel Trujillo
male
36
2U, Inc.
Education
280.35
347740
11
2017-07-03 13:44:19
Rachel Trujillo
male
36
City Super Limited
Grocery
281.82
347740
12
2017-06-16 16:16:17
Rachel Trujillo
male
36
GAP
Clothing
9.13
347740
13
2017-06-17 01:17:02
Rachel Trujillo
male
36
Subway
Dining
104.77
347740
14
2017-06-21 11:14:37
Rachel Trujillo
male
36
KOKUYO Co.,Ltd.
Stationery
300.88
347740
15
2017-06-11 21:15:08
Rachel Trujillo
male
36
Raymond James Financial, Inc.
Investment
33.22
347740
16
2017-06-14 11:45:03
Rachel Trujillo
male
36
KOKUYO Co.,Ltd.
Stationery
297.04
347740
17
2017-07-03 21:29:17
Rachel Trujillo
male
36
Liberty Stationery Corp.
Stationery
133.08
347740
18
2017-06-20 09:04:47
Rachel Trujillo
male
36
Ikari Area
Entertainment
9.43
347740
19
2017-06-10 18:31:22
Rachel Trujillo
male
36
The 'Star' Ferry Company, Limited
Transport
201.96
347740
20
2017-07-05 20:58:23
Rachel Trujillo
male
36
Tim Ho Wan
Dining
292.67
347740
21
2017-06-23 20:15:43
Rachel Trujillo
male
36
BB Liquidating Inc
Media
163.39
347740
22
2017-06-24 15:32:14
Rachel Trujillo
male
36
Parker Pen Company
Stationery
260.15
347740
23
2017-06-24 04:00:43
Rachel Trujillo
male
36
Le.com
Media
149.06
347740
24
2017-07-04 03:13:19
Rachel Trujillo
male
36
J. Crew
Clothing
273.85
347740
25
2017-06-12 00:30:44
Rachel Trujillo
male
36
Voya Financial, Inc.
Investment
93.04
347740
26
2017-06-20 09:50:33
Rachel Trujillo
male
36
Neway Karaoke Box Limited
Entertainment
239.05
347740
27
2017-06-22 22:08:41
Rachel Trujillo
male
36
TCF Financial Corporation
Investment
244.24
347740
28
2017-06-11 13:26:35
Rachel Trujillo
male
36
Principal Financial Group Inc
Investment
117.48
347740
29
2017-07-04 09:40:59
Rachel Trujillo
male
36
Laura Mercier Cosmetics.
Beauty
134.45
347740
...
...
...
...
...
...
...
...
...
399970
2017-06-12 23:41:20
Kelsey Jones
male
50
Sumitomo Mitsui Financial Group Inc
Investment
16.89
570823
399971
2017-06-29 22:55:52
Kelsey Jones
male
50
Udacity, Inc.
Education
197.18
570823
399972
2017-06-08 21:36:12
Kelsey Jones
male
50
Staedtler Mars GmbH & Co. KG
Stationery
81.63
570823
399973
2017-06-07 07:32:09
Kelsey Jones
male
50
Waddell & Reed Financial, Inc.
Investment
258.03
570823
399974
2017-06-30 10:49:34
Kelsey Jones
male
50
Shenzhen Comix Stationery Co., Ltd.
Stationery
200.22
570823
399975
2017-06-29 10:25:22
Kelsey Jones
male
50
Hong Kong Dragon Airlines Ltd
Transport
16.32
570823
399976
2017-07-02 23:05:33
Kelsey Jones
male
50
Maxim' s Catering
Dining
265.12
570823
399977
2017-06-14 09:14:25
Kelsey Jones
male
50
Shinhan Financial Group Co Ltd
Investment
113.96
570823
399978
2017-06-16 23:01:34
Kelsey Jones
male
50
The Kowloon Motor Bus Company Limited
Transport
51.15
570823
399979
2017-06-30 20:05:53
Kelsey Jones
male
50
Xbox
Entertainment
233.69
570823
399980
2017-06-14 11:43:47
Kelsey Jones
male
50
J. Crew
Clothing
141.99
570823
399981
2017-06-07 09:19:46
Kelsey Jones
male
50
New World First Bus Services Limited
Transport
197.35
570823
399982
2017-06-28 11:42:38
Kelsey Jones
male
50
edX Inc.
Education
294.94
570823
399983
2017-06-13 14:28:37
Kelsey Jones
male
50
Yadkin Financial Corporation
Investment
52.28
570823
399984
2017-06-17 13:29:12
Kelsey Jones
male
50
Netflix, Inc.
Media
31.73
570823
399985
2017-06-15 06:16:08
Kelsey Jones
male
50
Ikari Area
Entertainment
201.77
570823
399986
2017-06-23 18:05:50
Kelsey Jones
male
50
Levi Strauss & Co.
Clothing
272.93
570823
399987
2017-06-16 12:47:34
Kelsey Jones
male
50
Spotify AB
Media
114.97
570823
399988
2017-06-22 20:57:56
Kelsey Jones
male
50
Cathay Pacific Airways
Transport
71.12
570823
399989
2017-06-26 04:56:07
Kelsey Jones
male
50
Coursera Inc.
Education
275.30
570823
399990
2017-07-02 17:11:21
Kelsey Jones
male
50
Code School LLC.
Education
92.36
570823
399991
2017-06-16 02:28:35
Kelsey Jones
male
50
Ryze Ultimate Trampoline Park Hong Kong
Entertainment
283.62
570823
399992
2017-07-04 20:10:37
Kelsey Jones
male
50
Redbox Automated Retail, LLC.
Media
169.40
570823
399993
2017-06-17 02:49:32
Kelsey Jones
male
50
McDonald' s
Dining
55.72
570823
399994
2017-06-28 08:49:46
Kelsey Jones
male
50
Long Win Bus Company Limited
Transport
156.04
570823
399995
2017-07-02 21:33:10
Kelsey Jones
male
50
New Oriental Education & Tech Grp
Education
39.57
570823
399996
2017-06-26 10:09:42
Kelsey Jones
male
50
Xbox
Entertainment
222.35
570823
399997
2017-06-13 04:40:07
Kelsey Jones
male
50
Tim Ho Wan
Dining
163.53
570823
399998
2017-06-13 16:58:51
Kelsey Jones
male
50
G2000
Clothing
16.58
570823
399999
2017-07-05 07:28:44
Kelsey Jones
male
50
FANCL International, Inc.
Beauty
211.63
570823
400000 rows × 8 columns
In [ ]:
Content source: FinHackChamp/FinHack
Similar notebooks: