Day 2

Author

Violet

Day 2 (In Class)

df <- train <- read.csv("C:/Users/viole/Downloads/train.csv")
head(df)
  PassengerId Survived Pclass
1           1        0      3
2           2        1      1
3           3        1      3
4           4        1      1
5           5        0      3
6           6        0      3
                                                 Name    Sex Age SibSp Parch
1                             Braund, Mr. Owen Harris   male  22     1     0
2 Cumings, Mrs. John Bradley (Florence Briggs Thayer) female  38     1     0
3                              Heikkinen, Miss. Laina female  26     0     0
4        Futrelle, Mrs. Jacques Heath (Lily May Peel) female  35     1     0
5                            Allen, Mr. William Henry   male  35     0     0
6                                    Moran, Mr. James   male  NA     0     0
            Ticket    Fare Cabin Embarked
1        A/5 21171  7.2500              S
2         PC 17599 71.2833   C85        C
3 STON/O2. 3101282  7.9250              S
4           113803 53.1000  C123        S
5           373450  8.0500              S
6           330877  8.4583              Q
tail(df)
    PassengerId Survived Pclass                                     Name    Sex
886         886        0      3     Rice, Mrs. William (Margaret Norton) female
887         887        0      2                    Montvila, Rev. Juozas   male
888         888        1      1             Graham, Miss. Margaret Edith female
889         889        0      3 Johnston, Miss. Catherine Helen "Carrie" female
890         890        1      1                    Behr, Mr. Karl Howell   male
891         891        0      3                      Dooley, Mr. Patrick   male
    Age SibSp Parch     Ticket   Fare Cabin Embarked
886  39     0     5     382652 29.125              Q
887  27     0     0     211536 13.000              S
888  19     0     0     112053 30.000   B42        S
889  NA     1     2 W./C. 6607 23.450              S
890  26     0     0     111369 30.000  C148        C
891  32     0     0     370376  7.750              Q
df[500:530,]
    PassengerId Survived Pclass
500         500        0      3
501         501        0      3
502         502        0      3
503         503        0      3
504         504        0      3
505         505        1      1
506         506        0      1
507         507        1      2
508         508        1      1
509         509        0      3
510         510        1      3
511         511        1      3
512         512        0      3
513         513        1      1
514         514        1      1
515         515        0      3
516         516        0      1
517         517        1      2
518         518        0      3
519         519        1      2
520         520        0      3
521         521        1      1
522         522        0      3
523         523        0      3
524         524        1      1
525         525        0      3
526         526        0      3
527         527        1      2
528         528        0      1
529         529        0      3
530         530        0      2
                                                    Name    Sex  Age SibSp
500                                   Svensson, Mr. Olof   male 24.0     0
501                                     Calic, Mr. Petar   male 17.0     0
502                                  Canavan, Miss. Mary female 21.0     0
503                       O'Sullivan, Miss. Bridget Mary female   NA     0
504                       Laitinen, Miss. Kristina Sofia female 37.0     0
505                                Maioni, Miss. Roberta female 16.0     0
506           Penasco y Castellana, Mr. Victor de Satode   male 18.0     1
507        Quick, Mrs. Frederick Charles (Jane Richards) female 33.0     0
508        Bradley, Mr. George ("George Arthur Brayton")   male   NA     0
509                             Olsen, Mr. Henry Margido   male 28.0     0
510                                       Lang, Mr. Fang   male 26.0     0
511                             Daly, Mr. Eugene Patrick   male 29.0     0
512                                    Webber, Mr. James   male   NA     0
513                            McGough, Mr. James Robert   male 36.0     0
514       Rothschild, Mrs. Martin (Elizabeth L. Barrett) female 54.0     1
515                                    Coleff, Mr. Satio   male 24.0     0
516                         Walker, Mr. William Anderson   male 47.0     0
517                         Lemore, Mrs. (Amelia Milley) female 34.0     0
518                                    Ryan, Mr. Patrick   male   NA     0
519 Angle, Mrs. William A (Florence "Mary" Agnes Hughes) female 36.0     1
520                                  Pavlovic, Mr. Stefo   male 32.0     0
521                                Perreault, Miss. Anne female 30.0     0
522                                      Vovk, Mr. Janko   male 22.0     0
523                                   Lahoud, Mr. Sarkis   male   NA     0
524      Hippach, Mrs. Louis Albert (Ida Sophia Fischer) female 44.0     0
525                                    Kassem, Mr. Fared   male   NA     0
526                                   Farrell, Mr. James   male 40.5     0
527                                 Ridsdale, Miss. Lucy female 50.0     0
528                                   Farthing, Mr. John   male   NA     0
529                            Salonen, Mr. Johan Werner   male 39.0     0
530                          Hocking, Mr. Richard George   male 23.0     2
    Parch           Ticket     Fare Cabin Embarked
