Here is some text
In [42]:
import os
import pandas as pd
import numpy as np
%matplotlib inline
Load the data
In [43]:
X = pd.DataFrame(pd.read_csv(os.getcwd()+'/Code/Projects/RFM/GoogleWGSN.csv'))
In [44]:
print X
fullVisitorId visitId visitstarttime Date TotalsBounces \
0 1.000000e+17 1499036357 1499036357 20170702 1
1 1.010000e+17 1498917386 1498917386 20170701 1
2 1.000000e+18 1498973872 1498973872 20170702 0
3 1.000000e+18 1498973872 1498973872 20170702 0
4 1.000000e+18 1498973872 1498973872 20170702 0
5 1.000000e+18 1498973872 1498973872 20170702 0
6 1.000000e+18 1498973872 1498973872 20170702 0
7 1.000000e+18 1498973872 1498973872 20170702 0
8 1.000000e+18 1498973872 1498973872 20170702 0
9 1.000000e+18 1498973872 1498973872 20170702 0
10 1.000000e+18 1498973872 1498973872 20170702 0
11 1.000000e+18 1498973872 1498973872 20170702 0
12 1.000000e+18 1498999051 1498999051 20170702 0
13 1.000000e+18 1498999051 1498999051 20170702 0
14 1.000000e+18 1498999051 1498999051 20170702 0
15 1.000000e+18 1498999051 1498999051 20170702 0
16 1.000000e+18 1498999051 1498999051 20170702 0
17 1.000000e+18 1498999051 1498999051 20170702 0
18 1.000000e+18 1498999051 1498999051 20170702 0
19 1.000000e+18 1498999051 1498999051 20170702 0
20 1.000000e+18 1498999051 1498999051 20170702 0
21 1.000000e+18 1498999051 1498999051 20170702 0
22 1.000000e+18 1498999051 1498999051 20170702 0
23 1.000000e+18 1498999051 1498999051 20170702 0
24 1.000000e+18 1498999051 1498999051 20170702 0
25 1.000000e+18 1498999051 1498999051 20170702 0
26 1.000000e+18 1498999051 1498999051 20170702 0
27 1.000000e+18 1498999051 1498999051 20170702 0
28 1.000000e+18 1498999051 1498999051 20170702 0
29 1.000000e+18 1498999051 1498999051 20170702 0
.. ... ... ... ... ...
970 1.010000e+18 1498970033 1498970033 20170702 0
971 1.010000e+18 1498970033 1498970033 20170702 0
972 1.010000e+18 1498970033 1498970033 20170702 0
973 1.010000e+18 1498970033 1498970033 20170702 0
974 1.010000e+18 1498970033 1498970033 20170702 0
975 1.010000e+18 1498970033 1498970033 20170702 0
976 1.010000e+18 1498970033 1498970033 20170702 0
977 1.010000e+18 1498970033 1498970033 20170702 0
978 1.010000e+18 1498970033 1498970033 20170702 0
979 1.010000e+18 1498970033 1498970033 20170702 0
980 1.010000e+18 1498970033 1498970033 20170702 0
981 1.010000e+18 1498970033 1498970033 20170702 0
982 1.010000e+18 1498970033 1498970033 20170702 0
983 1.010000e+18 1498970033 1498970033 20170702 0
984 1.010000e+18 1498970033 1498970033 20170702 0
985 1.010000e+18 1498970033 1498970033 20170702 0
986 1.010000e+18 1498970033 1498970033 20170702 0
987 1.010000e+18 1498970033 1498970033 20170702 0
988 1.010000e+18 1498970033 1498970033 20170702 0
989 1.010000e+18 1498970033 1498970033 20170702 0
990 1.010000e+18 1498970033 1498970033 20170702 0
991 1.010000e+18 1498970033 1498970033 20170702 0
992 1.010000e+18 1498970033 1498970033 20170702 0
993 1.010000e+18 1498970033 1498970033 20170702 0
994 1.010000e+18 1498970033 1498970033 20170702 0
995 1.010000e+18 1498970033 1498970033 20170702 0
996 1.010000e+18 1498970033 1498970033 20170702 0
997 1.010000e+18 1498970033 1498970033 20170702 0
998 1.010000e+18 1498970033 1498970033 20170702 0
999 1.010000e+18 1498970033 1498970033 20170702 0
TotalsHits TotalsNewVisits TotalsPageViews TotalsTimeOnSite \
0 2 0 1 4
1 2 1 1 2
2 12 0 2 37
3 12 0 2 37
4 12 0 2 37
5 12 0 2 37
6 12 0 2 37
7 12 0 2 37
8 12 0 2 37
9 12 0 2 37
10 12 0 2 37
11 12 0 2 37
12 46 0 33 3791
13 46 0 33 3791
14 46 0 33 3791
15 46 0 33 3791
16 46 0 33 3791
17 46 0 33 3791
18 46 0 33 3791
19 46 0 33 3791
20 46 0 33 3791
21 46 0 33 3791
22 46 0 33 3791
23 46 0 33 3791
24 46 0 33 3791
25 46 0 33 3791
26 46 0 33 3791
27 46 0 33 3791
28 46 0 33 3791
29 46 0 33 3791
.. ... ... ... ...
970 461 1 175 3412
971 461 1 175 3412
972 461 1 175 3412
973 461 1 175 3412
974 461 1 175 3412
975 461 1 175 3412
976 461 1 175 3412
977 461 1 175 3412
978 461 1 175 3412
979 461 1 175 3412
980 461 1 175 3412
981 461 1 175 3412
982 461 1 175 3412
983 461 1 175 3412
984 461 1 175 3412
985 461 1 175 3412
986 461 1 175 3412
987 461 1 175 3412
988 461 1 175 3412
989 461 1 175 3412
990 461 1 175 3412
991 461 1 175 3412
992 461 1 175 3412
993 461 1 175 3412
994 461 1 175 3412
995 461 1 175 3412
996 461 1 175 3412
997 461 1 175 3412
998 461 1 175 3412
999 461 1 175 3412
channelGrouping ... \
0 Referral ...
1 Organic Search ...
2 Direct ...
3 Direct ...
4 Direct ...
5 Direct ...
6 Direct ...
7 Direct ...
8 Direct ...
9 Direct ...
10 Direct ...
11 Direct ...
12 Direct ...
13 Direct ...
14 Direct ...
15 Direct ...
16 Direct ...
17 Direct ...
18 Direct ...
19 Direct ...
20 Direct ...
21 Direct ...
22 Direct ...
23 Direct ...
24 Direct ...
25 Direct ...
26 Direct ...
27 Direct ...
28 Direct ...
29 Direct ...
.. ... ...
970 Direct ...
971 Direct ...
972 Direct ...
973 Direct ...
974 Direct ...
975 Direct ...
976 Direct ...
977 Direct ...
978 Direct ...
979 Direct ...
980 Direct ...
981 Direct ...
982 Direct ...
983 Direct ...
984 Direct ...
985 Direct ...
986 Direct ...
987 Direct ...
988 Direct ...
989 Direct ...
990 Direct ...
991 Direct ...
992 Direct ...
993 Direct ...
994 Direct ...
995 Direct ...
996 Direct ...
997 Direct ...
998 Direct ...
999 Direct ...
ContentSubcategory FreeformTagsBucket \
0 NaN NaN
1 NaN NaN
2 NaN NaN
3 NaN NaN
4 NaN NaN
5 NaN NaN
6 NaN NaN
7 Materials & Textiles > Market Reporting > Tra... Materials & Textiles
8 NaN NaN
9 NaN NaN
10 NaN NaN
11 NaN NaN
12 NaN NaN
13 NaN NaN
14 NaN NaN
15 NaN NaN
16 NaN NaN
17 NaN NaN
18 NaN NaN
19 NaN NaN
20 NaN NaN
21 NaN NaN
22 NaN NaN
23 NaN NaN
24 NaN NaN
25 NaN NaN
26 NaN NaN
27 NaN NaN
28 NaN NaN
29 NaN NaN
.. ... ...
970 展会 > 产å“分类 > æœè£… NaN
971 展会 > 产å“分类 > æœè£… NaN
972 展会 > 产å“分类 > æœè£… NaN
973 展会 > 产å“分类 > æœè£… NaN
974 展会 > 产å“分类 > æœè£… NaN
975 展会 > 产å“分类 > æœè£… NaN
976 展会 > 产å“分类 > æœè£… NaN
977 展会 > 产å“分类 > æœè£… NaN
978 展会 > 产å“分类 > æœè£… NaN
979 展会 > 产å“分类 > æœè£… NaN
980 展会 > 产å“分类 > æœè£… NaN
981 展会 > 产å“分类 > æœè£… NaN
982 展会 > 产å“分类 > æœè£… NaN
983 展会 > 产å“分类 > æœè£… NaN
984 展会 > 产å“分类 > æœè£… NaN
985 展会 > 产å“分类 > æœè£… NaN
986 展会 > 产å“分类 > æœè£… NaN
987 展会 > 产å“分类 > æœè£… NaN
988 展会 > 产å“分类 > æœè£… NaN
989 展会 > 产å“分类 > æœè£… NaN
990 展会 > 产å“分类 > æœè£… NaN
991 展会 > 产å“分类 > æœè£… NaN
992 展会 > 产å“分类 > æœè£… NaN
993 展会 > 产å“分类 > æœè£… NaN
994 展会 > 产å“分类 > æœè£… NaN
995 展会 > 产å“分类 > æœè£… NaN
996 展会 > 产å“分类 > æœè£… NaN
997 展会 > 产å“分类 > æœè£… NaN
998 展会 > 产å“分类 > æœè£… NaN
999 展会 > 产å“分类 > æœè£… NaN
PageURL \
0 /blogs/brand-advice-instagram-tips/?mkt_tok=ey...
1 /en/
2 /fashion/
3 /fashion/
4 /fashion/
5 /fashion/
6 /fashion/
7 /content/board_viewer/#/73502/page/1
8 /fashion/
9 /fashion/
10 /fashion/
11 /fashion/
12 /search/search.php?startOver=%2Fsearch%2Fdesig...
13 /fashion/
14 /fashion/
15 /content/reports/#/Prints+&+Graphics/m
16 /content/reports/#/Prints+&+Graphics/m
17 /content/reports/#/Prints+&+Graphics/m
18 /content/reports/#/Prints+&+Graphics/m
19 /content/reports/#/Prints+&+Graphics/m
20 /content/reports/#/Prints+&+Graphics/m
21 /content/reports/#/Prints+&+Graphics/m
22 /content/reports/#/Prints+&+Graphics/m
23 /content/reports/#/Prints+&+Graphics/m
24 /content/reports/#/Prints+&+Graphics/m
25 /content/reports/#/Prints+&+Graphics/m
26 /search/search.php?startOver=%2Fsearch%2Fdesig...
27 /content/reports/#/Prints+&+Graphics/m
28 /content/reports/#/Future+Trends/m
29 /content/reports/#/Future+Trends/m
.. ...
970 /content/board_viewer/#/72596/page/13
971 /content/board_viewer/#/72596/page/14
972 /content/board_viewer/#/72596/page/14
973 /content/board_viewer/#/72596/page/15
974 /content/board_viewer/#/72596/page/15
975 /content/board_viewer/#/72596/page/16
976 /content/board_viewer/#/72596/page/16
977 /content/board_viewer/#/72596/page/3
978 /content/board_viewer/#/72596/page/17
979 /content/board_viewer/#/72596/page/17
980 /content/board_viewer/#/72596/page/18
981 /content/board_viewer/#/72596/page/18
982 /content/board_viewer/#/72596/page/17
983 /content/board_viewer/#/72596/page/17
984 /content/board_viewer/#/72596/page/16
985 /content/board_viewer/#/72596/page/16
986 /content/board_viewer/#/72596/page/15
987 /content/board_viewer/#/72596/page/15
988 /content/board_viewer/#/72596/page/3
989 /content/board_viewer/#/72596/page/14
990 /content/board_viewer/#/72596/page/14
991 /content/board_viewer/#/72596/page/13
992 /content/board_viewer/#/72596/page/13
993 /content/board_viewer/#/72596/page/12
994 /content/board_viewer/#/72596/page/12
995 /content/board_viewer/#/72596/page/11
996 /content/board_viewer/#/72596/page/11
997 /content/board_viewer/#/72596/page/10
998 /content/board_viewer/#/72596/page/10
999 /content/board_viewer/#/72596/page/4
SearchCategoryCustomDimension PageNumber UserIDUserScope \
0 NaN NaN NaN
1 NaN NaN NaN
2 NaN NaN 306251.0
3 NaN NaN 306251.0
4 NaN NaN 306251.0
5 NaN NaN 306251.0
6 NaN NaN 306251.0
7 NaN 1.0 306251.0
8 NaN NaN 306251.0
9 NaN NaN 306251.0
10 NaN NaN 306251.0
11 NaN NaN 306251.0
12 NaN NaN 306251.0
13 NaN NaN 306251.0
14 NaN NaN 306251.0
15 NaN 1.0 306251.0
16 NaN 2.0 306251.0
17 NaN 3.0 306251.0
18 NaN 4.0 306251.0
19 NaN 5.0 306251.0
20 NaN 6.0 306251.0
21 NaN 7.0 306251.0
22 NaN 8.0 306251.0
23 NaN 9.0 306251.0
24 NaN 10.0 306251.0
25 NaN 11.0 306251.0
26 NaN NaN 306251.0
27 NaN 1.0 306251.0
28 NaN 1.0 306251.0
29 NaN 2.0 306251.0
.. ... ... ...
970 NaN 12.0 -1.0
971 NaN NaN -1.0
972 NaN 13.0 -1.0
973 NaN NaN -1.0
974 NaN 14.0 -1.0
975 NaN NaN -1.0
976 NaN 15.0 -1.0
977 NaN NaN -1.0
978 NaN NaN -1.0
979 NaN 16.0 -1.0
980 NaN NaN -1.0
981 NaN 17.0 -1.0
982 NaN NaN -1.0
983 NaN 18.0 -1.0
984 NaN NaN -1.0
985 NaN 17.0 -1.0
986 NaN NaN -1.0
987 NaN 16.0 -1.0
988 NaN 2.0 -1.0
989 NaN NaN -1.0
990 NaN 15.0 -1.0
991 NaN NaN -1.0
992 NaN 14.0 -1.0
993 NaN NaN -1.0
994 NaN 13.0 -1.0
995 NaN NaN -1.0
996 NaN 12.0 -1.0
997 NaN NaN -1.0
998 NaN 11.0 -1.0
999 NaN NaN -1.0
SFAccountIDUserScope CompanyIDUserScope BatchID CreatedDate
0 NaN NaN 161 44:33.6
1 NaN NaN 159 47:21.1
2 0018000001CxxM6AAJ 30006.0 160 42:55.4
3 0018000001CxxM6AAJ 30006.0 161 44:33.6
4 0018000001CxxM6AAJ 30006.0 160 42:55.4
5 0018000001CxxM6AAJ 30006.0 160 42:55.4
6 0018000001CxxM6AAJ 30006.0 160 42:55.4
7 0018000001CxxM6AAJ 30006.0 161 44:33.6
8 0018000001CxxM6AAJ 30006.0 161 44:33.6
9 0018000001CxxM6AAJ 30006.0 160 42:55.4
10 0018000001CxxM6AAJ 30006.0 161 44:33.6
11 0018000001CxxM6AAJ 30006.0 161 44:33.6
12 0018000001CxxM6AAJ 30006.0 160 42:55.4
13 0018000001CxxM6AAJ 30006.0 161 44:33.6
14 0018000001CxxM6AAJ 30006.0 160 42:55.4
15 0018000001CxxM6AAJ 30006.0 160 42:55.4
16 0018000001CxxM6AAJ 30006.0 160 42:55.4
17 0018000001CxxM6AAJ 30006.0 160 42:55.4
18 0018000001CxxM6AAJ 30006.0 160 42:55.4
19 0018000001CxxM6AAJ 30006.0 160 42:55.4
20 0018000001CxxM6AAJ 30006.0 161 44:33.6
21 0018000001CxxM6AAJ 30006.0 160 42:55.4
22 0018000001CxxM6AAJ 30006.0 161 44:33.6
23 0018000001CxxM6AAJ 30006.0 160 42:55.4
24 0018000001CxxM6AAJ 30006.0 161 44:33.6
25 0018000001CxxM6AAJ 30006.0 161 44:33.6
26 0018000001CxxM6AAJ 30006.0 160 42:55.4
27 0018000001CxxM6AAJ 30006.0 160 42:55.4
28 0018000001CxxM6AAJ 30006.0 161 44:33.6
29 0018000001CxxM6AAJ 30006.0 161 44:33.6
.. ... ... ... ...
970 0013000000I688dAAB 96058.0 160 42:55.4
971 0013000000I688dAAB 96058.0 160 42:55.4
972 0013000000I688dAAB 96058.0 161 44:33.6
973 0013000000I688dAAB 96058.0 160 42:55.4
974 0013000000I688dAAB 96058.0 160 42:55.4
975 0013000000I688dAAB 96058.0 161 44:33.6
976 0013000000I688dAAB 96058.0 160 42:55.4
977 0013000000I688dAAB 96058.0 161 44:33.6
978 0013000000I688dAAB 96058.0 161 44:33.6
979 0013000000I688dAAB 96058.0 160 42:55.4
980 0013000000I688dAAB 96058.0 160 42:55.4
981 0013000000I688dAAB 96058.0 161 44:33.6
982 0013000000I688dAAB 96058.0 160 42:55.4
983 0013000000I688dAAB 96058.0 160 42:55.4
984 0013000000I688dAAB 96058.0 160 42:55.4
985 0013000000I688dAAB 96058.0 161 44:33.6
986 0013000000I688dAAB 96058.0 160 42:55.4
987 0013000000I688dAAB 96058.0 161 44:33.6
988 0013000000I688dAAB 96058.0 161 44:33.6
989 0013000000I688dAAB 96058.0 160 42:55.4
990 0013000000I688dAAB 96058.0 161 44:33.6
991 0013000000I688dAAB 96058.0 160 42:55.4
992 0013000000I688dAAB 96058.0 161 44:33.6
993 0013000000I688dAAB 96058.0 161 44:33.6
994 0013000000I688dAAB 96058.0 160 42:55.4
995 0013000000I688dAAB 96058.0 161 44:33.6
996 0013000000I688dAAB 96058.0 161 44:33.6
997 0013000000I688dAAB 96058.0 161 44:33.6
998 0013000000I688dAAB 96058.0 160 42:55.4
999 0013000000I688dAAB 96058.0 160 42:55.4
[1000 rows x 61 columns]
In [44]:
In [44]:
In [44]:
In [ ]:
Content source: ShipJ/Code
Similar notebooks: