CODEWITHSUNDEEP
pythonpandascsv
Felipe Araya
Felipe Araya

Reputation: 41

Any idea how to import this data set?

I have the following dataset:

https://github.com/felipe0216/fdfds/blob/master/sheffield_weather_station.csv

I know it is a csv, so I can use the pd.read_csv() function. However, if you look into the file it is not comma separated values nor a tab separated values, I am not sure what separation it has exactly. Any ideas about how to open it?

Upvotes: 1

Views: 70

Answers (1)

Akaisteph7
Akaisteph7

Reputation: 6496

The proper way to do this is as follows:

df = pd.read_csv("sheffield_weather_station.csv", comment="#", delim_whitespace=True)

You should first download the .csv file. You have to tell pandas that there will be comments and that there will just be spaces separating the columns. The amount of spaces do not matter.

Upvotes: 3

Related Questions