I have a pandas data frame which looks like this

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 :

CodePudding user response：

Use isupper from pandas:

df = df.loc[df["Name"].str.isupper(), :]

CodePudding user response：

same as above, without using loc

>>> df=pd.DataFrame(['AAA','Aaa','BBB','Bbb'],columns=['test'])
>>> df[df.test.str.isupper()==True]
  test
0  AAA
2  BBB