Writing to an Excel spreadsheet

by

Use DataFrame.to_excel from pandas. Pandas allows you to represent your data in functionally rich datastructures and will let you read in excel files as well.

You will first have to convert your data into a DataFrame and then save it into an excel file like so:

In [1]: from pandas import DataFrame
In [2]: l1 = [1,2,3,4]
In [3]: l2 = [1,2,3,4]
In [3]: df = DataFrame({'Stimulus Time': l1, 'Reaction Time': l2})
In [4]: df
Out[4]: 
   Reaction Time  Stimulus Time
0              1              1
1              2              2
2              3              3
3              4              4

In [5]: df.to_excel('test.xlsx', sheet_name="sheet1", index=False)

and the excel file that comes out looks like this:

enter image description here

Note that both lists need to be of equal length else pandas will complain. To solve this, replace all missing values with None.

More Related Contents:

  1. How to write to an Excel spreadsheet using Python?
  2. Python convert csv to xlsx
  3. xls to csv converter
  4. Error: Unsupported format, or corrupt file: Expected BOF record
  5. IndexError: too many indices for array
  6. Python Pandas – Read csv file containing multiple tables
  7. create a loop inside a loop in python
  8. Pandas read_csv from url
  9. Python Pandas Error tokenizing data
  10. Read specific columns from a csv file with csv module?
  11. Read and Write CSV files including unicode with Python 2.7
  12. Load CSV file with Spark
  13. how to import csv data into django models
  14. How to convert a python datetime.datetime to excel serial date number
  15. Python 2 CSV writer produces wrong line terminator on Windows
  16. pandas read_csv and filter columns with usecols
  17. import text to pandas with multiple delimiters
  18. portable way to write csv file in python 2 or python 3
  19. Refresh Excel External Data with Python
  20. Streaming large training and test files into Tensorflow’s DNNClassifier
  21. How do you split reading a large csv file into evenly-sized chunks in Python?
  22. python pandas read_csv delimiter in column data
  23. Why does CSV file contain a blank line in between each data line when outputting with Dictwriter in Python [duplicate]
  24. module ‘pandas’ has no attribute ‘read_csv
  25. Python CSV: Remove quotes from value
  26. Pandas read_csv dtype read all columns but few as string
  27. csv: writer.writerows() splitting my string inputs
  28. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  29. How to convert csv to json in python?
  30. Using openpyxl to read file from memory

Leave a Comment