import pandas as pd
df=pd.read_excel("C:\\Users\\Lenovo\\Desktop\\Book1233232.xlsx",'Sheet1')
print(df)
df.drop(df[df['z']==-9999].index,inplace=True)
df=df.reset_index()
df=df.drop('index',axis=1)
print(df)
df.index.names=['new']
df.to_excel('new_123.xlsx')
