Answers for "pandas select rows by index list"

2

pandas select row by index

#for single row
df.loc[ index , : ]

# for multiple rows
indices = [1, 20, 33, 47, 52 ]
new_df= df.iloc[indices, :]
Posted by: Guest on April-10-2021
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

Code answers related to "pandas select rows by index list"

Python Answers by Framework

Browse Popular Code Answers by Language