Force Python Pandas DataFrame( read_csv() method) to avoid/not consider first row of my csv/txt file as header

Question

I am reading a txt file (data.txt) using pandas read_csv method. The file has 16 columns and 600 rows. However, after reading the csv into dataframe, I observed that first row in my data.txt file has been taken as the column headings in the dataframe. This reduces the size of my dataframe to 599 from 600 in my text file. How can I force pandas to not use first row as headers for Dataframe. I am using this code to read the file.

import pandas as pd
df = pd.read_csv("C:\<my_directory_path>\data.txt)

pd.read_csv("FILE", header=False)

economy
– economy

2015-12-11 00:08:28 +00:00
Commented Dec 11, 2015 at 0:08 — economy
– economy, Commented Dec 11, 2015 at 0:08

Ezer K · Accepted Answer · 2015-12-11 00:01:53Z

1

Just add header=None:

import pandas as pd
df = pd.read_csv("C:\<my_directory_path>\data.txt",header=None)

answered Dec 11, 2015 at 0:01

Ezer K

3,7615 gold badges25 silver badges50 bronze badges

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

Comments

maxymoo · Accepted Answer · 2015-12-11 00:03:11Z

0

You can use the parameter header=None to read your data in with integers to index the columns, alternatively if you know what the names of your columns are, you can pass in something like names=['col1','col2','col3']

answered Dec 11, 2015 at 0:03

maxymoo

36.7k12 gold badges97 silver badges121 bronze badges

Collectives™ on Stack Overflow

Force Python Pandas DataFrame( read_csv() method) to avoid/not consider first row of my csv/txt file as header

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related