Python Forum
How to filter data using a panda.DateFrame.loc
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to filter data using a panda.DateFrame.loc
#1
I do not know why I am getting such a mistake.
Error:
File "C:\Anaconda3\lib\site-packages\pandas\core\frame.py", line 2726, in _getitem_array indexer = self.loc._convert_to_indexer(key, axis=1) File "C:\Anaconda3\lib\site-packages\pandas\core\indexing.py", line 1327, in _convert_to_indexer .format(mask=objarr[mask])) KeyError: "Index(['1950', '1960', '1970', '1980', '1990', '2000', '2010'], dtype='object') not in index"
My code:
import pandas as pd
import matplotlib.pyplot as plt
import numpy as np
import seaborn as sns
plt.rcParams["figure.figsize"] = (14,5)
df_k = pd.read_csv("smiertelnosc_polska_kobiety.csv", index_col="Wiek")
df_m = pd.read_csv("smiertelnosc_polska_mezczyzni.csv", index_col="Wiek")
years = df_k.columns.str.strip('Rok')
df_k.columns=years.astype(int)
plt.style.use('ggplot')
df_k.plot(kind='bar')
plt.ylabel('Probability death-women')
df_k = df_k.loc[df_k[years] == 2010]


years = df_m.columns.str.strip('Rok')
df_m.columns=years.astype(int)
plt.style.use('ggplot')
df_m.plot(kind='bar')
plt.ylabel('probability death -men')
df_m = df_m.loc[df_m[years] == 2010]
I want to create a graph for only 2010.
Reply
#2
Notice that 2010 is a name of the column. With pandas it is very easy to get all values from specific column:
df['column name']

So you can do something like:
import pandas as pd
import matplotlib.pyplot as plt

df_k = pd.read_csv("smiertelnosc_polska_kobiety.csv", index_col="Wiek")

plt.rcParams["figure.figsize"] = (14,5)
plt.style.use('ggplot')
plt.ylabel('Probability death-women')
plt.plot(df_k['2010'])
plt.show()
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Adding a new column to a Panda Data Frame rsherry8 2 2,083 Jun-06-2021, 06:49 PM
Last Post: jefsummers
  how to filter data frame dynamically with the columns psahay 0 2,378 Aug-24-2020, 01:10 PM
Last Post: psahay
  Filter data based on a value from another dataframe column and create a file using lo pawanmtm 1 4,242 Jul-15-2020, 06:20 PM
Last Post: pawanmtm
  Filter rows by multiple text conditions in another data frame i.e contains strings an Pan 0 2,131 Jun-09-2020, 06:05 AM
Last Post: Pan
  do you know a code that will print all correlation values using numpty and panda? crispybluewaffle88 1 2,419 Mar-06-2019, 12:45 PM
Last Post: scidam
  Make panda dataframe output pretty carstenlp 2 2,903 Jan-17-2019, 10:04 AM
Last Post: carstenlp
  Panda Dataframe Rounding Issue ab0217 5 7,190 Nov-06-2018, 10:15 PM
Last Post: ichabod801
  How to filter specific rows from large data file Ariane 7 8,141 Jun-29-2018, 02:43 PM
Last Post: gontajones
  Replacing values for specific columns in Panda data structure Padowan 1 14,634 Nov-27-2017, 08:21 PM
Last Post: Padowan
  Panda.read_cvs Issues Reading Certain Columns BlackHeart 5 6,089 Oct-27-2017, 04:29 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020