I have a pandas data frame which looks like this
Name | Index1 | Index2 |
---|---|---|
AAA | 67 | 70 |
Aaa | 55 | 80 |
Abb | 32 | 20 |
BBB | 84 | 45 |
Baa | 80 | 70 |
Bbb | 13 | 40 |
where some rows have names with all uppercase
and some with lowercase
. How can i create another dataframe with only the uppercase rows
expected output will be :
Name | Index1 | Index2 |
---|---|---|
AAA | 67 | 70 |
BBB | 84 | 45 |
Advertisement
Answer
Use isupper
from pandas:
df = df.loc[df["Name"].str.isupper(), :]