KeyError: "['China'] not in index"

Question

I am trying to select China's nationality tourists, this is my code snippet-

import pandas as pd 

China = ses[(ses["S1Country"] == 1)]
List_China = China[['Case','S1Country']]
List_China

This is what i put before the error

Here I am trying to selecting certain data - most sources that people used, the code snippet to perform it-

import pandas as pd 

Ranking1 = ses[(ses["Q7Infor1"] == 1)]
List_Ranking1 = Ranking1[['China','Q7Infor1']]
List_Ranking1

Then I wrote this code and it reported back to me 'KeyError: "['China'] not in index'

How do I solve it? Thanks for checking in!

sample of the data:

Can you provide a sample of your dataframe? How do your rows and columns look like? — user5305519, Jun 05 '21 at 05:27
Kindly provide a minimal reproducible example, How do you expect us to solve without a sample dataframe. — Kishore Sampath, Jun 05 '21 at 05:32

user5305519 · Answer 1 · 2021-06-05T06:06:05.667

1

Assuming that you are trying to filter the column Q7Infor1 by the value China, then you can use df[df['col'] == value].

Thus, your original code:

List_Ranking1 = Ranking1[['China','Q7Infor1']]

Becomes this:

List_Ranking1 = Ranking1[Ranking1['Q7Infor1'] == 'China']

Check this answer on the different ways you can filter a column by a row value.

Updated with OP's dataset

'China' is not a valid value in column Q7Infor1. So assuming that China=1, then we can filter by value 1:

China = 1
List_Ranking1 = Ranking1[Ranking1['Q7Infor1'] == China]

To count number of rows:

print(len(List_Ranking1))

edited Jun 05 '21 at 06:06

answered Jun 05 '21 at 05:31

user5305519

Hi!! what i am trying to do is to get the data from the China data tho... like i have selected china data from the cases and i am trying to rank the interests by finding the data from china again but it does not seem to work... – user16134318 Jun 05 '21 at 05:35
I see, can you edit your answer and provide us with some sample data? – user5305519 Jun 05 '21 at 05:37
can i attach file? – user16134318 Jun 05 '21 at 05:41
Updated answer with your dataset – user5305519 Jun 05 '21 at 05:54
but i wanna know the number of times it appeared to be rank 1 ... – user16134318 Jun 05 '21 at 06:03
Updated to include count number of rows – user5305519 Jun 05 '21 at 06:06
so the output means that the ranking number 1 has appeared 48 times in the data of china column only? – user16134318 Jun 05 '21 at 06:12

1 Answers1