How to Avoid Skipping First Row in Pandas Data Frame (Python)?

Asked Oct 25 '20 at 11:01

Active Oct 25 '20 at 11:13

Viewed 128 times

I used df = pd.read_csv('text.csv', skiprows=1) to skip the text headings in the data set. The output is similar to this:

  24424 5435 4343 
0 43533 3432 5346 
1 42243 4353 3434

However, what I want is:

0 24424 5435 4343 
1 43533 3432 5346 
2 42243 4353 3434

Because the first line currently won't print when I e.g. do this:

df2 = df.values.tolist()
print(df2)

Out:

[[43533 3432 5346], [42243 4353 3434]]

Where the first row is unfortunately skipped. Any ideas how to fix?

Note: I didn't use headers=None as suggested, otherwise I get this output:

0 colA  colB colC
1 24424 5435 4343 
2 43533 3432 5346 
3 42243 4353 3434

edited Oct 25 '20 at 11:13

asked Oct 25 '20 at 11:01

use headers=False – Christian Sloper Oct 25 '20 at 11:02
@ChristianSloper `headers=None` doesn't work because there are headers in the csv file, which will be used as the first row if I do this. That's why I used `skiprows=1` so that the headers aren't used in the output. Any ideas how to still achieve what I'm aiming for? – Oct 25 '20 at 11:11
if there are headers, then don't use skiprows – Christian Sloper Oct 25 '20 at 11:20

0 Answers0