Selecting values from a Pandas DataFrame with a hierarchical index

Question

I am trying to create a scatterplot of price vs. number for a certain year, say 2000.

I tried plotting with plt.plot(summary.price, summary.number, 'ro'), but I want it for a specific year so tried to only get the data from year 2000 with df['2000'] but it says key error.

How do I create a scatterplot with data from just a specific year?

enter image description here

joaquin · Accepted Answer · 2014-09-20 19:20:47Z

1

To get the dataframe rows for index 2000 you can use:

df.xs(2000)

Other methods for selecting your data by the label of the index are:

df.loc[2000]   # label based
df.ix[2000]    # label and position based

enter image description here

Check Pandas docs for more information

edited Sep 20, 2014 at 19:20

answered Sep 20, 2014 at 19:03

joaquin

86k31 gold badges146 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

joaquin Over a year ago

I reproduced your table and it works. Is 2000 a string or a number ? check that.

Collectives™ on Stack Overflow

Selecting values from a Pandas DataFrame with a hierarchical index

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related