[R] tidyverse: read_csv() misses column

Kevin Thorpe kev|n@thorpe @end|ng |rom utoronto@c@
Mon Nov 1 17:50:23 CET 2021


I do not have a specific answer to your particular problem. All I can say is when a CSV import doesn’t work, it can mean there is something in the CSV file that is unexpected. When read_csv() fails, I will try read.csv() to compare the results.

Kevin


> On Nov 1, 2021, at 12:40 PM, Rich Shepard <rshepard using appl-ecosys.com> wrote:
> 
> The data file, cor-disc.csv begins with:
> site_nbr,year,mon,day,hr,min,tz,disc
> 14171600,2009,10,23,00,00,PDT,8750
> 
> The first 7 columns are character strings; the 8th column is an integer.
> 
> After loading library(tidyverse) I ran read_csv() with this result:
>> cor_disc <- read_csv("../data/cor-disc.csv")
>                                                                                                    Rows: 415263 Columns: 8
> ── Column specification ────────────────────────────────────────────────────────────────────────────
> Delimiter: ","
> chr (5): mon, day, hr, min, tz
> dbl (2): site_nbr, year
> 
> ℹ Use `spec()` to retrieve the full column specification for this data.
> ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
> 
> 1. What happed to the values in column 'disc?'
> 
> 2. Why are site_nbr and year seen as doubles when they're character strings?
> 
> I've not found answers in the book or in ?read_csv.
> 
> What am I missing?
> 
> Rich
> 
> ______________________________________________
> 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.

-- 
Kevin E. Thorpe
Head of Biostatistics,  Applied Health Research Centre (AHRC)
Li Ka Shing Knowledge Institute of St. Michael’s Hospital
Assistant Professor, Dalla Lana School of Public Health
University of Toronto
email: kevin.thorpe using utoronto.ca  Tel: 416.864.5776  Fax: 416.864.3016



More information about the R-help mailing list