1import pandas as pd
2
3df = pd.DataFrame(["STD, City State",
4"33, Kolkata West Bengal",
5"44, Chennai Tamil Nadu",
6"40, Hyderabad Telengana",
7"80, Bangalore Karnataka"], columns=['row'])
8
9out = pd.DataFrame(df.row.str.split(' ',2).tolist(),columns=['STD','City','State'])
10out.drop(index=0,inplace=True)