Bottom Page

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 Dropping a column from pandas dataframe
#1
Output:
Date Price Open High Low Vol. Change % (Vol., Price, Open, High, Low) 0 Sep 03, 2019 1,789.84 1,771.45 1,801.11 1,767.61 3.55 0.76% 3.55 1 Aug 30, 2019 1,776.29 1,797.49 1,799.74 1,764.57 3.06 -0.57% 3.06 2 Aug 29, 2019 1,786.40 1,783.00 1,798.55 1,777.25 3.02 1.26% 3.02 3 Aug 28, 2019 1,764.25 1,755.00 1,767.86 1,744.05 2.42 0.14% 2.42 4 Aug 27, 2019 1,761.83 1,775.73 1,779.40 1,746.68 3.03 -0.40% 3.03
I can't find the way to drop the last column (Vol., Price, Open, High, Low)
I tried with drop method but doesnt work.
Tried to add \ before ( and ) but doesnt work.
How can i get rid of the last column?
Thanks.


ERROR I GET when trying with the below code (with and without \ before ( and ):
df_amzn = df_amzn.drop(columns="(Vol., Price, Open, High, Low)")
df_amzn.head()
Error:
KeyError Traceback (most recent call last) <ipython-input-569-c204ff3c6958> in <module> ----> 1 df_amzn = df_amzn.drop(columns="(Vol., Price, Open, High, Low)") 2 df_amzn.head() /Applications/Anaconda/anaconda3/lib/python3.7/site-packages/pandas/core/frame.py in drop(self, labels, axis, index, columns, level, inplace, errors) 3938 index=index, columns=columns, 3939 level=level, inplace=inplace, -> 3940 errors=errors) 3941 3942 @rewrite_axis_style_signature('mapper', [('copy', True), /Applications/Anaconda/anaconda3/lib/python3.7/site-packages/pandas/core/generic.py in drop(self, labels, axis, index, columns, level, inplace, errors) 3778 for axis, labels in axes.items(): 3779 if labels is not None: -> 3780 obj = obj._drop_axis(labels, axis, level=level, errors=errors) 3781 3782 if inplace: /Applications/Anaconda/anaconda3/lib/python3.7/site-packages/pandas/core/generic.py in _drop_axis(self, labels, axis, level, errors) 3810 new_axis = axis.drop(labels, level=level, errors=errors) 3811 else: -> 3812 new_axis = axis.drop(labels, errors=errors) 3813 result = self.reindex(**{axis_name: new_axis}) 3814 /Applications/Anaconda/anaconda3/lib/python3.7/site-packages/pandas/core/indexes/base.py in drop(self, labels, errors) 4963 if errors != 'ignore': 4964 raise KeyError( -> 4965 '{} not found in axis'.format(labels[mask])) 4966 indexer = indexer[~mask] 4967 return self.delete(indexer) KeyError: "['(Vol., Price, Open, High, Low)'] not found in axis"
scidam wrote Sep-05-2019, 12:12 AM:
Please post all code, output and errors (in it's entirety) between their respective tags. I did it for you this time, Here are instructions on how to do it yourself next time.
Quote
#2
What about looking at the documentation to pandas.DtaFrame.drop()?
Especially look at the examples and then you should realize that this line
df_amzn = df_amzn.drop(columns="(Vol., Price, Open, High, Low)")
doesn´t work because the parameter columns= is faulty.
Quote
#3
You should check the documentation of pandas.DataFrame.drop and version of pandas you are using (for example 'columns' is available from pandas 0.21)

It works for me with my dummy dataframe both with labels and with columns:

- df.drop(labels='(Vol., Price, Open, High, Low)', axis=1)
- df.drop(columns='(Vol., Price, Open, High, Low)')

If you want change the dataframe then you should set inplace:

- df.drop(columns='(Vol., Price, Open, High, Low)', inplace=True)

EDIT:

ninjad by ThomasL

I used this code to create dummy dataframe:

df = pd.DataFrame({'numbers': range(1, 4), 'letters': [*'abc'], '(Vol., Price, Open, High, Low)': 42})
I'm not 'in'-sane. Indeed, I am so far 'out' of sane that you appear a tiny blip on the distant coast of sanity. Bucky Katt, Get Fuzzy

Life of Brian: Conjugate the verb, "to go" !
Quote
#4
this line
df_amzn = df_amzn.drop(columns="(Vol., Price, Open, High, Low)")
has to be
df_amzn = df_amzn.drop(columns=["Vol.", "Price", "Open", "High", "Low"])
then pd.drop() works well.
Quote
#5
If I observe data provided by OP then I think that last column (8th) label is (Vol., Price, Open, High, Low)
I'm not 'in'-sane. Indeed, I am so far 'out' of sane that you appear a tiny blip on the distant coast of sanity. Bucky Katt, Get Fuzzy

Life of Brian: Conjugate the verb, "to go" !
Quote
#6
(Sep-05-2019, 01:17 PM)perfringo Wrote: If I observe data provided by OP then I think that last column (8th) label is (Vol., Price, Open, High, Low)

Definitely reading a post thoroughly makes the difference, of course, you´re right.

And OPs problem
Error:
KeyError: "['(Vol., Price, Open, High, Low)'] not found in axis"
results from
df_amzn = df_amzn.drop(columns="(Vol., Price, Open, High, Low)")
missing the axis="columns" parameter (or axis=1)
as axis="index" is the default and "(Vol., Price, Open, High, Low)" is not in the index.
df_amzn = df_amzn.drop(columns="(Vol., Price, Open, High, Low)", axis="columns")
as you already mentioned in your examples.
Quote
#7
Thanks a lot for your help guys!
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  How to add a few empty rows into a pandas dataframe python_newbie09 2 370 Sep-20-2019, 08:52 AM
Last Post: python_newbie09
  created a pandas series instead of pandas DataFrame ibaad1406 6 489 Sep-06-2019, 06:23 AM
Last Post: ibaad1406
  Applying operation to a pandas multi index dataframe subgroup Nuovoq 1 282 Sep-04-2019, 10:04 PM
Last Post: Nuovoq
  Substr on Pandas Dataframe Scott 1 321 Sep-02-2019, 02:49 AM
Last Post: scidam
  How to drop column in pandas SriMekala 3 376 Aug-26-2019, 06:36 PM
Last Post: snippsat
  Pandas Dataframe to Google Big Query Ecniv 1 387 Aug-21-2019, 04:56 PM
Last Post: ThomasL
  how to apply user defined function to Pandas DataFrame evelynow 3 561 Aug-20-2019, 11:35 PM
Last Post: scidam
  Create dataframe through Dictionary in pandas ift38375 2 201 Aug-11-2019, 01:09 AM
Last Post: boring_accountant
  Pandas Import CSV count between numerical values within 1 Column ptaylor520 3 202 Jul-16-2019, 08:13 AM
Last Post: ptaylor520
  How to use the excel filename as a value to populate new column, using Pandas? Dequanharrison 5 354 Jun-26-2019, 11:11 PM
Last Post: Dequanharrison

Forum Jump:


Users browsing this thread: 1 Guest(s)