500     0           350035   7.7958              S
501     0           315086   8.6625              S
502     0           364846   7.7500              Q
503     0           330909   7.6292              Q
504     0             4135   9.5875              S
505     0           110152  86.5000   B79        S
506     0         PC 17758 108.9000   C65        C
507     2            26360  26.0000              S
508     0           111427  26.5500              S
509     0           C 4001  22.5250              S
510     0             1601  56.4958              S
511     0           382651   7.7500              Q
512     0 SOTON/OQ 3101316   8.0500              S
513     0         PC 17473  26.2875   E25        S
514     0         PC 17603  59.4000              C
515     0           349209   7.4958              S
516     0            36967  34.0208   D46        S
517     0       C.A. 34260  10.5000   F33        S
518     0           371110  24.1500              Q
519     0           226875  26.0000              S
520     0           349242   7.8958              S
521     0            12749  93.5000   B73        S
522     0           349252   7.8958              S
523     0             2624   7.2250              C
524     1           111361  57.9792   B18        C
525     0             2700   7.2292              C
526     0           367232   7.7500              Q
527     0      W./C. 14258  10.5000              S
528     0         PC 17483 221.7792   C95        S
529     0          3101296   7.9250              S
530     1            29104  11.5000              S
df[490:500, 1:3]
    PassengerId Survived Pclass
490         490        1      3
491         491        0      3
492         492        0      3
493         493        0      1
494         494        0      1
495         495        0      3
496         496        0      3
497         497        1      1
498         498        0      3
499         499        0      1
500         500        0      3
df[490:520, c(1,5)]
    PassengerId    Sex
490         490   male
491         491   male
492         492   male
493         493   male
494         494   male
495         495   male
496         496   male
497         497 female
498         498   male
499         499 female
500         500   male
501         501   male
502         502 female
503         503 female
504         504 female
505         505 female
506         506   male
507         507 female
508         508   male
509         509   male
510         510   male
511         511   male
512         512   male
513         513   male
514         514 female
515         515   male
516         516   male
517         517 female
518         518   male
519         519 female
520         520   male
?str
starting httpd help server ... done
 #install.package(visdat)
library(visdat)
vis_dat(df)

library(stargazer)

Please cite as: 
 Hlavac, Marek (2022). stargazer: Well-Formatted Regression and Summary Statistics Tables.
 R package version 5.2.3. https://CRAN.R-project.org/package=stargazer 
stargazer(df, type = "text")

==============================================
Statistic    N   Mean   St. Dev.  Min    Max  
----------------------------------------------
PassengerId 891 446.000 257.354    1     891  
Survived    891  0.384   0.487     0      1   
Pclass      891  2.309   0.836     1      3   
Age         714 29.699   14.526  0.420 80.000 
SibSp       891  0.523   1.103     0      8   
Parch       891  0.382   0.806     0      6   
Fare        891 32.204   49.693  0.000 512.329
----------------------------------------------
library(psych)
describe(df)
            vars   n   mean     sd median trimmed    mad  min    max  range
PassengerId    1 891 446.00 257.35 446.00  446.00 330.62 1.00 891.00 890.00
Survived       2 891   0.38   0.49   0.00    0.35   0.00 0.00   1.00   1.00
Pclass         3 891   2.31   0.84   3.00    2.39   0.00 1.00   3.00   2.00
Name*          4 891 446.00 257.35 446.00  446.00 330.62 1.00 891.00 890.00
Sex*           5 891   1.65   0.48   2.00    1.68   0.00 1.00   2.00   1.00
Age            6 714  29.70  14.53  28.00   29.27  13.34 0.42  80.00  79.58
SibSp          7 891   0.52   1.10   0.00    0.27   0.00 0.00   8.00   8.00
Parch          8 891   0.38   0.81   0.00    0.18   0.00 0.00   6.00   6.00
Ticket*        9 891 339.52 200.83 338.00  339.65 268.35 1.00 681.00 680.00
Fare          10 891  32.20  49.69  14.45   21.38  10.24 0.00 512.33 512.33
Cabin*        11 891  18.63  38.14   1.00    8.29   0.00 1.00 148.00 147.00
Embarked*     12 891   3.53   0.80   4.00    3.66   0.00 1.00   4.00   3.00
             skew kurtosis   se
PassengerId  0.00    -1.20 8.62
Survived     0.48    -1.77 0.02
Pclass      -0.63    -1.28 0.03
Name*        0.00    -1.20 8.62
Sex*        -0.62    -1.62 0.02
Age          0.39     0.16 0.54
SibSp        3.68    17.73 0.04
Parch        2.74     9.69 0.03
Ticket*      0.00    -1.28 6.73
Fare         4.77    33.12 1.66
Cabin*       2.09     3.07 1.28
Embarked*   -1.27    -0.16 0.03