How to (re)name an empty column header in a pandas dataframe without exporting to csv
I think inplace=True
has to be removed, because it return None
:
df2 = df1.rename(columns = {"" : "Signal"})
df1.rename(columns = {"" : "Signal"}, inplace = True)
Another solution is asign new name by position:
df.columns.values[0] = 'Signal'
Sample:
df1 = pd.DataFrame({'':[1,2,3], 'B':[4,5,6], 'C':[7,8,9]})print (df1) B C0 1 4 71 2 5 82 3 6 9df2 = df1.rename(columns = {"" : "Signal"})print (df2) Signal B C0 1 4 71 2 5 82 3 6 9
You can use this if there are multiple empty columns. This will generate an empty column with cols and i (for the column position)
df.columns = ["cols_"+str(i) if a == "" else a for i, a in enumerate(df.columns)]#cols -> just rename the column name just as you want#i -> count the column number