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 at
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 at 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 at utoronto.ca Tel: 416.864.5776 Fax: 416.864.3016