Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import glob
- all_data = pd.DataFrame()
- for f in glob.glob("name*.xlsx"):
- df = pd.read_excel(f)
- all_data = all_data.append(df,ignore_index=True)
- all_data = all_data[df.columns]
- ndexNames = all_data[ (all_data['Stat 01'] == 90) & (all_data['Stat 01'] == 9) ].index
- all_data.drop(indexNames , inplace=True)
- all_data.dropna(subset=['Stat 03'], how='any')
- all_data.to_excel('done.xlsx', index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement