Answers for "how to remove a whole column from a data frame"

8

drop a column from dataframe

#To delete the column without having to reassign df
df.drop('column_name', axis=1, inplace=True)
Posted by: Guest on August-25-2020
1

drop unamed 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
Posted by: Guest on December-04-2020
1

pandas drop column in dataframe

>>> df.drop(['B', 'C'], axis=1)
   A   D
0  0   3
1  4   7
2  8  11
Posted by: Guest on July-31-2020
-2

drop a column from dataframe

#to drop by column number instead of by column label, try this to delete, e.g. the 1st, 2nd and 4th columns
df = df.drop(df.columns[[0, 1, 3]], axis=1)  # df.columns is zero-based pd.Index
Posted by: Guest on August-25-2020

Code answers related to "how to remove a whole column from a data frame"

Python Answers by Framework

Browse Popular Code Answers by Language