'Rename unnamed column pandas dataframe

My csv file has no column name for the first column, and I want to rename it. Usually, I would do data.rename(columns={'oldname':'newname'}, inplace=True), but there is no name in the csv file, just ''.

python pandas csv

Solution 1:^[1]

You can view the current dataframe using data.head()

if that returns 'Unnamed: 0' as the column title, you can rename it in the following way:

data.rename( columns={'Unnamed: 0':'new column name'}, inplace=True )

Solution 2:^[2]

When you load the csv, use the option 'index_col' like

pd.read_csv('test.csv', index_col=0)

index_col : int or sequence or False, default None Column to use as the row labels of the DataFrame. If a sequence is given, a MultiIndex is used. If you have a malformed file with delimiters at the end of each line, you might consider index_col=False to force pandas to not use the first column as the index (row names)

http://pandas.pydata.org/pandas-docs/dev/generated/pandas.io.parsers.read_csv.html

Solution 3:^[3]

The solution can be improved as data.rename( columns={0 :'new column name'}, inplace=True ). There is no need to use 'Unnamed: 0', simply use the column number, which is 0 in this case and then supply the 'new column name'.

Solution 4:^[4]

This should work:

data.rename( columns={0 :'Articles'}, inplace=True )

Solution 5:^[5]

Try the below code,

df.columns = [‘A’, ‘B’, ‘C’, ‘D’]

Solution 6:^[6]

It can be that the first column/row could not have a name, because it's an index and not a column/row. That's why you need to rename the index like this:

df.index.name = 'new_name'

Solution 7:^[7]

usually the blank column names are named based on their index

so for example lets say the 4 column is unnamed.

df.rename({'unnamed:3':'new_name'},inplace=True)

usually it is named like this since the indexing of columns start with zero.

Solution 8:^[8]

It has a name, the name is just '' (the empty string).

In [2]: df = pd.DataFrame({'': [1, 2]})

In [3]: df
Out[3]: 

0  1
1  2

In [4]: df.rename(columns={'': 'A'})
Out[4]: 
   A
0  1
1  2

Solution 9:^[9]

Another solution is to invoke the columns of the dataframe and use replace:

df.columns = df.columns.str.replace('Unnamed: 0','new_name')

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	domwrap
Solution 2	KyungHoon Kim
Solution 3	ambrish dhaka
Solution 4	Pang
Solution 5	Angel F Syrus
Solution 6	tsveti_iko
Solution 7	shyam_gupta
Solution 8	TomAugspurger
Solution 9	Sanjoy Som

'Rename unnamed column pandas dataframe

Solution 1:[1]

Solution 2:[2]

Solution 3:[3]

Solution 4:[4]

Solution 5:[5]

Solution 6:[6]

Solution 7:[7]

Solution 8:[8]

Solution 9:[9]