Missing first row while reading from file - Python Pandas [duplicate]

Question

I have a file which has coordinates like

1  1
1  2
1  3
1  4
1  5

and so on

There are no zeros in them.I tried using comma and tab as a delimiter and still stuck in same problem. Now when I printed the output to screen I saw something very weird. It looks like it is missing the very first line.

The output after running pa.read_csv('co-or.txt',sep='\t') is as follows

   1  1
0   1  2
1   1  3
2   1  4
3   1  5

and so on.. I am not sure if I am missing any arguments in this.

Also when I tried to convert that to numpy array using np.array, It is again missing the first line and hence the first element [1 1]

Answer 1

df = pd.read_csv('data.csv', header=None)

You need to specifcy header=None otherwise pandas takes the first row as the header.

If you want to give them a meaningful name you can use the names as such:

df = pd.read_csv('data.csv', header=None, names=['foo','bar'])

Spend some time with pandas Documentation as well to get yourself familiar with their API. This one is for read_csv