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]
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]
isolate row based on index pandas
dfObj.iloc[: , [0, 2]]
retrieve row by index pandas
rowData = dfObj.loc[ 'b' , : ]
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'])
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
indexing column in pandas
In [10]: type(titanic[["Age", "Sex"]])
Out[10]: pandas.core.frame.DataFrame
Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us