/Python/Pandas read_csv ignore unnamed columns

Pandas read_csv ignore unnamed columns

pd.read_csv(file_name, index_col=0)

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

Similar codes

11 votes108 views2 answers
Python cls statement using os module
Python
11 votes100 views6 answers
Python get size of file
Python
23 votes108 views6 answers
How to combine two lists in python
Python
3 votes97 views2 answers
Python inline print variable
Python
0 vote148 views1 answer
How to make a python script write the minimum and maximum value
Python
0 vote95 views1 answer
Linux desktop files location python
Python
0 vote91 views2 answers
Program to replace lower-case characters with upper-case and vice versa in python
Python
0 vote105 views3 answers
Valueerror: all strings must be xml compatible: unicode or ascii, no null bytes or control characters
Python
33 votes97 views4 answers
Convert list into integer in python
Python
0 vote103 views2 answers
How to terminate subprocess.call in python
Python