Remove Unnamed columns in pandas dataframe [duplicate]

by 
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

NOTE: very often there is only one unnamed column Unnamed: 0, which is the first column in the CSV file. This is the result of the following steps:

  1. a DataFrame is saved into a CSV file using parameter index=True, which is the default behaviour
  2. we read this CSV file into a DataFrame using pd.read_csv() without explicitly specifying index_col=0 (default: index_col=None)

The easiest way to get rid of this column is to specify the parameter pd.read_csv(..., index_col=0):

df = pd.read_csv('data.csv', index_col=0)

More Related Contents:

  1. Why does the following code cant get value of n_fold = 1?
  2. Filter dataframe rows if value in column is in a set list of values [duplicate]
  3. Converting a Pandas GroupBy output from Series to DataFrame
  4. String concatenation of two pandas columns
  5. datetime dtypes in pandas read_csv
  6. Reshape wide to long in pandas
  7. Pandas DataFrame: replace all values in a column, based on condition
  8. Pandas – Slice large dataframe into chunks
  9. Calculate average of every x rows in a table and create new table
  10. Find column name in pandas that matches an array
  11. How do convert a pandas dataframe to XML?
  12. Removing prefix from column names in Pandas
  13. Sort a pandas dataframe series by month name
  14. Strip / trim all strings of a dataframe
  15. pandas get the row-wise minimum value of two or more columns
  16. Set maximum value (upper bound) in pandas DataFrame
  17. Diff of two Dataframes
  18. Normalizing pandas DataFrame rows by their sums
  19. Apply function to pandas DataFrame that can return multiple rows
  20. How to merge multiple dataframes
  21. How can I get a value from a cell of a dataframe?
  22. Extract int from string in Pandas
  23. How to slice a pandas DataFrame by position?
  24. Python Pandas – Merge based on substring in string
  25. Filling in date gaps in MultiIndex Pandas Dataframe
  26. Writing a Python Pandas DataFrame to Word document
  27. Find unique values in a Pandas dataframe, irrespective of row or column location
  28. How to convert DataFrame.append() to pandas.concat()?
  29. How to efficiently assign unique ID to individuals with multiple entries based on name in very large df
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment