DataWhale-动手数据分析-Task01：数据加载及探索性数据分析

最新推荐文章于 2022-04-15 17:16:07 发布
最新推荐文章于 2022-04-15 17:16:07 发布
阅读量6.2k 收藏 2
点赞数 1
文章标签： 数据分析 python
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ZZYYhzhy/article/details/108039880
版权

part1 ：数据加载

1.1 载入数据

数据集下载 https://www.kaggle.com/c/titanic/overview

1.1.1 任务一：导入numpy和pandas
import numpy as np
import pandas as pd
1.1.2 任务二：载入数据

(1) 使用相对路径载入数据
(2) 使用绝对路径载入数据

df = pd.read_csv('train.csv')
df.head(3)  # 相对路径
PassengerId Survived Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
0 1 0 3 Braund, Mr. Owen Harris male 22.0 1 0 A/5 21171 7.2500 NaN S
1 2 1 1 Cumings, Mrs. John Bradley (Florence Briggs Th... female 38.0 1 0 PC 17599 71.2833 C85 C
2 3 1 3 Heikkinen, Miss. Laina female 26.0 0 0 STON/O2. 3101282 7.9250 NaN S 
df = pd.read_csv('C:\\Users\\Administrator\\00\\1having_study\\hands-on-data-analysis-master\\第一单元项目集合\\train.csv')  # 绝对路径
df.head(3)
PassengerId Survived Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
0 1 0 3 Braund, Mr. Owen Harris male 22.0 1 0 A/5 21171 7.2500 NaN S
1 2 1 1 Cumings, Mrs. John Bradley (Florence Briggs Th... female 38.0 1 0 PC 17599 71.2833 C85 C
2 3 1 3 Heikkinen, Miss. Laina female 26.0 0 0 STON/O2. 3101282 7.9250 NaN S
【提示1】相对路径载入报错时，尝试使用os.getcwd()查看当前工作目录。
import os
os.getcwd()  # 获取当前目录

'C:\\Users\\Administrator\\00\\1having_study\\hands-on-data-analysis-master\\第一单元项目集合'
【思考2】知道数据加载的方法后，试试pd.read_csv()和pd.read_table()的不同，
如果想让他们效果一样，需要怎么做？了解一下’.tsv’和’.csv’的不同，如何加载这两个数据集？
  • pd.read_csv()的默认分隔符是逗号(’,’)，pd.read_table()的默认分隔符是制表符(‘\t’)
pd.read_csv('train.csv')   # 不用指定分隔符
pd.read_table('train.csv',sep=',').head(2)  # 指定分隔符为‘,’
PassengerId Survived Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
0 1 0 3 Braund, Mr. Owen Harris male 22.0 1 0 A/5 21171 7.2500 NaN S
1 2 1 1 Cumings, Mrs. John Bradley (Florence Briggs Th... female 38.0 1 0 PC 17599 71.2833 C85 C
  • TSV是Tab-separated values的缩写，即制表符分隔值;CSV是Comma-separated values的缩写，即逗号分隔值。
  • 从名称上即可知道，TSV是用制表符（Tab,’\t’）作为字段值的分隔符；CSV是用半角逗号（’,’）作为字段值的分隔符；IANA规定的标准TSV格式，字段值之中是不允许出现制表符的。
  • Python的csv模块准确的讲应该叫做dsv模块，因为它实际上是支持范式的分隔符分隔值文件（DSV，delimiter-separated values）的。delimiter参数值默认为半角逗号，即默认将被处理文件视为CSV。当delimiter=’\t’时，被处理文件就是TSV。
  • 参考链接：https://blog.csdn.net/ARPOSPF/article/details/80407370
1.1.3 任务三：每1000行为一个数据模块，逐块读取
chunker = pd.read_csv('train.csv', chunksize=10)

chunker.get_chunk(2)   # 依次获取两行
PassengerId Survived Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
22 23 1 3 McGowan, Miss. Anna "Annie" female 15 0 0 330923 8.0292 NaN Q
23 24 1 1 Sloper, Mr. William Thompson male 28 0 0 113788 35.5000 A6 S
【思考】什么是逐块读取？为什么要逐块读取呢？
  • 逐块读取就是指把数据分成好几块依次读取
  • 在数据量过大的时候，可能会报出MemoryError的错误，所以需要分块读取数据
print(chunker)

<pandas.io.parsers.TextFileReader object at 0x000002649FAE1908>

for chunk in chunker:
    print(chunk)

   PassengerId  Survived  Pclass  \
0            1         0       3   
1            2         1       1   
2            3         1       3   
3            4         1       1   
4            5         0       3   
5            6         0       3   
6            7         0       1   
7            8         0       3   
8            9         1       3   
9           10         1       2   

                                                Name     Sex   Age  SibSp  \
0                            Braund, Mr. Owen Harris    male  22.0      1   
1  Cumings, Mrs. John Bradley (Florence Briggs Th...  female  38.0      1   
2                             Heikkinen, Miss. Laina  female  26.0      0   
3       Futrelle, Mrs. Jacques Heath (Lily May Peel)  female  35.0      1   
4                           Allen, Mr. William Henry    male  35.0      0   
5                                   Moran, Mr. James    male   NaN      0   
6                            McCarthy, Mr. Timothy J    male  54.0      0   
7                     Palsson, Master. Gosta Leonard    male   2.0      3   
8  Johnson, Mrs. Oscar W (Elisabeth Vilhelmina Berg)  female  27.0      0   
9                Nasser, Mrs. Nicholas (Adele Achem)  female  14.0      1   

   Parch            Ticket     Fare Cabin Embarked  
0      0         A/5 21171   7.2500   NaN        S  
1      0          PC 17599  71.2833   C85        C  
2      0  STON/O2. 3101282   7.9250   NaN        S  
3      0            113803  53.1000  C123        S  
4      0            373450   8.0500   NaN        S  
5      0            330877   8.4583   NaN        Q  
6      0             17463  51.8625   E46        S  
7      1            349909  21.0750   NaN        S  
8      2            347742  11.1333   NaN        S  
9      0            237736  30.0708   NaN        C  
    PassengerId  Survived  Pclass  \
10           11         1       3   
11           12         1       1   
12           13         0       3   
13           14         0       3   
14           15         0       3   
15           16         1       2   
16           17         0       3   
17           18         1       2   
18           19         0       3   
19           20         1       3   

                                                 Name     Sex   Age  SibSp  \
10                    Sandstrom, Miss. Marguerite Rut  female   4.0      1   
11                           Bonnell, Miss. Elizabeth  female  58.0      0   
12                     Saundercock, Mr. William Henry    male  20.0      0   
13                        Andersson, Mr. Anders Johan    male  39.0      1   
14               Vestrom, Miss. Hulda Amanda Adolfina  female  14.0      0   
15                   Hewlett, Mrs. (Mary D Kingcome)   female  55.0      0   
16                               Rice, Master. Eugene    male   2.0      4   
17                       Williams, Mr. Charles Eugene    male   NaN      0   
18  Vander Planke, Mrs. Julius (Emelia Maria Vande...  female  31.0      1   
19                            Masselmani, Mrs. Fatima  female   NaN      0   

    Parch     Ticket     Fare Cabin Embarked  
10      1    PP 9549  16.7000    G6        S  
11      0     113783  26.5500  C103        S  
12      0  A/5. 2151   8.0500   NaN        S  
13      5     347082  31.2750   NaN        S  
14      0     350406   7.8542   NaN        S  
15      0     248706  16.0000   NaN        S  
16      1     382652  29.1250   NaN        Q  
17      0     244373  13.0000   NaN        S  
18      0     345763  18.0000   NaN        S  
19      0       2649   7.2250   NaN        C  
    PassengerId  Survived  Pclass  \
20           21         0       2   
21           22         1       2   
22           23         1       3   
23           24         1       1   
24           25         0       3   
25           26         1       3   
26           27         0       3   
27           28         0       1   
28           29         1       3   
29           30         0       3   

                                                 Name     Sex   Age  SibSp  \
20                               Fynney, Mr. Joseph J    male  35.0      0   
21                              Beesley, Mr. Lawrence    male  34.0      0   
22                        McGowan, Miss. Anna "Annie"  female  15.0      0   
23                       Sloper, Mr. William Thompson    male  28.0      0   
24                      Palsson, Miss. Torborg Danira  female   8.0      3   
25  Asplund, Mrs. Carl Oscar (Selma Augusta Emilia...  female  38.0      1   
26                            Emir, Mr. Farred Chehab    male   NaN      0   
27                     Fortune, Mr. Charles Alexander    male  19.0      3   
28                      O'Dwyer, Miss. Ellen "Nellie"  female   NaN      0   
29                                Todoroff, Mr. Lalio    male   NaN      0   

    Parch  Ticket      Fare        Cabin Embarked  
20      0  239865   26.0000          NaN        S  
21      0  248698   13.0000          D56        S  
22      0  330923    8.0292          NaN        Q  
23      0  113788   35.5000           A6        S  
24      1  349909   21.0750          NaN        S  
25      5  347077   31.3875          NaN        S  
26      0    2631    7.2250          NaN        C  
27      2   19950  263.0000  C23 C25 C27        S  
28      0  330959    7.8792          NaN        Q  
29      0  349216    7.8958          NaN        S  
    PassengerId  Survived  Pclass  \
30           31         0       1   
31           32         1       1   
32           33         1       3   
33           34         0       2   
34           35         0       1   
35           36         0       1   
36           37         1       3   
37           38         0       3   
38           39         0       3   
39           40         1       3   

                                              Name     Sex   Age  SibSp  \
30                        Uruchurtu, Don. Manuel E    male  40.0      0   
31  Spencer, Mrs. William Augustus (Marie Eugenie)  female   NaN      1   
32                        Glynn, Miss. Mary Agatha  female   NaN      0   
33                           Wheadon, Mr. Edward H    male  66.0      0   
34                         Meyer, Mr. Edgar Joseph    male  28.0      1   
35                  Holverson, Mr. Alexander Oskar    male  42.0      1   
36                                Mamee, Mr. Hanna    male   NaN      0   
37                        Cann, Mr. Ernest Charles    male  21.0      0   
38              Vander Planke, Miss. Augusta Maria  female  18.0      2   
39                     Nicola-Yarred, Miss. Jamila  female  14.0      1   

    Parch      Ticket      Fare Cabin Embarked  
30      0    PC 17601   27.7208   NaN        C  
31      0    PC 17569  146.5208   B78        C  
32      0      335677    7.7500   NaN        Q  
33      0  C.A. 24579   10.5000   NaN        S  
34      0    PC 17604   82.1708   NaN        C  
35      0      113789   52.0000   NaN        S  
36      0        2677    7.2292   NaN        C  
37      0  A./5. 2152    8.0500   NaN        S  
38      0      345764   18.0000   NaN        S  
39      0        2651   11.2417   NaN        C  
    PassengerId  Survived  Pclass  \
40           41         0       3   
41           42         0       2   
42           43         0       3   
43           44         1       2   
44           45         1       3   
45           46         0       3   
46           47         0       3   
47           48         1       3   
48           49         0       3   
49           50         0       3   

                                                 Name     Sex   Age  SibSp  \
40     Ahlin, Mrs. Johan (Johanna Persdotter Larsson)  female  40.0      1   
41  Turpin, Mrs. William John Robert (Dorothy Ann ...  female  27.0      1   
42                                Kraeff, Mr. Theodor    male   NaN      0   
43           Laroche, Miss. Simonne Marie Anne Andree  female   3.0      1   
44                      Devaney, Miss. Margaret Delia  female  19.0      0   
45                           Rogers, Mr. William John    male   NaN      0   
46                                  Lennon, Mr. Denis    male   NaN      1   
47                          O'Driscoll, Miss. Bridget  female   NaN      0   
48                                Samaan, Mr. Youssef    male   NaN      2   
49      Arnold-Franchi, Mrs. Josef (Josefine Franchi)  female  18.0      1   

    Parch           Ticket     Fare  Cabin Embarked  
40      0             7546   9.4750    NaN        S  
41      0            11668  21.0000    NaN        S  
42      0           349253   7.8958    NaN        C  
43      2    SC/Paris 2123  41.5792    NaN        C  
44      0           330958   7.8792    NaN        Q  
45      0  S.C./A.4. 23567   8.0500    NaN        S  
46      0           370371  15.5000    NaN        Q  
47      0            14311   7.7500    NaN        Q  
48      0             2662  21.6792    NaN        C  
49      0           349237  17.8000    NaN        S  
    PassengerId  Survived  Pclass  \
50           51         0       3   
51           52         0       3   
52           53         1       1   
53           54         1       2   
54           55         0       1   
55           56         1       1   
56           57         1       2   
57           58         0       3   
58           59         1       2   
59           60         0       3   

                                                 Name     Sex   Age  SibSp  \
50                         Panula, Master. Juha Niilo    male   7.0      4   
51                       Nosworthy, Mr. Richard Cater    male  21.0      0   
52           Harper, Mrs. Henry Sleeper (Myna Haxtun)  female  49.0      1   
53  Faunthorpe, Mrs. Lizzie (Elizabeth Anne Wilkin...  female  29.0      1   
54                     Ostby, Mr. Engelhart Cornelius    male  65.0      0   
55                                  Woolner, Mr. Hugh    male   NaN      0   
56                                  Rugg, Miss. Emily  female  21.0      0   
57                                Novel, Mr. Mansouer    male  28.5      0   
58                       West, Miss. Constance Mirium  female   5.0      1   
59                 Goodwin, Master. William Frederick    male  11.0      5   

    Parch      Ticket     Fare Cabin Embarked  
50      1     3101295  39.6875   NaN        S  
51      0  A/4. 39886   7.8000   NaN        S  
52      0    PC 17572  76.7292   D33        C  
53      0        2926  26.0000   NaN        S  
54      1      113509  61.9792   B30        C  
55      0       19947  35.5000   C52        S  
56      0  C.A. 31026  10.5000   NaN        S  
57      0        2697   7.2292   NaN        C  
58      2  C.A. 34651  27.7500   NaN        S  
59      2     CA 2144  46.9000   NaN        S  
    PassengerId  Survived  Pclass                             Name     Sex  \
60           61         0       3            Sirayanian, Mr. Orsen    male   
61           62         1       1              Icard, Miss. Amelie  female   
62           63         0       1      Harris, Mr. Henry Birkhardt    male   
63           64         0       3            Skoog, Master. Harald    male   
64           65         0       1            Stewart, Mr. Albert A    male   
65           66         1       3         Moubarek, Master. Gerios    male   
66           67         1       2     Nye, Mrs. (Elizabeth Ramell)  female   
67           68         0       3         Crease, Mr. Ernest James    male   
68           69         1       3  Andersson, Miss. Erna Alexandra  female   
69           70         0       3                Kink, Mr. Vincenz    male   

     Age  SibSp  Parch      Ticket     Fare Cabin Embarked  
60  22.0      0      0        2669   7.2292   NaN        C  
61  38.0      0      0      113572  80.0000   B28      NaN  
62  45.0      1      0       36973  83.4750   C83        S  
63   4.0      3      2      347088  27.9000   NaN        S  
64   NaN      0      0    PC 17605  27.7208   NaN        C  
65   NaN      1      1        2661  15.2458   NaN        C  
66  29.0      0      0  C.A. 29395  10.5000   F33        S  
67  19.0      0      0   S.P. 3464   8.1583   NaN        S  
68  17.0      4      2     3101281   7.9250   NaN        S  
69  26.0      2      0      315151   8.6625   NaN        S  
    PassengerId  Survived  Pclass                           Name     Sex  \
70           71         0       2     Jenkin, Mr. Stephen Curnow    male   
71           72         0       3     Goodwin, Miss. Lillian Amy  female   
72           73         0       2           Hood, Mr. Ambrose Jr    male   
73           74         0       3    Chronopoulos, Mr. Apostolos    male   
74           75         1       3                  Bing, Mr. Lee    male   
75           76         0       3        Moen, Mr. Sigurd Hansen    male   
76           77         0       3              Staneff, Mr. Ivan    male   
77           78         0       3       Moutal, Mr. Rahamin Haim    male   
78           79         1       2  Caldwell, Master. Alden Gates    male   
79           80         1       3       Dowdell, Miss. Elizabeth  female   

      Age  SibSp  Parch        Ticket     Fare  Cabin Embarked  
70  32.00      0      0    C.A. 33111  10.5000    NaN        S  
71  16.00      5      2       CA 2144  46.9000    NaN        S  
72  21.00      0      0  S.O.C. 14879  73.5000    NaN        S  
73  26.00      1      0          2680  14.4542    NaN        C  
74  32.00      0      0          1601  56.4958    NaN        S  
75  25.00      0      0        348123   7.6500  F G73        S  
76    NaN      0      0        349208   7.8958    NaN        S  
77    NaN      0      0        374746   8.0500    NaN        S  
78   0.83      0      2        248738  29.0000    NaN        S  
79  30.00      0      0        364516  12.4750    NaN        S  
    PassengerId  Survived  Pclass  \
80           81         0       3   
81           82         1       3   
82           83         1       3   
83           84         0       1   
84           85         1       2   
85           86         1       3   
86           87         0       3   
87           88         0       3   
88           89         1       1   
89           90         0       3   

                                                 Name     Sex   Age  SibSp  \
80                               Waelens, Mr. Achille    male  22.0      0   
81                        Sheerlinck, Mr. Jan Baptist    male  29.0      0   
82                     McDermott, Miss. Brigdet Delia  female   NaN      0   
83                            Carrau, Mr. Francisco M    male  28.0      0   
84                                Ilett, Miss. Bertha  female  17.0      0   
85  Backstrom, Mrs. Karl Alfred (Maria Mathilda Gu...  female  33.0      3   
86                             Ford, Mr. William Neal    male  16.0      1   
87                      Slocovski, Mr. Selman Francis    male   NaN      0   
88                         Fortune, Miss. Mabel Helen  female  23.0      3   
89                             Celotti, Mr. Francesco    male  24.0      0   

    Parch           Ticket      Fare        Cabin Embarked  
80      0           345767    9.0000          NaN        S  
81      0           345779    9.5000          NaN        S  
82      0           330932    7.7875          NaN        Q  
83      0           113059   47.1000          NaN        S  
84      0       SO/C 14885   10.5000          NaN        S  
85      0          3101278   15.8500          NaN        S  
86      3       W./C. 6608   34.3750          NaN        S  
87      0  SOTON/OQ 392086    8.0500          NaN        S  
88      2            19950  263.0000  C23 C25 C27        S  
89      0           343275    8.0500          NaN        S  
    PassengerId  Survived  Pclass                                  Name  \
90           91         0       3                  Christmann, Mr. Emil   
91           92         0       3            Andreasson, Mr. Paul Edvin   
92           93         0       1           Chaffee, Mr. Herbert Fuller   
93           94         0       3               Dean, Mr. Bertram Frank   
94           95         0       3                     Coxon, Mr. Daniel   
95           96         0       3           Shorney, Mr. Charles Joseph   
96           97         0       1             Goldschmidt, Mr. George B   
97           98         1       1       Greenfield, Mr. William Bertram   
98           99         1       2  Doling, Mrs. John T (Ada Julia Bone)   
99          100         0       2                     Kantor, Mr. Sinai   

       Sex   Age  SibSp  Parch       Ticket     Fare    Cabin Embarked  
90    male  29.0      0      0       343276   8.0500      NaN        S  
91    male  20.0      0      0       347466   7.8542      NaN        S  
92    male  46.0      1      0  W.E.P. 5734  61.1750      E31        S  
93    male  26.0      1      2    C.A. 2315  20.5750      NaN        S  
94    male  59.0      0      0       364500   7.2500      NaN        S  
95    male   NaN      0      0       374910   8.0500      NaN        S  
96    male  71.0      0      0     PC 17754  34.6542       A5        C  
97    male  23.0      0      1     PC 17759  63.3583  D10 D12        C  
98  female  34.0      0      1       231919  23.0000      NaN        S  
99    male  34.0      1      0       244367  26.0000      NaN        S  
     PassengerId  Survived  Pclass                              Name     Sex  \
100          101         0       3           Petranec, Miss. Matilda  female   
101          102         0       3  Petroff, Mr. Pastcho ("Pentcho")    male   
102          103         0       1         White, Mr. Richard Frasar    male   
103          104         0       3        Johansson, Mr. Gustaf Joel    male   
104          105         0       3    Gustafsson, Mr. Anders Vilhelm    male   
105          106         0       3             Mionoff, Mr. Stoytcho    male   
106          107         1       3  Salkjelsvik, Miss. Anna Kristine  female   
107          108         1       3            Moss, Mr. Albert Johan    male   
108          109         0       3                   Rekic, Mr. Tido    male   
109          110         1       3               Moran, Miss. Bertha  female   

      Age  SibSp  Parch   Ticket     Fare Cabin Embarked  
100  28.0      0      0   349245   7.8958   NaN        S  
101   NaN      0      0   349215   7.8958   NaN        S  
102  21.0      0      1    35281  77.2875   D26        S  
103  33.0      0      0     7540   8.6542   NaN        S  
104  37.0      2      0  3101276   7.9250   NaN        S  
105  28.0      0      0   349207   7.8958   NaN        S  
106  21.0      0      0   343120   7.6500   NaN        S  
107   NaN      0      0   312991   7.7750   NaN        S  
108  38.0      0      0   349249   7.8958   NaN        S  
109   NaN      1      0   371110  24.1500   NaN        Q  
     PassengerId  Survived  Pclass                               Name     Sex  \
110          111         0       1     Porter, Mr. Walter Chamberlain    male   
111          112         0       3               Zabour, Miss. Hileni  female   
112          113         0       3             Barton, Mr. David John    male   
113          114         0       3            Jussila, Miss. Katriina  female   
114          115         0       3              Attalah, Miss. Malake  female   
115          116         0       3              Pekoniemi, Mr. Edvard    male   
116          117         0       3               Connors, Mr. Patrick    male   
117          118         0       2    Turpin, Mr. William John Robert    male   
118          119         0       1           Baxter, Mr. Quigg Edmond    male   
119          120         0       3  Andersson, Miss. Ellis Anna Maria  female   

      Age  SibSp  Parch             Ticket      Fare    Cabin Embarked  
110  47.0      0      0             110465   52.0000     C110        S  
111  14.5      1      0               2665   14.4542      NaN        C  
112  22.0      0      0             324669    8.0500      NaN        S  
113  20.0      1      0               4136    9.8250      NaN        S  
114  17.0      0      0               2627   14.4583      NaN        C  
115  21.0      0      0  STON/O 2. 3101294    7.9250      NaN        S  
116  70.5      0      0             370369    7.7500      NaN        Q  
117  29.0      1      0              11668   21.0000      NaN        S  
118  24.0      0      1           PC 17558  247.5208  B58 B60        C  
119   2.0      4      2             347082   31.2750      NaN        S  
     PassengerId  Survived  Pclass                          Name     Sex  \
120          121         0       2   Hickman, Mr. Stanley George    male   
121          122         0       3    Moore, Mr. Leonard Charles    male   
122          123         0       2          Nasser, Mr. Nicholas    male   
123          124         1       2           Webber, Miss. Susan  female   
124          125         0       1   White, Mr. Percival Wayland    male   
125          126         1       3  Nicola-Yarred, Master. Elias    male   
126          127         0       3           McMahon, Mr. Martin    male   
127          128         1       3     Madsen, Mr. Fridtjof Arne    male   
128          129         1       3             Peter, Miss. Anna  female   
129          130         0       3            Ekstrom, Mr. Johan    male   

      Age  SibSp  Parch        Ticket     Fare  Cabin Embarked  
120  21.0      2      0  S.O.C. 14879  73.5000    NaN        S  
121   NaN      0      0     A4. 54510   8.0500    NaN        S  
122  32.5      1      0        237736  30.0708    NaN        C  
123  32.5      0      0         27267  13.0000   E101        S  
124  54.0      0      1         35281  77.2875    D26        S  
125  12.0      1      0          2651  11.2417    NaN        C  
126   NaN      0      0        370372   7.7500    NaN        Q  
127  24.0      0      0       C 17369   7.1417    NaN        S  
128   NaN      1      1          2668  22.3583  F E69        C  
129  45.0      0      0        347061   6.9750    NaN        S  
     PassengerId  Survived  Pclass  \
130          131         0       3   
131          132         0       3   
132          133         0       3   
133          134         1       2   
134          135         0       2   
135          136         0       2   
136          137         1       1   
137          138         0       1   
138          139         0       3   
139          140         0       1   

                                               Name     Sex  Age  SibSp  \
130                            Drazenoic, Mr. Jozef    male   33      0   
131                  Coelho, Mr. Domingos Fernandeo    male   20      0   
132  Robins, Mrs. Alexander A (Grace Charity Laury)  female   47      1   
133   Weisz, Mrs. Leopold (Mathilde Francoise Pede)  female   29      1   
134                  Sobey, Mr. Samuel James Hayden    male   25      0   
135                              Richard, Mr. Emile    male   23      0   
136                    Newsom, Miss. Helen Monypeny  female   19      0   
137                     Futrelle, Mr. Jacques Heath    male   37      1   
138                             Osen, Mr. Olaf Elon    male   16      0   
139                              Giglio, Mr. Victor    male   24      0   

     Parch              Ticket     Fare Cabin Embarked  
130      0              349241   7.8958   NaN        C  
131      0  SOTON/O.Q. 3101307   7.0500   NaN        S  
132      0           A/5. 3337  14.5000   NaN        S  
133      0              228414  26.0000   NaN        S  
134      0          C.A. 29178  13.0000   NaN        S  
135      0       SC/PARIS 2133  15.0458   NaN        C  
136      2               11752  26.2833   D47        S  
137      0              113803  53.1000  C123        S  
138      0                7534   9.2167   NaN        S  
139      0            PC 17593  79.2000   B86        C  
     PassengerId  Survived  Pclass  \
140          141         0       3   
141          142         1       3   
142          143         1       3   
143          144         0       3   
144          145         0       2   
145          146         0       2   
146          147         1       3   
147          148         0       3   
148          149         0       2   
149          150         0       2   

                                                  Name     Sex   Age  SibSp  \
140                      Boulos, Mrs. Joseph (Sultana)  female   NaN      0   
141                           Nysten, Miss. Anna Sofia  female  22.0      0   
142  Hakkarainen, Mrs. Pekka Pietari (Elin Matilda ...  female  24.0      1   
143                                Burke, Mr. Jeremiah    male  19.0      0   
144                         Andrew, Mr. Edgardo Samuel    male  18.0      0   
145                       Nicholls, Mr. Joseph Charles    male  19.0      1   
146       Andersson, Mr. August Edvard ("Wennerstrom")    male  27.0      0   
147                   Ford, Miss. Robina Maggie "Ruby"  female   9.0      2   
148           Navratil, Mr. Michel ("Louis M Hoffman")    male  36.5      0   
149                  Byles, Rev. Thomas Roussel Davids    male  42.0      0   

     Parch            Ticket     Fare Cabin Embarked  
140      2              2678  15.2458   NaN        C  
141      0            347081   7.7500   NaN        S  
142      0  STON/O2. 3101279  15.8500   NaN        S  
143      0            365222   6.7500   NaN        Q  
144      0            231945  11.5000   NaN        S  
145      1        C.A. 33112  36.7500   NaN        S  
146      0            350043   7.7958   NaN        S  
147      2        W./C. 6608  34.3750   NaN        S  
148      2            230080  26.0000    F2        S  
149      0            244310  13.0000   NaN        S  
     PassengerId  Survived  Pclass                               Name     Sex  \
150          151         0       2         Bateman, Rev. Robert James    male   
151          152         1       1  Pears, Mrs. Thomas (Edith Wearne)  female   
152          153         0       3                   Meo, Mr. Alfonzo    male   
153          154         0       3    van Billiard, Mr. Austin Blyler    male   
154          155         0       3              Olsen, Mr. Ole Martin    male   
155          156         0       1        Williams, Mr. Charles Duane    male   
156          157         1       3   Gilnagh, Miss. Katherine "Katie"  female   
157          158         0       3                    Corn, Mr. Harry    male   
158          159         0       3                Smiljanic, Mr. Mile    male   
159          160         0       3         Sage, Master. Thomas Henry    male   

      Age  SibSp  Parch           Ticket     Fare Cabin Embarked  
150  51.0      0      0      S.O.P. 1166  12.5250   NaN        S  
151  22.0      1      0           113776  66.6000    C2        S  
152  55.5      0      0       A.5. 11206   8.0500   NaN        S  
153  40.5      0      2         A/5. 851  14.5000   NaN        S  
154   NaN      0      0        Fa 265302   7.3125   NaN        S  
155  51.0      0      1         PC 17597  61.3792   NaN        C  
156  16.0      0      0            35851   7.7333   NaN        Q  
157  30.0      0      0  SOTON/OQ 392090   8.0500   NaN        S  
158   NaN      0      0           315037   8.6625   NaN        S  
159   NaN      8      2         CA. 2343  69.5500   NaN        S  
     PassengerId  Survived  Pclass  \
160          161         0       3   
161          162         1       2   
162          163         0       3   
163          164         0       3   
164          165         0       3   
165          166         1       3   
166          167         1       1   
167          168         0       3   
168          169         0       1   
169          170         0       3   

                                                  Name     Sex   Age  SibSp  \
160                           Cribb, Mr. John Hatfield    male  44.0      0   
161  Watt, Mrs. James (Elizabeth "Bessie" Inglis Mi...  female  40.0      0   
162                         Bengtsson, Mr. John Viktor    male  26.0      0   
163                                    Calic, Mr. Jovo    male  17.0      0   
164                       Panula, Master. Eino Viljami    male   1.0      4   
165    Goldsmith, Master. Frank John William "Frankie"    male   9.0      0   
166             Chibnall, Mrs. (Edith Martha Bowerman)  female   NaN      0   
167    Skoog, Mrs. William (Anna Bernhardina Karlsson)  female  45.0      1   
168                                Baumann, Mr. John D    male   NaN      0   
169                                      Ling, Mr. Lee    male  28.0      0   

     Parch      Ticket     Fare Cabin Embarked  
160      1      371362  16.1000   NaN        S  
161      0  C.A. 33595  15.7500   NaN        S  
162      0      347068   7.7750   NaN        S  
163      0      315093   8.6625   NaN        S  
164      1     3101295  39.6875   NaN        S  
165      2      363291  20.5250   NaN        S  
166      1      113505  55.0000   E33        S  
167      4      347088  27.9000   NaN        S  
168      0    PC 17318  25.9250   NaN        S  
169      0        1601  56.4958   NaN        S  
     PassengerId  Survived  Pclass                           Name     Sex  \
170          171         0       1      Van der hoef, Mr. Wyckoff    male   
171          172         0       3           Rice, Master. Arthur    male   
172          173         1       3   Johnson, Miss. Eleanor Ileen  female   
173          174         0       3      Sivola, Mr. Antti Wilhelm    male   
174          175         0       1        Smith, Mr. James Clinch    male   
175          176         0       3         Klasen, Mr. Klas Albin    male   
176          177         0       3  Lefebre, Master. Henry Forbes    male   
177          178         0       1     Isham, Miss. Ann Elizabeth  female   
178          179         0       2             Hale, Mr. Reginald    male   
179          180         0       3            Leonard, Mr. Lionel    male   

      Age  SibSp  Parch             Ticket     Fare Cabin Embarked  
170  61.0      0      0             111240  33.5000   B19        S  
171   4.0      4      1             382652  29.1250   NaN        Q  
172   1.0      1      1             347742  11.1333   NaN        S  
173  21.0      0      0  STON/O 2. 3101280   7.9250   NaN        S  
174  56.0      0      0              17764  30.6958    A7        C  
175  18.0      1      1             350404   7.8542   NaN        S  
176   NaN      3      1               4133  25.4667   NaN        S  
177  50.0      0      0           PC 17595  28.7125   C49        C  
178  30.0      0      0             250653  13.0000   NaN        S  
179  36.0      0      0               LINE   0.0000   NaN        S  
     PassengerId  Survived  Pclass  \
180          181         0       3   
181          182         0       2   
182          183         0       3   
183          184         1       2   
184          185         1       3   
185          186         0       1   
186          187         1       3   
187          188         1       1   
188          189         0       3   
189          190         0       3   

                                                Name     Sex   Age  SibSp  \
180                     Sage, Miss. Constance Gladys  female   NaN      8   
181                                 Pernot, Mr. Rene    male   NaN      0   
182            Asplund, Master. Clarence Gustaf Hugo    male   9.0      4   
183                        Becker, Master. Richard F    male   1.0      2   
184              Kink-Heilmann, Miss. Luise Gretchen  female   4.0      0   
185                            Rood, Mr. Hugh Roscoe    male   NaN      0   
186  O'Brien, Mrs. Thomas (Johanna "Hannah" Godfrey)  female   NaN      1   
187    Romaine, Mr. Charles Hallace ("Mr C Rolmane")    male  45.0      0   
188                                 Bourke, Mr. John    male  40.0      1   
189                              Turcin, Mr. Stjepan    male  36.0      0   

     Parch         Ticket     Fare Cabin Embarked  
180      2       CA. 2343  69.5500   NaN        S  
181      0  SC/PARIS 2131  15.0500   NaN        C  
182      2         347077  31.3875   NaN        S  
183      1         230136  39.0000    F4        S  
184      2         315153  22.0250   NaN        S  
185      0         113767  50.0000   A32        S  
186      0         370365  15.5000   NaN        Q  
187      0         111428  26.5500   NaN        S  
188      1         364849  15.5000   NaN        Q  
189      0         349247   7.8958   NaN        S  
     PassengerId  Survived  Pclass  \
190          191         1       2   
191          192         0       2   
192          193         1       3   
193          194         1       2   
194          195         1       1   
195          196         1       1   
196          197         0       3   
197          198         0       3   
198          199         1       3   
199          200         0       2   

                                                Name     Sex   Age  SibSp  \
190                              Pinsky, Mrs. (Rosa)  female  32.0      0   
191                            Carbines, Mr. William    male  19.0      0   
192  Andersen-Jensen, Miss. Carla Christine Nielsine  female  19.0      1   
193                       Navratil, Master. Michel M    male   3.0      1   
194        Brown, Mrs. James Joseph (Margaret Tobin)  female  44.0      0   
195                             Lurette, Miss. Elise  female  58.0      0   
196                              Mernagh, Mr. Robert    male   NaN      0   
197                 Olsen, Mr. Karl Siegwart Andreas    male  42.0      0   
198                 Madigan, Miss. Margaret "Maggie"  female   NaN      0   
199           Yrois, Miss. Henriette ("Mrs Harbeck")  female  24.0      0   

     Parch    Ticket      Fare Cabin Embarked  
190      0    234604   13.0000   NaN        S  
191      0     28424   13.0000   NaN        S  
192      0    350046    7.8542   NaN        S  
193      1    230080   26.0000    F2        S  
194      0  PC 17610   27.7208    B4        C  
195      0  PC 17569  146.5208   B80        C  
196      0    368703    7.7500   NaN        Q  
197      1      4579    8.4042   NaN        S  
198      0    370370    7.7500   NaN        Q  
199      0    248747   13.0000   NaN        S  
     PassengerId  Survived  Pclass                            Name     Sex  \
200          201         0       3  Vande Walle, Mr. Nestor Cyriel    male   
201          202         0       3             Sage, Mr. Frederick    male   
202          203         0       3      Johanson, Mr. Jakob Alfred    male   
203          204         0       3            Youseff, Mr. Gerious    male   
204          205         1       3        Cohen, Mr. Gurshon "Gus"    male   
205          206         0       3      Strom, Miss. Telma Matilda  female   
206          207         0       3      Backstrom, Mr. Karl Alfred    male   
207          208         1       3     Albimona, Mr. Nassef Cassem    male   
208          209         1       3       Carr, Miss. Helen "Ellen"  female   
209          210         1       1                Blank, Mr. Henry    male   

      Age  SibSp  Parch    Ticket     Fare Cabin Embarked  
200  28.0      0      0    345770   9.5000   NaN        S  
201   NaN      8      2  CA. 2343  69.5500   NaN        S  
202  34.0      0      0   3101264   6.4958   NaN        S  
203  45.5      0      0      2628   7.2250   NaN        C  
204  18.0      0      0  A/5 3540   8.0500   NaN        S  
205   2.0      0      1    347054  10.4625    G6        S  
206  32.0      1      0   3101278  15.8500   NaN        S  
207  26.0      0      0      2699  18.7875   NaN        C  
208  16.0      0      0    367231   7.7500   NaN        Q  
209  40.0      0      0    112277  31.0000   A31        C  
     PassengerId  Survived  Pclass                          Name     Sex  \
210          211         0       3                Ali, Mr. Ahmed    male   
211          212         1       2    Cameron, Miss. Clear Annie  female   
212          213         0       3        Perkin, Mr. John Henry    male   
213          214         0       2   Givard, Mr. Hans Kristensen    male   
214          215         0       3           Kiernan, Mr. Philip    male   
215          216         1       1       Newell, Miss. Madeleine  female   
216          217         1       3        Honkanen, Miss. Eliina  female   
217          218         0       2  Jacobsohn, Mr. Sidney Samuel    male   
218          219         1       1         Bazzani, Miss. Albina  female   
219          220         0       2            Harris, Mr. Walter    male   

      Age  SibSp  Parch              Ticket      Fare Cabin Embarked  
210  24.0      0      0  SOTON/O.Q. 3101311    7.0500   NaN        S  
211  35.0      0      0        F.C.C. 13528   21.0000   NaN        S  
212  22.0      0      0           A/5 21174    7.2500   NaN        S  
213  30.0      0      0              250646   13.0000   NaN        S  
214   NaN      1      0              367229    7.7500   NaN        Q  
215  31.0      1      0               35273  113.2750   D36        C  
216  27.0      0      0    STON/O2. 3101283    7.9250   NaN        S  
217  42.0      1      0              243847   27.0000   NaN        S  
218  32.0      0      0               11813   76.2917   D15        C  
219  30.0      0      0           W/C 14208   10.5000   NaN        S  
     PassengerId  Survived  Pclass                             Name     Sex  \
220          221         1       3   Sunderland, Mr. Victor Francis    male   
221          222         0       2             Bracken, Mr. James H    male   
222          223         0       3          Green, Mr. George Henry    male   
223          224         0       3             Nenkoff, Mr. Christo    male   
224          225         1       1     Hoyt, Mr. Frederick Maxfield    male   
225          226         0       3     Berglund, Mr. Karl Ivar Sven    male   
226          227         1       2        Mellors, Mr. William John    male   
227          228         0       3  Lovell, Mr. John Hall ("Henry")    male   
228          229         0       2        Fahlstrom, Mr. Arne Jonas    male   
229          230         0       3          Lefebre, Miss. Mathilde  female   

      Age  SibSp  Parch           Ticket     Fare Cabin Embarked  
220  16.0      0      0  SOTON/OQ 392089   8.0500   NaN        S  
221  27.0      0      0           220367  13.0000   NaN        S  
222  51.0      0      0            21440   8.0500   NaN        S  
223   NaN      0      0           349234   7.8958   NaN        S  
224  38.0      1      0            19943  90.0000   C93        S  
225  22.0      0      0          PP 4348   9.3500   NaN        S  
226  19.0      0      0        SW/PP 751  10.5000   NaN        S  
227  20.5      0      0        A/5 21173   7.2500   NaN        S  
228  18.0      0
最低0.47元/天 解锁文章
是huahua呀
关注
  • 1
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
http://www.grottoplumbing.com/cheapjerseys.php
csdn8989的博客
07-05 6993
See the red soles are christian louboutin , no need to replica louboutin find logowelcome to walking than stiletto...
20130901可注册域名列表
热门推荐
落寞红尘
09-02 13万+
aeppv.com affjv.com afiun.com agthh.com ahmsp.com aixhr.com ajvcd.com aLoae.com ambLu.com anabL.com andwu.com anszL.com aoehq.com aoLdo.com apcnn.com aphcr.com apkoi.com aprty.com ar
ZLAN_ACC 安装代码
盈于心胸，充塞天地
04-30 11万+
ZLAN_ACC程序管理工具 使用说明 https://blog.csdn.net/cylcylcylcylwo/article/details/80146608 下面是安装代码，SE38创建程序 ZLAN_ACC，全选清空代码，复制粘贴进去，注意程序名一定是ZLAN_ACC DEFINE RKXIBJP18N. &amp;16HX2J4FYH &amp;1. END-OF-DEF...
redis
qwertbjjj的博客
08-26 9810
文章目录redis通用命令五种基本类型stringlistsethashzset三种特殊类型GeospatialHyperloglogBitmapredis事务redis实现乐观锁Jedisspringboot整合Redis配置文件详解持久化RDB优缺点持久化AOF数据恢复重写优点缺点对比redis发布与订阅命令原理redis主从复制概念作用环境配置使用规则哨兵模式概述那么哨兵宕机了怎么办？缓存穿透与雪崩概念解决方案 redis 通用命令 命令 描述 type name 查看key的数据类型
Killers in Kaggle Competition
u010197508的博客
09-22 1万+
Killers in Kaggle Competition1. XGBoost Modelimport pandas as pd''' 对比随机决策森林以及XGBoost模型对泰坦尼克号上的乘客是否生还的预测能力 ''' ''' *************************************************************** **********************
DataWhale-学术前沿趋势分析-Task1 论文数据统计.ipynb
01-17
DataWhale-学术前沿趋势分析-Task1 论文数据统计源码
SemEval-2016 Task 5中文部分数据集
11-30
总的来说，SemEval-2016 Task 5的中文部分数据集为我们提供了一个宝贵的资源，用于训练和测试细粒度情感分析模型。通过对XML数据的预处理和深度学习等技术的应用，我们可以进一步提升中文文本情感分析的性能，服务于...
DataWhale数据挖掘学习–Task 2 数据分析
12-21
EDA数据分析2.1 数据加载2.2 查看数据概况2.3 检测缺失值、异常值、重复值2.3.1 缺失值判断2.3.2 缺失值可视化missingno矩阵查看缺失值missingno条形图查看缺失值2.3.3异常值检测倾斜值检测2.4 查看预测值分布查看...
Python-Scrapy：热销手机爬虫数据分析
06-27
热销手机——Python爬虫数据分析 [环境] 视窗 蟒蛇3.8 [scrapy-spider] scrapy项目1：taobaoSpider scrapy项目2：jdSpider [数据资源] 来源：csv文件存储 [数据分析] 任务*.py [样本] 效果展示：task*.png
task02-数据分析.md
03-25
天池比赛——二手车价格预测数据分析文档 熟悉数据 查看缺失值情况 分析数据类型及分布 分析数据间相关性
Lilyheart
03-31
嗨，我是莉莉 :waving_hand: :woman::laptop: 关于我 :telescope: 我目前正在使用AIECode （工作名称） 一个使用Agile框架管理存储在GitLab（最终是GitHub）中的软件开发项目的网站，重点关注中级和高等教育的学生和教育者 :seedling: 我目前在佐治亚理工学院学习： :grinning_face_with_smiling_eyes: 代词：她/她 :bar_chart: 统计数据 附加统计 :cat_face: 我的Github数据 :trophy: 2021年有254项贡献 :package: 179.3 kB用于Github的存储 :briefcase: 选择雇用 :scroll: 16个公共存储库 :key: 14个私有存储库 我很早 :baby_chick: :sun_with_face: Morning 58 commits ████░░░░░░░░░░░░░░░░░░░░░ 17.01% :cityscape_at_dusk: Daytime 151 comm
mysql查询某条记录位于第几行
zc5660020的博客
06-26 1万+
select * from ( SELECT a.service_id,(@rowno:=@rowno+1) as rowno FROM mytable a,(select (@rowno:=0)) b ORDER BY a.service_id asc) t where t.service_id=‘22222’
【无标题】
weixin_42786150的博客
02-17 1万+
ar privacy2
signature=1a4f4cc2a4cb36682d90c0d4c84ca5da,dweb-mirror/yarn.lock at master · internetarchive/dweb-mi...
weixin_34615710的博客
05-29 10万+
# THIS IS AN AUTOGENERATED FILE. DO NOT EDIT THIS FILE DIRECTLY.# yarn lockfile v1"@babel/code-frame@^7.0.0", "@babel/code-frame@^7.8.3":version "7.8.3"resolved "https://registry.yarnpkg.com/@babel/co...
c#中使用Task
故里2130
04-15 1万+
Task.Factory.StartNew比Task.Run有更多的参数选择项，偶尔也需要根据实际场景选择Task.Factory.StartNew，但是Task.Run的用法比较简介，已经可以满足大多数的场景。1.界面业务说明，label1是加法计算，分别有3个功能，对label1停止加法，暂停加法，继续加法。可以先看前面的backgroudwork文章，再看Thread文章，本demo接着Thread的环境继续。在Task中进行停止，暂停，继续的功能。并且在Task中进行停止，暂停，继续的功能。
http://xing8s8.com/index.php,robot framework
weixin_39724382的博客
03-23 8683
折腾了半天，记录一下网上有相当多的资料以后自己慢慢看，先记一下简单的。必须要安装的。因为之前看了一下java testNG框架感觉要做的完美相对这个来说比较繁琐，所以选择rf的python这样有助于自己专注于某个方面就好了，没必要啥都会。序号安装包名安装方法下载地址备注2setuptools下载ez_setup.py文件，双击Python 的套件管理程式3pip1、cmd进入ez_setup.py...
Hottest 30 of codeforce
橘嘉禾
06-05 699
1. 4A.Watermelon 题目链接：https // s.com/problemset/problem/4/A 题意：两人分瓜，但每一部分都得是偶数 分析：直接 对2取余，且 w != 2 #include<bits/stdc++.h> using namespace std; int main() { int n; cin >> n...
女性英文名對照及涵意大全
EdgarHowe的专栏
10-16 4万+
   Abigail 艾比蓋   -   父親很高興Ada 艾達   -   快樂的   美麗　Adela 愛得拉   -   尊貴的   優雅的　Adelaide 愛得萊德   -   高貴的   高貴階級的　Afra 阿芙拉   -   塵土　Agatha 愛葛莎   -   善良而美好的　Agnes 愛葛妮絲   -   純潔   高雅   貞節　Alberta 愛爾柏塔   -
Datawhale从零开始数据挖掘第二次打卡
12-21
Task2数据分析 参考资料 数据处理之二——数据探索性分析（EDA） 数据科学学习手札62 数据探索性分析（EDA） EDA (Exploratory Data Analysis)，也就是对数据进行探索性的分析，从而为之后的数据预处理和特征工程提供必要的结论。 拿到数据之后，我们必须要明确以下几件事： 数据是如何产生的，又是如何储存的 数据是原始数据，还是经过人工处理的 数据有哪些业务背景组成的，数据字段有什么含义 数据字段是什么类型的，每个字段的分布是怎样的 训练集的数据和测试集的数据分布是否有差异 再发分析数据的过程中，还要弄清楚以下问题： 数据量是否充分，是否有外部数据可以进行补充 数

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值