Advertisement
Guest User

Untitled

a guest
Aug 19th, 2019
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. """
  2. Convert CSVs into Excel sheets
  3. """
  4.  
  5. import glob
  6. import pandas as pd
  7.  
  8. with pd.ExcelWriter("output.xlsx") as writer:
  9. for file in glob.glob("*.csv"):
  10. df = pd.read_csv(file)
  11. df.to_excel(writer, sheet_name=file.replace(".csv", ""), index=False)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement