[R] Fwd: Merging multiple csv files to new file

Jeff Newmiller jdnewm|| @end|ng |rom dcn@d@v|@@c@@u@
Wed Nov 3 18:22:24 CET 2021


Data type in a CSV is always character until inferred otherwise... it is not necessary nor even easier to manipulate files with Python if you are planning to use R to manipulate the data further with R. Just use the colClasses="character" argument for read.csv.

On November 3, 2021 9:47:03 AM PDT, Robert Knight <bobby.knight using gmail.com> wrote:
>It might be easier to settle on the desired final csv layout and use Python
>to copy the rows via line reads.  Python doesn't care about the data type
>in a given "cell", numeric or char, whereas the type errors R would
>encounter would make the task very difficult.
>
>On Wed, Nov 3, 2021, 10:36 AM gabrielle aban steinberg <
>gabrielleabansteinberg using gmail.com> wrote:
>
>> Hello, I would like to merge 18 csv files into a master data csv file, but
>> each file has a different number of columns (mostly found in one or more of
>> the other cvs files) and different number of rows.
>>
>> I have tried something like the following in R Studio (cloud):
>>
>> all_data_fit_files <- rbind("dailyActivity_merged.csv",
>> "dailyCalories_merged.csv", "dailyIntensities_merged.csv",
>> "dailySteps_merged.csv", "heartrate_seconds_merged.csv",
>> "hourlyCalories_merged.csv", "hourlyIntensities_merged.csv",
>> "hourlySteps_merged.csv", "minuteCaloriesNarrow_merged.csv",
>> "minuteCaloriesWide_merged.csv", "minuteIntensitiesNarrow_merged.csv",
>> "minuteIntensitiesWide_merged.csv", "minuteMETsNarrow_merged.csv",
>> "minuteSleep_merged.csv", "minuteStepsNarrow_merged.csv",
>> “minuteStepsWide_merged.csv", "sleepDay_merged.csv",
>> "minuteStepsWide_merged.csv", "sleepDay_merged.csv",
>> "weightLogInfo_merged.csv")
>>
>>
>>
>> But I am getting the following error:
>>
>> Error: unexpected input in "rlySteps_merged.csv",
>> "minuteCaloriesNarrow_merged.csv", "minuteCaloriesWide_merged.csv",
>> "minuteIntensitiesNarrow_merged.csv",
>> "minuteIntensitiesWide_merged.csv", "minuteMETsNarrow_merged.csv"
>>
>>
>> (Maybe the R Studio free trial/usage is underpowered for my project?)
>>
>>         [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>> https://stat.ethz.ch/mailman/listinfo/r-help
>> PLEASE do read the posting guide
>> http://www.R-project.org/posting-guide.html
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
>	[[alternative HTML version deleted]]
>
>______________________________________________
>R-help using r-project.org mailing list -- To UNSUBSCRIBE and more, see
>https://stat.ethz.ch/mailman/listinfo/r-help
>PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
>and provide commented, minimal, self-contained, reproducible code.

-- 
Sent from my phone. Please excuse my brevity.



More information about the R-help mailing list