DataFrame.drop() does not recognise the columns keyword argument

See original GitHub issue

Code Sample, a copy-pastable example if possible

index = np.linspace(-3, 5, 7)
df = pd.DataFrame({'A': np.sin(index), 'B': np.cos(index**2)}, index=index)
df.drop(columns=['A'])

Problem description

The docs say that I can use the columns keyword, but when I try I get the following error:

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-139-3a18b0426444> in <module>()
      2 df = pd.DataFrame({'A': np.sin(index), 'B': np.cos(index**2)}, index=index)
      3 # type(df.apply(np.sum, axis=1, reduce=False))
----> 4 df.drop(columns=['A'])

TypeError: drop() got an unexpected keyword argument 'columns'

The following is a workaround:

df.drop('A', axis=1)

Output of pd.show_versions()

INSTALLED VERSIONS

commit: None python: 3.6.2.final.0 python-bits: 64 OS: Windows OS-release: 10 machine: AMD64 processor: Intel64 Family 6 Model 94 Stepping 3, GenuineIntel byteorder: little LC_ALL: None LANG: None LOCALE: None.None

pandas: 0.20.3 pytest: 3.2.1 pip: 9.0.1 setuptools: 36.5.0.post20170921 Cython: 0.26.1 numpy: 1.13.1 scipy: 0.19.1 xarray: None IPython: 6.1.0 sphinx: 1.6.3 patsy: 0.4.1 dateutil: 2.6.1 pytz: 2017.2 blosc: None bottleneck: 1.2.1 tables: 3.4.2 numexpr: 2.6.2 feather: None matplotlib: 2.0.2 openpyxl: 2.4.8 xlrd: 1.1.0 xlwt: 1.3.0 xlsxwriter: 0.9.8 lxml: 3.8.0 bs4: 4.6.0 html5lib: 0.999999999 sqlalchemy: 1.1.13 pymysql: None psycopg2: None jinja2: 2.9.6 s3fs: None pandas_gbq: None pandas_datareader: None

Issue Analytics

  • State:closed
  • Created 6 years ago
  • Reactions:9
  • Comments:7 (3 by maintainers)

github_iconTop GitHub Comments

21reactions
TomAugspurgercommented, Jan 4, 2018

The index / columns keywords were added in 0.21 (there’s a little note about that just below those keywords in the parameters list).

0reactions
TomAugspurgercommented, May 14, 2019

@DevinCharles you can use a tuple

In [20]: df = pd.DataFrame({("A", 1): [1, 2], ("A", 2): [3, 4]})

In [21]: df.drop(columns=('A', 1))
Out[21]:
   A
   2
0  3
1  4

If you think there’s still a bug, open a new issue, since this one has been closed.

Read more comments on GitHub >

github_iconTop Results From Across the Web

I am using google colab, everything is up to date and still get ...
I am using google colab, everything is up to date and still get this error TypeError: drop() got an unexpected keyword argument 'axis'...
Read more >
Pandas drop column : Different methods
To drop a single column or multiple columns from pandas dataframe in Python, you can use `df.drop` and other different methods.
Read more >
How to Drop Multiple Columns in Pandas: The Definitive Guide
Learn the approaches for how to drop multiple columns in pandas. We'll demo the code to drop DataFrame columns and weigh the pros...
Read more >
pandas.DataFrame.drop — pandas 1.5.2 documentation
Drop specified labels from rows or columns. Remove rows or columns by specifying label names and corresponding axis, or by specifying directly index...
Read more >
Drop Empty Columns from Pandas Data Frames
dropna() method is used to remove missing data (which means “None”s and “NaN”s). It has a how keyword argument which determines how it...
Read more >

github_iconTop Related Medium Post

No results found

github_iconTop Related StackOverflow Question

No results found

github_iconTroubleshoot Live Code

Lightrun enables developers to add logs, metrics and snapshots to live code - no restarts or redeploys required.
Start Free

github_iconTop Related Reddit Thread

No results found

github_iconTop Related Hackernoon Post

No results found

github_iconTop Related Tweet

No results found

github_iconTop Related Dev.to Post

No results found

github_iconTop Related Hashnode Post

No results found