Answers for "pandas get data by index"

5

finding the index of an element in a pandas df

In [48]: a
Out[48]: 
   c1  c2
0   0   1
1   2   3
2   4   5
3   6   7
4   8   9

In [49]: a.c1[a.c1 == 8].index.tolist()
Out[49]: [4]
Posted by: Guest on September-18-2020
2

isolate row based on index pandas

dfObj.iloc[: , [0, 2]]
Posted by: Guest on March-30-2020
2

retrieve row by index pandas

rowData = dfObj.loc[ 'b' , : ]
Posted by: Guest on April-20-2020
0

pandas select rows by index level

### w3sources ###
d = {'num_legs': [4, 4, 4, 2, 2],
     'num_wings': [0, 0, 0, 2, 2],
     'class': ['mammal', 'mammal', 'mammal', 'bird', 'bird'],
     'animal': ['tiger', 'lion', 'fox', 'eagle', 'penguin'],
     'locomotion': ['walks', 'walks', 'walks', 'flies', 'walks']}

df = pd.DataFrame(data=d)
df = df.set_index(['class', 'animal', 'locomotion'])

#							num_legs	num_wings
# class	animal	locomotion		
# mammal| tiger	walks		4			0
#	    | lion	walks		4			0
#	    | fox	walks		4			0
# __________________________________________
# bird  | eagle		flies	2			2
#	    | penguin	walks	2			2
  
df.xs('mammal')
df.xs(('mammal', 'fox'))
df.xs('lion', level=1)
df.xs(('bird', 'walks'),level=[0, 'locomotion'])
Posted by: Guest on September-25-2021
-2

indexing column in pandas

In [8]: age_sex = titanic[["Age", "Sex"]]

In [9]: age_sex.head()
Out[9]: 
    Age     Sex
0  22.0    male
1  38.0  female
2  26.0  female
3  35.0  female
4  35.0    male
Posted by: Guest on March-24-2020
-1

indexing column in pandas

In [10]: type(titanic[["Age", "Sex"]])
Out[10]: pandas.core.frame.DataFrame
Posted by: Guest on March-24-2020

Python Answers by Framework

Browse Popular Code Answers by Language