import pandas as pd
dict = {"Population": {"Delhi":10927986, "Mumbai":12691836, "Kolkata":4631392, "Chennai":4328063}, 
        "Hospitals":{"Delhi":189, "Mumbai":208, "Kolkata":149, "Chennai":157},
        "Schools":{"Delhi":7916, "Mumbai":8508, "Kolkata":7226, "Chennai":7617}}
df = pd.DataFrame(dict)
print("Before Adding Column")
print(df)
print("-------------------------")

df["Students"]="12K"
print("After Adding Column Students")
print(df)
print("-------------------------")


df["Teachers"]=["10k", "20k", "30k", "40k"]
print("After Adding Column Teachers")
print(df)
print("-------------------------")

df.iat[3,3]="10000K"
df.at["Delhi","Schools"]=555555
print(df)
print("-----------------------------------")

df.loc["Agra"]=10
df.loc["Mathura"]=[10, 20,30, 40, 50]
print(df)

df.loc["Rohta",["Hospitals", "Schools"]]=20000
print(df)

del df["Hospitals"]

print(df)

df.loc["Agra",["Schools", "Students"]]=[1000000, 200000]
df.loc["Ajmer",["Schools", "Students"]]=[10541,5874125]
print(df)

print("-----------Bye----------------------")
'# print(df.index)
# print(df.columns)
# print(df.loc[["Delhi", "Mumbai"],["Students", "Teachers"]])

# x =' df.drop(["Mumbai", "Agra"], axis=0)
# y = df.drop(["Students", "Teachers"], axis=1)
# print(x)
# print(y)
# print(df)

# print("New DataFrame------------------------------------------")
# newdf = df.rename(index={"Delhi":"D"})
# print(newdf)
# print(df)
# print("Old Data Frame -----------------------------------------")
# df.rename(index={"Delhi":"D"}, inplace=True)
# print(df)


newdf=df.rename(columns={"Population":"P"})
print(newdf)
df.rename(columns={"Population":"P"}, inplace=True)
print(df)
df.rename(index={"Delhi":"Agra"}, columns={"Schools":"College"}, inplace=True)
print(df)