Reading a CSV

Question

Reading a CSV

Steve Jones - SSC Editor

SSC Guru

Points: 737496
More actions
September 26, 2017 at 8:27 pm

#77335

Comments posted to this topic are about the item Reading a CSV

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72693 More actions · Answer 1

Only ever worked with a SQL data set, so learned something new, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

paul s-306273 SSChampion Points: 10730 More actions · Answer 2

Subtle difference between third and fourth options caught me out.

George Vobr SSChampion Points: 10050 More actions · Answer 3

The use of backslashes in file addressing is very well explained e.g. in R for Microsoft Excel Users
Easier is to use forward slashes: file="c:/nfl/2016qbstats.csv"

TomThomson SSC Guru Points: 104773 More actions · Answer 4

It's a bit of an easy question, it would have been a bit, harder if it had escaped \ in one of the red herrings. As it stands, if one knows that a \ in a quoted filename has to be escaped that takes you immediately to the right answer without having to know anything about read.csv or the inability to copye from a file without calling a function to do it or the nonexistence of loadcsv (or maybe it exists in some obscure package somewhere?).

Tom

Avi1 SSCrazy Points: 2323 More actions · Answer 5

Forward slash is easier. We can use the singlequote as well for the file path parameter

Revenant SSC-Forever Points: 42467 More actions · Answer 6

It is nice to see A NFL-related question that does not assume that you know the rules. Thanks, Steve!

Luis Cazares SSC Guru Points: 183706 More actions · Answer 7

Revenant - Wednesday, September 27, 2017 7:51 PM
It is nice to see A NFL-related question that does not assume that you know the rules. Thanks, Steve!

I didn't even realized that it was an NFL related question. Only after I saw your comment and went back to find out that it had QB stats for last season.

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Reading a CSV

Cookies on SQLServerCentral