Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import numpy as np
- df1 = pd.DataFrame({'Information1' : [19, 'game. tennis','Prof. HANA
- YAMADA', 'Canada.'],
- 'Information2' : ['books', 24, 'Shopping.','A. ELIZABETH
- JONES.'],
- 'Information3' : ['Mr. ADAMS', 'Italy', 'Japan', 23],
- 'Information4' : ['Australia', 'MARCO', 25, 'movies']},
- index = {'Person1','Person2','Person3', 'Person4'}
- )
- Information1 Information2 Information3 Information4
- Person1 19 books Mr. ADAMS Australia
- Person2 game. tennis 24 Italy MARCO
- Person3 Prof. HANA YAMADA Shopping. Japan 25
- Person4 Canada. A. ELIZABETH JONES. 23 movies
- Name
- Person1 ADAMS
- Person2 MARCO
- Person3 HANA YAMADA
- Person4 A. ELIZABETH JONES.
- Name = []
- for row in df1.itertuples():
- for item in row:
- if hasattr(item, "isupper") and item.isupper():
- Name.append(item)
- break
- else:
- Name.append(None)
- df1["Name"] = Name
- df1 =df1.drop(['Information1','Information2','Information3','Information4'],
- axis=1)
- Name
- Person1 None
- Person2 MARCO
- Person3 None
- Person4 A. ELIZABETH JONES.
Add Comment
Please, Sign In to add comment