Hello there, I need your help. I was working with different data framed as in the photo attached
which contained 13 variables
I needed to combine all data set and so I used the formula:
#Combine all the data sets
all_year_tripdata <- bind_rows(divvy_tripdata_2022_04, divvy_tripdata_2022_05, divvy_tripdata_2022_06, divvy_tripdata_2022_07, divvy_tripdata_2022_08, divvy_tripdata_2022_09, divvy_tripdata_2022_10, divvy_tripdata_2022_11, divvy_tripdata_2022_12, divvy_tripdata_2023_01, divvy_tripdata_2023_02, divvy_tripdata_2023_03, divvy_tripdata_2023_04)
this created a text file all_year_tripdata but as a text rather than keeping the existing frame of the other datasets, like a csv file , and delimited by a "."
I need to split the text into the columns and frame that I had before I combined all the datasets, and so in:
[1] "ride_id"
[2] "rideable_type"
[3] "started_at"
[4] "ended_at"
[5] "ride_length" (I have added this one with the formula all_year_tripdata$ride_length <- difftime(all_year_tripdata$ended_at,all_year_tripdata$started_at)
[6] "start_station_name"
[7] "start_station_id"
[8] "end_station_name"
[9] "end_station_id"
[10] "start_lat"
[11] "start_lng"
[12] "end_lat"
[13] "end_lng"
[14] "member_casual"
without delimiter "
Can please anyone help me? and could you please tell me what I have done wrong? why when I combined all the dataset, the frame was no kept?
Thanks a lot