-
Notifications
You must be signed in to change notification settings - Fork 0
/
.Rhistory
89 lines (89 loc) · 3.19 KB
/
.Rhistory
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
gc()
library(dplyr)
library(readr)
library(tidyverse)
library(tidyselect)
getwd()
setwd("/Users/vpare/OneDrive/Documents/case/Case study1")
library(readr)
Q1_2019 <- read_csv("~/case/Divvy_Trips_2019_Q1.csv")
View(Q1_2019)
library(readr)
Q2_2019 <- read_csv("~/case/Divvy_Trips_2019_Q2.csv")
View(Q2_2019)
Q3_2019 <- read_csv("~/case/Divvy_Trips_2019_Q2.csv")
View(Q2_2019)
View(Q3_2019)
View(Q3_2019)
library(tidyverse)
library(lubridate)
library(ggplot2)
library(pillar)
getwd()
setwd("/Users/vpare/OneDrive/Documents/case/Case study1")
library(readr)
Q1_2019 <- read_csv("~/case/Divvy_Trips_2019_Q1.csv")
View(Q1_2019)
library(readr)
Q2_2019 <- read_csv("~/case/Divvy_Trips_2019_Q2.csv")
View(Q2_2019)
library(readr)
Q3_2019 <- read_csv("~/case/Divvy_Trips_2019_Q3.csv")
View(Q3_2019)
library(readr)
Q4_2019 <- read_csv("~/case/Divvy_Trips_2019_Q4.csv")
View(Q4_2019)
colnames(Q3_2019)
colnames(Q4_2019)
colnames(q2)
colnames(Q2_2019)
colnames(Q1_2019)
library(readr)
Q1_2020 <- read_csv("~/case/Divvy_Trips_2020_Q1.csv")
View(Q1_2020)
(Q4_2019 <- rename(Q4_2019,ride_id = trip_id,rideable_type = bikeid,started_at = start_time,ended_at = end_time,start_station_name = from_station_name,start_station_id = from_station_id,end_station_name = to_station_name,end_station_id = to_station_id,member_casual = usertype))
(Q3_2019 <- rename(Q3_2019,ride_id = trip_id,rideable_type = bikeid,started_at = start_time,ended_at = end_time,start_station_name = from_station_name,start_station_id = from_station_id,end_station_name = to_station_name,end_station_id = to_station_id,member_casual = usertype))
(Q2_2019 <- rename(Q2_2019,ride_id = "01 - Rental Details Rental ID",rideable_type = "01 - Rental Details Bike ID",started_at = "01 - Rental Details Local Start Time",ended_at = "01 - Rental Details Local End Time",start_station_name = "03 - Rental Start Station Name",start_station_id = "03 - Rental Start Station ID",end_station_name = "02 - Rental End Station Name",end_station_id = "02 - Rental End Station ID",member_casual = "User Type"))
str(Q1_2019)
str(Q4_2019)
str(Q3_2019)
str(Q2_2019)
Q4_2019 <- mutate(Q4_2019,ride_id = as.character(ride_id),rideable_type = as.character(rideable_type))
Q3_2019 <- mutate(Q3_2019,ride_id = as.character(ride_id),rideable_type = as.character(rideable_type))
Q2_2019 <- mutate(Q2_2019,ride_id = as.character(ride_id),rideable_type = as.character(rideable_type))
colnames(Q1_2020)
str(Q1_2020)
getwd()
library(dplyr)
library(tidyverse)
library(lubridate)
library(readr)
q1_2020 <- read_csv("~/case/Divvy_Trips_2020_Q1.csv")
View(q1_2020)
library(tidyverse)
library(lubridate)
getwd
getwd()
setwd("C:/Users/vpare/OneDrive/Documents/case/Case study1")
library(readr)
X2019_Q2 <- read_csv("~/case/Divvy_Trips_2019_Q2.csv")
View(X2019_Q2)
library(readr)
X2019_Q3 <- read_csv("~/case/Divvy_Trips_2019_Q3.csv")
View(X2019_Q3)
library(readr)
X2019_Q4 <- read_csv("~/case/Divvy_Trips_2019_Q4.csv")
View(X2019_Q4)
library(readr)
X2020_Q1 <- read_csv("~/case/Divvy_Trips_2020_Q1.csv")
View(X2020_Q1)
colnames(X2019_Q2)
colnames(X2019_Q3)
colnames(X2019_Q4)
colnames(X2020_Q1)
str(X2019_Q2)
str(X2019_Q3)
str(X2019_Q4)
str(X2020_Q1)
X2019_Q4<-mutate(trip_id=as.character(trip_id))
X2019_Q4<-mutate(X2019_Q4, trip_id=as.character(trip_id))