Pandas read_csv() with one row of data returns Empty Dataframe

Question

I have a csv file with one row of data with no header. Below is my code for importing data into a dataframe:

df2 = pd.read_csv(path2, header=0)

When I do read_csv it returns the following:

Empty DataFrame
Columns: [0.940456, 0.077893, 0.840178, 0.668612, 0.923643, 0.641833, 0.845249, 0.361605, 0.453943, 0.695509, 0.825763, 0.503687, 0.617303, 0.276637, 0.636244, 0.075744]
Index: []

df2.info() returns the following:

Index: 0 entries
Data columns (total 16 columns):
0.940456    0 non-null object
...

How do I set the first row as row instead of columns?

Is it the same when using header=None?

LocoGris
– LocoGris

2019-02-06 14:43:05 +00:00
Commented Feb 6, 2019 at 14:43 — LocoGris
– LocoGris, Commented Feb 6, 2019 at 14:43
rows, you mean index or data part?

hygull
– hygull

2019-02-06 14:44:01 +00:00
Commented Feb 6, 2019 at 14:44 — hygull
– hygull, Commented Feb 6, 2019 at 14:44

jezrael · Accepted Answer · 2019-02-06 14:40:47Z

6

It means first row is converted to columns names, need header=None for default columns names with data in first row of DataFrame:

df2 = pd.read_csv(path2, header=None)

answered Feb 6, 2019 at 14:40

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tiphaine Over a year ago

The default behavior for pd.read_csv() is header=0 which means that the first line will be considered as column names while header=None will not take the first row as columns as indicated in the documentation.

Collectives™ on Stack Overflow

Pandas read_csv() with one row of data returns Empty Dataframe

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related