pandas drop unnamed columns
df = df.loc[:, ~df.columns.str.contains('^Unnamed')] In [162]: df Out[162]: colA ColB colC colD colE colF colG 0 44 45 26 26 40 26 46 1 47 16 38 47 48 22 37 2 19 28 36 18 40 18 46 3 50 14 12 33 12 44 23 4 39 47 16 42 33 48 38
Source: stackoverflow.com
pandas read_csv ignore unnamed columns
pd.read_csv(file_name, index_col=0)
remove unnamed column pandas
df.dropna(how='all', axis='columns', inplace=True)
Source: stackoverflow.com
dropping unnamed columns in pandas
df = df.loc[:, ~df.columns.str.contains('^Unnamed')] In [162]: df Out[162]: colA ColB colC colD colE colF colG 0 44 45 26 26 40 26 46 1 47 16 38 47 48 22 37 2 19 28 36 18 40 18 46 3 50 14 12 33 12 44 23 4 39 47 16 42 33 48 38
Source: stackoverflow.com
delete unnamed coloumns in pandas
# Best method so far. df = df.loc[:, ~df.columns.str.contains('^Unnamed')]
get rid of unnamed column pandas
df.to_csv(path, index=False)
Source: stackoverflow.com