creating multiple excel worksheets using data in a pandas dataframe

by 
import pandas as pd

df1 = pd.DataFrame({'Data': ['a', 'b', 'c', 'd']})

df2 = pd.DataFrame({'Data': [1, 2, 3, 4]})

df3 = pd.DataFrame({'Data': [1.1, 1.2, 1.3, 1.4]})

writer = pd.ExcelWriter('multiple.xlsx', engine="xlsxwriter")

df1.to_excel(writer, sheet_name="Sheeta")

df2.to_excel(writer, sheet_name="Sheetb")

df3.to_excel(writer, sheet_name="Sheetc")

writer.save()

More Related Contents:

  1. Why does the following code cant get value of n_fold = 1?
  2. Converting a Pandas GroupBy output from Series to DataFrame
  3. Pandas long to wide reshape, by two variables
  4. How to avoid Python/Pandas creating an index in a saved csv?
  5. Convert floats to ints in Pandas?
  6. datetime dtypes in pandas read_csv
  7. Split a large pandas dataframe
  8. Calculate average of every x rows in a table and create new table
  9. get previous row’s value and calculate new column pandas python
  10. Plotting grouped data in same plot using Pandas
  11. How to move pandas data from index to column after multiple groupby
  12. Parsing a JSON string which was loaded from a CSV using Pandas
  13. sorting by a custom list in pandas
  14. Get last “column” after .str.split() operation on column in pandas DataFrame
  15. How do you update the levels of a pandas MultiIndex after slicing its DataFrame?
  16. pandas equivalent of np.where
  17. Using Pandas Value_Counts and matplotlib
  18. How to plot two columns of a pandas data frame using points
  19. Python Pandas – Merge based on substring in string
  20. How to show a pandas dataframe into a existing flask html table?
  21. How to update Pandas from Anaconda and is it possible to use eclipse with this last
  22. What is the fastest way to output large DataFrame into a CSV file?
  23. What values are valid in Pandas ‘Freq’ tags?
  24. reading multiple files contained in a zip file with pandas
  25. how to save a pandas DataFrame to an excel file?
  26. How to filter a DataFrame column of lists for those that contain a certain item
  27. Excel VLOOKUP equivalent in pandas
  28. Seaborn multiple barplots
  29. Add density curve on the histogram
  30. pandas scatter plotting datetime

Leave a Comment