Issues while using .loc with a Pandas dataframe

Question

    raw=pd.read_csv('raw_6_12_8_30.csv')
    raw2=raw.loc[raw['spices'].isnull()==False]  # code for deleting 10 values #

    b=[]

    for i in range(len(raw2)):
        if raw2['Status'][i]==0:            # codes didn't run perfectly#
            print(i)

But when I use this code without line 2, it works fine.

    raw=pd.read_csv('raw_6_12_8_30.csv')
    b=[]

    for i in range(len(raw)):
        if raw['Status'][i]==0:            
            print(i)

I checked there is no errors in this raw2['Status] and raw['Status']

But whenever I use pandas.loc ,there is an error.

I bet that line 2 makes an error but I don't know why?

error images here enter image description here

key errors 11 # what is it #

In your own words: when you do for i in range(len(raw)), what values will i have? Now, you are using the values like so: raw['Status'][i]. Does that make sense? How many things are in raw? How many things are in raw['Status']? Do you expect those answers to be the same? Why? — Karl Knechtel
– Karl Knechtel, Commented Jun 13, 2020 at 11:13

Sohaib Anwaar · Accepted Answer · 2020-06-14 09:12:40Z

1

there are 3 ways to get values from dataframe by indexing.

loc gets rows (or columns) with particular labels from the index.
iloc gets rows (or columns) at particular positions in the index (so it only takes integers).
ix usually tries to behave like loc but falls back to behaving like iloc if a label is not present in the index.

if you want to take values by indexing you can use iloc. Like in the code below

raw=pd.read_csv('raw_6_12_8_30.csv')
b=[]

for i in range(len(raw)):
    if raw['Status'].iloc[i]==0:            
        print(i)

answered Jun 14, 2020 at 9:12

Sohaib Anwaar

1,5572 gold badges15 silver badges32 bronze badges

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

Comments

Tahirhan · Accepted Answer · 2020-06-13 12:06:19Z

0

can you try with :

for i in range(0,len(raw)-1):

i guess key error 11 occur because of index range. the key 11 may be out of range.

answered Jun 13, 2020 at 12:06

Tahirhan

3711 gold badge9 silver badges18 bronze badges

2 Comments

김정의 Over a year ago

no... it doesn't work. to solve the question i have to make new csv file like raw2.to_csv('raw3.csv) and i recall the new table raw3= pd.read_csv('raw3.csv') and then it works. i don't know why

Tahirhan Over a year ago

hmm, interesting. can you share the exact error message?

Yaakov Bressler · Accepted Answer · 2020-06-14 09:46:15Z

0

Are you trying to drop all rows where spices is null?

raw.dropna(subset="spices", inplace=True)

To print where the status is 0:

raw_subset = raw[raw["Status"]==0]
print(raw_subset)

# To get the specific indices
print(raw_subset.index)

answered Jun 14, 2020 at 9:46

Yaakov Bressler

12.7k5 gold badges66 silver badges96 bronze badges

Collectives™ on Stack Overflow

Issues while using .loc with a Pandas dataframe

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related