Advertisement
Guest User

Untitled

a guest
Mar 26th, 2019
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. import pandas as pd
  2. import glob
  3.  
  4. all_data = pd.DataFrame()
  5. for f in glob.glob("name*.xlsx"):
  6. df = pd.read_excel(f)
  7. all_data = all_data.append(df,ignore_index=True)
  8. all_data = all_data[df.columns]
  9.  
  10. ndexNames = all_data[ (all_data['Stat 01'] == 90) & (all_data['Stat 01'] == 9) ].index
  11.  
  12. all_data.drop(indexNames , inplace=True)
  13. all_data.dropna(subset=['Stat 03'], how='any')
  14.  
  15. all_data.to_excel('done.xlsx', index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement