library(ISLR)
## Warning: package 'ISLR' was built under R version 4.0.3
library(tidyverse)
## -- Attaching packages ----------------- tidyverse 1.3.0 --
## v ggplot2 3.3.2     v purrr   0.3.4
## v tibble  3.0.3     v dplyr   1.0.2
## v tidyr   1.1.1     v stringr 1.4.0
## v readr   1.3.1     v forcats 0.5.0
## -- Conflicts -------------------- tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag()    masks stats::lag()
library(stringr)
shipdata = read.csv("C:\\Users\\jadri\\Documents\\school\\r stuff\\Space_Corrected.csv", header = TRUE)

shipdata_clean<-  shipdata[!(is.na(shipdata$Rocket) | shipdata$Rocket==""), ] %>% 
  mutate( time = as.POSIXct(Datum, format = '%a %b %d, %Y %H:%M UTC', tz="UTC"),Rocket_int=as.numeric(gsub(",", "", Rocket, fixed = TRUE))) %>% filter(Rocket_int <2000)
head(shipdata_clean)
##   X Unnamed..0 Company.Name
## 1 0          0       SpaceX
## 2 1          1         CASC
## 3 3          3    Roscosmos
## 4 4          4          ULA
## 5 5          5         CASC
## 6 6          6    Roscosmos
##                                                    Location
## 1                LC-39A, Kennedy Space Center, Florida, USA
## 2 Site 9401 (SLS-2), Jiuquan Satellite Launch Center, China
## 3              Site 200/39, Baikonur Cosmodrome, Kazakhstan
## 4                  SLC-41, Cape Canaveral AFS, Florida, USA
## 5              LC-9, Taiyuan Satellite Launch Center, China
## 6                Site 31/6, Baikonur Cosmodrome, Kazakhstan
##                        Datum
## 1 Fri Aug 07, 2020 05:12 UTC
## 2 Thu Aug 06, 2020 04:01 UTC
## 3 Thu Jul 30, 2020 21:25 UTC
## 4 Thu Jul 30, 2020 11:50 UTC
## 5 Sat Jul 25, 2020 03:13 UTC
## 6 Thu Jul 23, 2020 14:26 UTC
##                                                   Detail Status.Rocket Rocket
## 1           Falcon 9 Block 5 | Starlink V1 L9 & BlackSky  StatusActive  50.0 
## 2                    Long March 2D | Gaofen-9 04 & Q-SAT  StatusActive 29.75 
## 3           Proton-M/Briz-M | Ekspress-80 & Ekspress-103  StatusActive  65.0 
## 4                             Atlas V 541 | Perseverance  StatusActive 145.0 
## 5 Long March 4B | Ziyuan-3 03, Apocalypse-10 & NJU-HKU 1  StatusActive 64.68 
## 6                            Soyuz 2.1a | Progress MS-15  StatusActive  48.5 
##   Status.Mission                time Rocket_int
## 1        Success 2020-08-07 05:12:00      50.00
## 2        Success 2020-08-06 04:01:00      29.75
## 3        Success 2020-07-30 21:25:00      65.00
## 4        Success 2020-07-30 11:50:00     145.00
## 5        Success 2020-07-25 03:13:00      64.68
## 6        Success 2020-07-23 14:26:00      48.50
ggplot(data = shipdata_clean, aes(x = time,color=Company.Name,y=Rocket_int)) +
  geom_point()
## Warning: Removed 6 rows containing missing values (geom_point).

ggplot(data = shipdata_clean, aes(x = time,fill=Company.Name)) +
  geom_histogram(bins = 30)
## Warning: Removed 6 rows containing non-finite values (stat_bin).

ggplot(shipdata_clean, aes(y=Rocket_int, x=Status.Mission))+
  geom_boxplot()

head(shipdata_clean)
##   X Unnamed..0 Company.Name
## 1 0          0       SpaceX
## 2 1          1         CASC
## 3 3          3    Roscosmos
## 4 4          4          ULA
## 5 5          5         CASC
## 6 6          6    Roscosmos
##                                                    Location
## 1                LC-39A, Kennedy Space Center, Florida, USA
## 2 Site 9401 (SLS-2), Jiuquan Satellite Launch Center, China
## 3              Site 200/39, Baikonur Cosmodrome, Kazakhstan
## 4                  SLC-41, Cape Canaveral AFS, Florida, USA
## 5              LC-9, Taiyuan Satellite Launch Center, China
## 6                Site 31/6, Baikonur Cosmodrome, Kazakhstan
##                        Datum
## 1 Fri Aug 07, 2020 05:12 UTC
## 2 Thu Aug 06, 2020 04:01 UTC
## 3 Thu Jul 30, 2020 21:25 UTC
## 4 Thu Jul 30, 2020 11:50 UTC
## 5 Sat Jul 25, 2020 03:13 UTC
## 6 Thu Jul 23, 2020 14:26 UTC
##                                                   Detail Status.Rocket Rocket
## 1           Falcon 9 Block 5 | Starlink V1 L9 & BlackSky  StatusActive  50.0 
## 2                    Long March 2D | Gaofen-9 04 & Q-SAT  StatusActive 29.75 
## 3           Proton-M/Briz-M | Ekspress-80 & Ekspress-103  StatusActive  65.0 
## 4                             Atlas V 541 | Perseverance  StatusActive 145.0 
## 5 Long March 4B | Ziyuan-3 03, Apocalypse-10 & NJU-HKU 1  StatusActive 64.68 
## 6                            Soyuz 2.1a | Progress MS-15  StatusActive  48.5 
##   Status.Mission                time Rocket_int
## 1        Success 2020-08-07 05:12:00      50.00
## 2        Success 2020-08-06 04:01:00      29.75
## 3        Success 2020-07-30 21:25:00      65.00
## 4        Success 2020-07-30 11:50:00     145.00
## 5        Success 2020-07-25 03:13:00      64.68
## 6        Success 2020-07-23 14:26:00      48.50
shipdata_clean$Rocket
##   [1] "50.0 "    "29.75 "   "65.0 "    "145.0 "   "64.68 "   "48.5 "   
##   [7] "50.0 "    "90.0 "    "46.0 "    "28.3 "    "29.15 "   "29.75 "  
##  [13] "7.5 "     "64.68 "   "50.0 "    "29.15 "   "29.75 "   "50.0 "   
##  [19] "7.5 "     "30.8 "    "50.0 "    "29.75 "   "50.0 "    "5.3 "    
##  [25] "12.0 "    "112.5 "   "120.0 "   "48.5 "    "50.0 "    "29.15 "  
##  [31] "48.5 "    "153.0 "   "30.8 "    "48.5 "    "50.0 "    "29.15 "  
##  [37] "50.0 "    "48.5 "    "29.75 "   "200.0 "   "50.0 "    "85.0 "   
##  [43] "115.0 "   "90.0 "    "48.5 "    "7.5 "     "50.0 "    "50.0 "   
##  [49] "200.0 "   "29.75 "   "29.15 "   "50.0 "    "41.8 "    "65.0 "   
##  [55] "64.68 "   "50.0 "    "21.0 "    "48.5 "    "48.5 "    "7.5 "    
##  [61] "50.0 "    "64.68 "   "31.0 "    "200.0 "   "50.0 "    "29.15 "  
##  [67] "64.68 "   "85.0 "    "29.15 "   "7.5 "     "40.0 "    "65.0 "   
##  [73] "64.68 "   "48.5 "    "29.75 "   "112.5 "   "5.3 "     "64.68 "  
##  [79] "41.8 "    "164.0 "   "48.5 "    "7.5 "     "29.15 "   "7.5 "    
##  [85] "153.0 "   "50.0 "    "200.0 "   "65.0 "    "48.5 "    "48.5 "   
##  [91] "30.8 "    "50.0 "    "62.0 "    "65.0 "    "37.0 "    "7.5 "    
##  [97] "90.0 "    "29.15 "   "200.0 "   "50.0 "    "5.3 "     "65.0 "   
## [103] "50.0 "    "64.68 "   "21.0 "    "7.5 "     "50.0 "    "64.68 "  
## [109] "29.15 "   "85.0 "    "90.0 "    "48.5 "    "21.0 "    "29.15 "  
## [115] "7.5 "     "37.0 "    "29.15 "   "50.0 "    "50.0 "    "200.0 "  
## [121] "5.3 "     "350.0 "   "39.0 "    "50.0 "    "29.15 "   "48.5 "   
## [127] "50.0 "    "5.3 "     "65.0 "    "47.0 "    "7.5 "     "29.15 "  
## [133] "29.75 "   "50.0 "    "200.0 "   "50.0 "    "41.8 "    "21.0 "   
## [139] "37.0 "    "29.75 "   "85.0 "    "50.0 "    "62.0 "    "7.5 "    
## [145] "48.5 "    "29.15 "   "90.0 "    "30.8 "    "35.0 "    "64.68 "  
## [151] "200.0 "   "153.0 "   "30.8 "    "50.0 "    "200.0 "   "112.5 "  
## [157] "21.0 "    "50.0 "    "30.8 "    "37.0 "    "350.0 "   "50.0 "   
## [163] "64.68 "   "50.0 "    "50.0 "    "48.5 "    "69.7 "    "30.8 "   
## [169] "62.0 "    "30.8 "    "90.0 "    "69.7 "    "62.0 "    "29.75 "  
## [175] "62.0 "    "85.0 "    "64.68 "   "50.0 "    "64.68 "   "109.0 "  
## [181] "29.15 "   "5.3 "     "41.8 "    "62.0 "    "65.0 "    "153.0 "  
## [187] "31.0 "    "64.68 "   "200.0 "   "62.0 "    "64.68 "   "62.0 "   
## [193] "47.0 "    "29.75 "   "62.0 "    "145.0 "   "90.0 "    "62.0 "   
## [199] "48.5 "    "90.0 "    "29.75 "   "48.5 "    "62.0 "    "200.0 "  
## [205] "30.8 "    "7.5 "     "115.0 "   "5.3 "     "39.0 "    "29.75 "  
## [211] "31.0 "    "29.75 "   "62.0 "    "30.8 "    "29.75 "   "62.0 "   
## [217] "90.0 "    "62.0 "    "29.15 "   "29.75 "   "35.0 "    "30.8 "   
## [223] "64.68 "   "85.0 "    "37.0 "    "45.0 "    "62.0 "    "123.0 "  
## [229] "48.5 "    "41.8 "    "62.0 "    "90.0 "    "62.0 "    "29.75 "  
## [235] "200.0 "   "30.8 "    "65.0 "    "145.0 "   "65.0 "    "62.0 "   
## [241] "31.0 "    "46.0 "    "62.0 "    "109.0 "   "65.0 "    "62.0 "   
## [247] "37.0 "    "48.5 "    "62.0 "    "200.0 "   "62.0 "    "62.0 "   
## [253] "31.0 "    "29.15 "   "64.68 "   "48.5 "    "65.0 "    "62.0 "   
## [259] "62.0 "    "200.0 "   "90.0 "    "7.5 "     "62.0 "    "47.0 "   
## [265] "200.0 "   "62.0 "    "109.0 "   "29.15 "   "62.0 "    "90.0 "   
## [271] "62.0 "    "37.0 "    "109.0 "   "62.0 "    "31.0 "    "200.0 "  
## [277] "109.0 "   "62.0 "    "29.15 "   "29.75 "   "200.0 "   "29.75 "  
## [283] "130.0 "   "40.0 "    "29.15 "   "112.5 "   "31.0 "    "37.0 "   
## [289] "145.0 "   "29.75 "   "109.0 "   "5.3 "     "90.0 "    "85.0 "   
## [295] "200.0 "   "25.0 "    "37.0 "    "115.0 "   "47.0 "    "62.0 "   
## [301] "64.68 "   "200.0 "   "164.0 "   "29.75 "   "62.0 "    "64.68 "  
## [307] "29.15 "   "123.0 "   "62.0 "    "64.68 "   "153.0 "   "31.0 "   
## [313] "200.0 "   "62.0 "    "350.0 "   "65.0 "    "41.8 "    "64.68 "  
## [319] "48.5 "    "62.0 "    "29.75 "   "62.0 "    "31.0 "    "62.0 "   
## [325] "29.75 "   "48.5 "    "69.7 "    "48.5 "    "109.0 "   "65.0 "   
## [331] "35.0 "    "31.0 "    "200.0 "   "62.0 "    "90.0 "    "41.8 "   
## [337] "48.5 "    "109.0 "   "65.0 "    "200.0 "   "31.0 "    "56.5 "   
## [343] "29.15 "   "62.0 "    "21.0 "    "109.0 "   "37.0 "    "200.0 "  
## [349] "15.0 "    "109.0 "   "109.0 "   "123.0 "   "200.0 "   "31.0 "   
## [355] "5.3 "     "41.8 "    "153.0 "   "47.0 "    "200.0 "   "112.5 "  
## [361] "200.0 "   "109.0 "   "31.0 "    "56.5 "    "37.0 "    "200.0 "  
## [367] "120.0 "   "56.5 "    "200.0 "   "56.5 "    "41.8 "    "31.0 "   
## [373] "90.0 "    "29.0 "    "164.0 "   "123.0 "   "56.5 "    "56.5 "   
## [379] "37.0 "    "90.0 "    "153.0 "   "56.5 "    "62.0 "    "145.0 "  
## [385] "200.0 "   "350.0 "   "90.0 "    "29.0 "    "109.0 "   "80.0 "   
## [391] "200.0 "   "31.0 "    "90.0 "    "56.5 "    "109.0 "   "200.0 "  
## [397] "56.5 "    "109.0 "   "56.5 "    "109.0 "   "164.0 "   "56.5 "   
## [403] "80.0 "    "41.8 "    "21.0 "    "29.0 "    "90.0 "    "41.8 "   
## [409] "109.0 "   "164.0 "   "37.0 "    "56.5 "    "145.0 "   "31.0 "   
## [415] "109.0 "   "200.0 "   "90.0 "    "164.0 "   "200.0 "   "109.0 "  
## [421] "80.0 "    "56.5 "    "47.0 "    "41.8 "    "120.0 "   "56.5 "   
## [427] "41.8 "    "29.0 "    "40.0 "    "109.0 "   "31.0 "    "56.5 "   
## [433] "140.0 "   "80.0 "    "41.8 "    "55.0 "    "200.0 "   "350.0 "  
## [439] "29.0 "    "112.5 "   "200.0 "   "153.0 "   "65.0 "    "31.0 "   
## [445] "40.0 "    "109.0 "   "37.0 "    "80.0 "    "109.0 "   "59.5 "   
## [451] "21.0 "    "109.0 "   "200.0 "   "109.0 "   "90.0 "    "41.8 "   
## [457] "200.0 "   "120.0 "   "80.0 "    "200.0 "   "59.5 "    "164.0 "  
## [463] "200.0 "   "109.0 "   "21.0 "    "109.0 "   "200.0 "   "41.8 "   
## [469] "112.5 "   "200.0 "   "350.0 "   "109.0 "   "40.0 "    "59.5 "   
## [475] "90.0 "    "200.0 "   "140.0 "   "31.0 "    "31.0 "    "153.0 "  
## [481] "37.0 "    "80.0 "    "90.0 "    "145.0 "   "21.0 "    "46.0 "   
## [487] "90.0 "    "200.0 "   "90.0 "    "29.0 "    "200.0 "   "153.0 "  
## [493] "164.0 "   "31.0 "    "450.0 "   "40.0 "    "200.0 "   "450.0 "  
## [499] "109.0 "   "200.0 "   "25.0 "    "115.0 "   "164.0 "   "120.0 "  
## [505] "45.0 "    "450.0 "   "40.0 "    "41.8 "    "112.5 "   "350.0 "  
## [511] "200.0 "   "47.0 "    "59.5 "    "200.0 "   "350.0 "   "46.0 "   
## [517] "200.0 "   "46.0 "    "120.0 "   "41.8 "    "140.0 "   "200.0 "  
## [523] "21.0 "    "200.0 "   "29.0 "    "29.0 "    "59.5 "    "41.8 "   
## [529] "164.0 "   "200.0 "   "450.0 "   "90.0 "    "120.0 "   "47.0 "   
## [535] "29.0 "    "450.0 "   "164.0 "   "109.0 "   "450.0 "   "90.0 "   
## [541] "130.0 "   "450.0 "   "41.8 "    "200.0 "   "450.0 "   "109.0 "  
## [547] "200.0 "   "21.0 "    "112.5 "   "109.0 "   "450.0 "   "200.0 "  
## [553] "29.0 "    "450.0 "   "7.0 "     "41.8 "    "200.0 "   "164.0 "  
## [559] "123.0 "   "40.0 "    "200.0 "   "450.0 "   "21.0 "    "123.0 "  
## [565] "41.8 "    "450.0 "   "45.0 "    "200.0 "   "90.0 "    "350.0 "  
## [571] "200.0 "   "450.0 "   "29.75 "   "29.75 "   "29.15 "   "64.68 "  
## [577] "31.0 "    "40.0 "    "29.0 "    "7.0 "     "29.0 "    "200.0 "  
## [583] "7.0 "     "200.0 "   "200.0 "   "450.0 "   "64.68 "   "41.8 "   
## [589] "21.0 "    "20.14 "   "200.0 "   "40.0 "    "123.0 "   "115.0 "  
## [595] "450.0 "   "90.0 "    "450.0 "   "21.0 "    "109.0 "   "200.0 "  
## [601] "64.68 "   "350.0 "   "450.0 "   "123.0 "   "64.68 "   "47.0 "   
## [607] "200.0 "   "450.0 "   "29.0 "    "109.0 "   "29.0 "    "450.0 "  
## [613] "69.7 "    "29.75 "   "29.15 "   "200.0 "   "40.0 "    "40.0 "   
## [619] "21.0 "    "29.0 "    "69.7 "    "30.8 "    "7.0 "     "200.0 "  
## [625] "109.0 "   "69.7 "    "25.0 "    "40.0 "    "450.0 "   "200.0 "  
## [631] "69.7 "    "133.0 "   "64.68 "   "200.0 "   "69.7 "    "90.0 "   
## [637] "450.0 "   "30.8 "    "200.0 "   "41.8 "    "29.0 "    "29.0 "   
## [643] "47.0 "    "450.0 "   "164.0 "   "200.0 "   "164.0 "   "64.68 "  
## [649] "115.0 "   "40.0 "    "40.0 "    "7.0 "     "200.0 "   "153.0 "  
## [655] "200.0 "   "41.8 "    "40.0 "    "29.75 "   "41.8 "    "29.0 "   
## [661] "109.0 "   "30.8 "    "450.0 "   "29.75 "   "25.0 "    "40.0 "   
## [667] "40.0 "    "130.0 "   "200.0 "   "350.0 "   "190.0 "   "135.0 "  
## [673] "30.8 "    "48.5 "    "64.68 "   "69.7 "    "29.75 "   "47.0 "   
## [679] "64.68 "   "30.8 "    "30.8 "    "190.0 "   "29.0 "    "45.0 "   
## [685] "30.8 "    "190.0 "   "30.8 "    "69.7 "    "29.75 "   "41.8 "   
## [691] "64.68 "   "35.0 "    "25.0 "    "133.0 "   "40.0 "    "135.0 "  
## [697] "41.8 "    "40.0 "    "69.7 "    "109.0 "   "47.0 "    "40.0 "   
## [703] "133.0 "   "40.0 "    "450.0 "   "35.0 "    "29.0 "    "90.0 "   
## [709] "200.0 "   "450.0 "   "164.0 "   "64.68 "   "450.0 "   "25.0 "   
## [715] "109.0 "   "35.0 "    "41.8 "    "450.0 "   "64.68 "   "450.0 "  
## [721] "41.8 "    "450.0 "   "40.0 "    "450.0 "   "25.0 "    "45.0 "   
## [727] "90.0 "    "450.0 "   "450.0 "   "450.0 "   "47.0 "    "450.0 "  
## [733] "450.0 "   "69.7 "    "450.0 "   "69.7 "    "450.0 "   "40.0 "   
## [739] "29.0 "    "35.0 "    "450.0 "   "40.0 "    "40.0 "    "450.0 "  
## [745] "41.8 "    "45.0 "    "450.0 "   "40.0 "    "69.7 "    "45.0 "   
## [751] "450.0 "   "35.0 "    "40.0 "    "64.68 "   "450.0 "   "35.0 "   
## [757] "30.8 "    "25.0 "    "450.0 "   "40.0 "    "64.68 "   "29.0 "   
## [763] "40.0 "    "30.8 "    "40.0 "    "450.0 "   "450.0 "   "40.0 "   
## [769] "45.0 "    "40.0 "    "30.8 "    "40.0 "    "450.0 "   "35.0 "   
## [775] "30.8 "    "450.0 "   "40.0 "    "30.8 "    "40.0 "    "45.0 "   
## [781] "450.0 "   "40.0 "    "30.8 "    "450.0 "   "40.0 "    "25.0 "   
## [787] "450.0 "   "30.8 "    "40.0 "    "450.0 "   "40.0 "    "450.0 "  
## [793] "450.0 "   "69.7 "    "40.0 "    "450.0 "   "35.0 "    "450.0 "  
## [799] "450.0 "   "450.0 "   "40.0 "    "29.75 "   "450.0 "   "40.0 "   
## [805] "40.0 "    "450.0 "   "450.0 "   "40.0 "    "450.0 "   "25.0 "   
## [811] "40.0 "    "450.0 "   "450.0 "   "450.0 "   "20.0 "    "450.0 "  
## [817] "450.0 "   "450.0 "   "450.0 "   "40.0 "    "40.0 "    "450.0 "  
## [823] "450.0 "   "69.7 "    "450.0 "   "25.0 "    "450.0 "   "450.0 "  
## [829] "40.0 "    "450.0 "   "29.75 "   "40.0 "    "40.0 "    "450.0 "  
## [835] "45.0 "    "450.0 "   "69.7 "    "450.0 "   "35.0 "    "450.0 "  
## [841] "450.0 "   "30.8 "    "35.0 "    "25.0 "    "450.0 "   "450.0 "  
## [847] "450.0 "   "40.0 "    "450.0 "   "40.0 "    "450.0 "   "450.0 "  
## [853] "450.0 "   "30.8 "    "136.6 "   "450.0 "   "29.75 "   "450.0 "  
## [859] "450.0 "   "450.0 "   "35.0 "    "450.0 "   "450.0 "   "450.0 "  
## [865] "450.0 "   "450.0 "   "40.0 "    "450.0 "   "450.0 "   "450.0 "  
## [871] "450.0 "   "450.0 "   "450.0 "   "30.8 "    "136.6 "   "450.0 "  
## [877] "40.0 "    "136.6 "   "450.0 "   "450.0 "   "136.6 "   "450.0 "  
## [883] "450.0 "   "35.0 "    "450.0 "   "450.0 "   "450.0 "   "450.0 "  
## [889] "450.0 "   "35.0 "    "30.8 "    "30.8 "    "30.8 "    "30.8 "   
## [895] "450.0 "   "450.0 "   "450.0 "   "450.0 "   "30.8 "    "450.0 "  
## [901] "450.0 "   "450.0 "   "450.0 "   "450.0 "   "450.0 "   "450.0 "  
## [907] "450.0 "   "450.0 "   "30.8 "    "450.0 "   "450.0 "   "450.0 "  
## [913] "450.0 "   "450.0 "   "30.8 "    "450.0 "   "450.0 "   "450.0 "  
## [919] "30.8 "    "450.0 "   "450.0 "   "450.0 "   "450.0 "   "1,160.0 "
## [925] "1,160.0 " "1,160.0 " "1,160.0 " "1,160.0 " "1,160.0 " "1,160.0 "
## [931] "1,160.0 " "59.0 "    "1,160.0 " "59.0 "    "59.0 "    "1,160.0 "
## [937] "59.0 "    "1,160.0 " "59.0 "    "59.0 "    "59.0 "    "59.0 "   
## [943] "59.0 "    "59.0 "    "1,160.0 " "59.0 "    "59.0 "    "59.0 "   
## [949] "1,160.0 " "59.0 "    "59.0 "    "59.0 "    "59.0 "    "59.0 "   
## [955] "59.0 "    "59.0 "    "59.0 "    "59.0 "    "63.23 "   "63.23 "  
## [961] "63.23 "   "63.23 "
as.numeric(shipdata_clean$Rocket)
## Warning: NAs introduced by coercion
##   [1]  50.00  29.75  65.00 145.00  64.68  48.50  50.00  90.00  46.00  28.30
##  [11]  29.15  29.75   7.50  64.68  50.00  29.15  29.75  50.00   7.50  30.80
##  [21]  50.00  29.75  50.00   5.30  12.00 112.50 120.00  48.50  50.00  29.15
##  [31]  48.50 153.00  30.80  48.50  50.00  29.15  50.00  48.50  29.75 200.00
##  [41]  50.00  85.00 115.00  90.00  48.50   7.50  50.00  50.00 200.00  29.75
##  [51]  29.15  50.00  41.80  65.00  64.68  50.00  21.00  48.50  48.50   7.50
##  [61]  50.00  64.68  31.00 200.00  50.00  29.15  64.68  85.00  29.15   7.50
##  [71]  40.00  65.00  64.68  48.50  29.75 112.50   5.30  64.68  41.80 164.00
##  [81]  48.50   7.50  29.15   7.50 153.00  50.00 200.00  65.00  48.50  48.50
##  [91]  30.80  50.00  62.00  65.00  37.00   7.50  90.00  29.15 200.00  50.00
## [101]   5.30  65.00  50.00  64.68  21.00   7.50  50.00  64.68  29.15  85.00
## [111]  90.00  48.50  21.00  29.15   7.50  37.00  29.15  50.00  50.00 200.00
## [121]   5.30 350.00  39.00  50.00  29.15  48.50  50.00   5.30  65.00  47.00
## [131]   7.50  29.15  29.75  50.00 200.00  50.00  41.80  21.00  37.00  29.75
## [141]  85.00  50.00  62.00   7.50  48.50  29.15  90.00  30.80  35.00  64.68
## [151] 200.00 153.00  30.80  50.00 200.00 112.50  21.00  50.00  30.80  37.00
## [161] 350.00  50.00  64.68  50.00  50.00  48.50  69.70  30.80  62.00  30.80
## [171]  90.00  69.70  62.00  29.75  62.00  85.00  64.68  50.00  64.68 109.00
## [181]  29.15   5.30  41.80  62.00  65.00 153.00  31.00  64.68 200.00  62.00
## [191]  64.68  62.00  47.00  29.75  62.00 145.00  90.00  62.00  48.50  90.00
## [201]  29.75  48.50  62.00 200.00  30.80   7.50 115.00   5.30  39.00  29.75
## [211]  31.00  29.75  62.00  30.80  29.75  62.00  90.00  62.00  29.15  29.75
## [221]  35.00  30.80  64.68  85.00  37.00  45.00  62.00 123.00  48.50  41.80
## [231]  62.00  90.00  62.00  29.75 200.00  30.80  65.00 145.00  65.00  62.00
## [241]  31.00  46.00  62.00 109.00  65.00  62.00  37.00  48.50  62.00 200.00
## [251]  62.00  62.00  31.00  29.15  64.68  48.50  65.00  62.00  62.00 200.00
## [261]  90.00   7.50  62.00  47.00 200.00  62.00 109.00  29.15  62.00  90.00
## [271]  62.00  37.00 109.00  62.00  31.00 200.00 109.00  62.00  29.15  29.75
## [281] 200.00  29.75 130.00  40.00  29.15 112.50  31.00  37.00 145.00  29.75
## [291] 109.00   5.30  90.00  85.00 200.00  25.00  37.00 115.00  47.00  62.00
## [301]  64.68 200.00 164.00  29.75  62.00  64.68  29.15 123.00  62.00  64.68
## [311] 153.00  31.00 200.00  62.00 350.00  65.00  41.80  64.68  48.50  62.00
## [321]  29.75  62.00  31.00  62.00  29.75  48.50  69.70  48.50 109.00  65.00
## [331]  35.00  31.00 200.00  62.00  90.00  41.80  48.50 109.00  65.00 200.00
## [341]  31.00  56.50  29.15  62.00  21.00 109.00  37.00 200.00  15.00 109.00
## [351] 109.00 123.00 200.00  31.00   5.30  41.80 153.00  47.00 200.00 112.50
## [361] 200.00 109.00  31.00  56.50  37.00 200.00 120.00  56.50 200.00  56.50
## [371]  41.80  31.00  90.00  29.00 164.00 123.00  56.50  56.50  37.00  90.00
## [381] 153.00  56.50  62.00 145.00 200.00 350.00  90.00  29.00 109.00  80.00
## [391] 200.00  31.00  90.00  56.50 109.00 200.00  56.50 109.00  56.50 109.00
## [401] 164.00  56.50  80.00  41.80  21.00  29.00  90.00  41.80 109.00 164.00
## [411]  37.00  56.50 145.00  31.00 109.00 200.00  90.00 164.00 200.00 109.00
## [421]  80.00  56.50  47.00  41.80 120.00  56.50  41.80  29.00  40.00 109.00
## [431]  31.00  56.50 140.00  80.00  41.80  55.00 200.00 350.00  29.00 112.50
## [441] 200.00 153.00  65.00  31.00  40.00 109.00  37.00  80.00 109.00  59.50
## [451]  21.00 109.00 200.00 109.00  90.00  41.80 200.00 120.00  80.00 200.00
## [461]  59.50 164.00 200.00 109.00  21.00 109.00 200.00  41.80 112.50 200.00
## [471] 350.00 109.00  40.00  59.50  90.00 200.00 140.00  31.00  31.00 153.00
## [481]  37.00  80.00  90.00 145.00  21.00  46.00  90.00 200.00  90.00  29.00
## [491] 200.00 153.00 164.00  31.00 450.00  40.00 200.00 450.00 109.00 200.00
## [501]  25.00 115.00 164.00 120.00  45.00 450.00  40.00  41.80 112.50 350.00
## [511] 200.00  47.00  59.50 200.00 350.00  46.00 200.00  46.00 120.00  41.80
## [521] 140.00 200.00  21.00 200.00  29.00  29.00  59.50  41.80 164.00 200.00
## [531] 450.00  90.00 120.00  47.00  29.00 450.00 164.00 109.00 450.00  90.00
## [541] 130.00 450.00  41.80 200.00 450.00 109.00 200.00  21.00 112.50 109.00
## [551] 450.00 200.00  29.00 450.00   7.00  41.80 200.00 164.00 123.00  40.00
## [561] 200.00 450.00  21.00 123.00  41.80 450.00  45.00 200.00  90.00 350.00
## [571] 200.00 450.00  29.75  29.75  29.15  64.68  31.00  40.00  29.00   7.00
## [581]  29.00 200.00   7.00 200.00 200.00 450.00  64.68  41.80  21.00  20.14
## [591] 200.00  40.00 123.00 115.00 450.00  90.00 450.00  21.00 109.00 200.00
## [601]  64.68 350.00 450.00 123.00  64.68  47.00 200.00 450.00  29.00 109.00
## [611]  29.00 450.00  69.70  29.75  29.15 200.00  40.00  40.00  21.00  29.00
## [621]  69.70  30.80   7.00 200.00 109.00  69.70  25.00  40.00 450.00 200.00
## [631]  69.70 133.00  64.68 200.00  69.70  90.00 450.00  30.80 200.00  41.80
## [641]  29.00  29.00  47.00 450.00 164.00 200.00 164.00  64.68 115.00  40.00
## [651]  40.00   7.00 200.00 153.00 200.00  41.80  40.00  29.75  41.80  29.00
## [661] 109.00  30.80 450.00  29.75  25.00  40.00  40.00 130.00 200.00 350.00
## [671] 190.00 135.00  30.80  48.50  64.68  69.70  29.75  47.00  64.68  30.80
## [681]  30.80 190.00  29.00  45.00  30.80 190.00  30.80  69.70  29.75  41.80
## [691]  64.68  35.00  25.00 133.00  40.00 135.00  41.80  40.00  69.70 109.00
## [701]  47.00  40.00 133.00  40.00 450.00  35.00  29.00  90.00 200.00 450.00
## [711] 164.00  64.68 450.00  25.00 109.00  35.00  41.80 450.00  64.68 450.00
## [721]  41.80 450.00  40.00 450.00  25.00  45.00  90.00 450.00 450.00 450.00
## [731]  47.00 450.00 450.00  69.70 450.00  69.70 450.00  40.00  29.00  35.00
## [741] 450.00  40.00  40.00 450.00  41.80  45.00 450.00  40.00  69.70  45.00
## [751] 450.00  35.00  40.00  64.68 450.00  35.00  30.80  25.00 450.00  40.00
## [761]  64.68  29.00  40.00  30.80  40.00 450.00 450.00  40.00  45.00  40.00
## [771]  30.80  40.00 450.00  35.00  30.80 450.00  40.00  30.80  40.00  45.00
## [781] 450.00  40.00  30.80 450.00  40.00  25.00 450.00  30.80  40.00 450.00
## [791]  40.00 450.00 450.00  69.70  40.00 450.00  35.00 450.00 450.00 450.00
## [801]  40.00  29.75 450.00  40.00  40.00 450.00 450.00  40.00 450.00  25.00
## [811]  40.00 450.00 450.00 450.00  20.00 450.00 450.00 450.00 450.00  40.00
## [821]  40.00 450.00 450.00  69.70 450.00  25.00 450.00 450.00  40.00 450.00
## [831]  29.75  40.00  40.00 450.00  45.00 450.00  69.70 450.00  35.00 450.00
## [841] 450.00  30.80  35.00  25.00 450.00 450.00 450.00  40.00 450.00  40.00
## [851] 450.00 450.00 450.00  30.80 136.60 450.00  29.75 450.00 450.00 450.00
## [861]  35.00 450.00 450.00 450.00 450.00 450.00  40.00 450.00 450.00 450.00
## [871] 450.00 450.00 450.00  30.80 136.60 450.00  40.00 136.60 450.00 450.00
## [881] 136.60 450.00 450.00  35.00 450.00 450.00 450.00 450.00 450.00  35.00
## [891]  30.80  30.80  30.80  30.80 450.00 450.00 450.00 450.00  30.80 450.00
## [901] 450.00 450.00 450.00 450.00 450.00 450.00 450.00 450.00  30.80 450.00
## [911] 450.00 450.00 450.00 450.00  30.80 450.00 450.00 450.00  30.80 450.00
## [921] 450.00 450.00 450.00     NA     NA     NA     NA     NA     NA     NA
## [931]     NA  59.00     NA  59.00  59.00     NA  59.00     NA  59.00  59.00
## [941]  59.00  59.00  59.00  59.00     NA  59.00  59.00  59.00     NA  59.00
## [951]  59.00  59.00  59.00  59.00  59.00  59.00  59.00  59.00  63.23  63.23
## [961]  63.23  63.23
strtoi("5")
## [1] 5
summary(shipdata_clean)
##        X            Unnamed..0     Company.Name         Location        
##  Min.   :   0.0   Min.   :   0.0   Length:962         Length:962        
##  1st Qu.: 324.2   1st Qu.: 324.2   Class :character   Class :character  
##  Median : 658.5   Median : 658.5   Mode  :character   Mode  :character  
##  Mean   : 856.2   Mean   : 856.2                                        
##  3rd Qu.:1104.5   3rd Qu.:1104.5                                        
##  Max.   :4020.0   Max.   :4020.0                                        
##                                                                         
##     Datum              Detail          Status.Rocket         Rocket         
##  Length:962         Length:962         Length:962         Length:962        
##  Class :character   Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character   Mode  :character  
##                                                                             
##                                                                             
##                                                                             
##                                                                             
##  Status.Mission          time                       Rocket_int    
##  Length:962         Min.   :1964-09-01 15:00:00   Min.   :   5.3  
##  Class :character   1st Qu.:2002-03-13 09:51:15   1st Qu.:  40.0  
##  Mode  :character   Median :2012-01-15 06:01:30   Median :  62.0  
##                     Mean   :2008-01-30 09:01:17   Mean   : 143.7  
##                     3rd Qu.:2017-09-08 15:20:45   3rd Qu.: 164.0  
##                     Max.   :2020-08-07 05:12:00   Max.   :1160.0  
##                     NA's   :6