Pythonically add header to a csv file

by

The DictWriter() class expects dictionaries for each row. If all you wanted to do was write an initial header, use a regular csv.writer() and pass in a simple row for the header:

import csv

with open('combined_file.csv', 'w', newline="") as outcsv:
    writer = csv.writer(outcsv)
    writer.writerow(["Date", "temperature 1", "Temperature 2"])

    with open('t1.csv', 'r', newline="") as incsv:
        reader = csv.reader(incsv)
        writer.writerows(row + [0.0] for row in reader)

    with open('t2.csv', 'r', newline="") as incsv:
        reader = csv.reader(incsv)
        writer.writerows(row[:1] + [0.0] + row[1:] for row in reader)

The alternative would be to generate dictionaries when copying across your data:

import csv

with open('combined_file.csv', 'w', newline="") as outcsv:
    writer = csv.DictWriter(outcsv, fieldnames = ["Date", "temperature 1", "Temperature 2"])
    writer.writeheader()

    with open('t1.csv', 'r', newline="") as incsv:
        reader = csv.reader(incsv)
        writer.writerows({'Date': row[0], 'temperature 1': row[1], 'temperature 2': 0.0} for row in reader)

    with open('t2.csv', 'r', newline="") as incsv:
        reader = csv.reader(incsv)
        writer.writerows({'Date': row[0], 'temperature 1': 0.0, 'temperature 2': row[1]} for row in reader)

More Related Contents:

  1. How to add header row to a pandas DataFrame
  2. How do you remove the column name row when exporting a pandas DataFrame?
  3. Update a CSV file?
  4. How do I read and write CSV files with Python?
  5. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  6. Python convert csv to xlsx
  7. Create and download a CSV file from a Flask view
  8. How to read file with space separated values in pandas
  9. How do I set headers using python’s urllib?
  10. CSVWriter not saving data to file the moment I write it
  11. Python CSV to SQLite
  12. Save Dataframe to csv directly to s3 Python
  13. Writing to CSV with Python adds blank lines [duplicate]
  14. Writing a csv file into SQL Server database using python
  15. Panda’s Write CSV – Append vs. Write
  16. Python DictWriter writing UTF-8 encoded CSV files
  17. Convert tab-delimited txt file into a csv file using Python
  18. Numpy loading csv TOO slow compared to Matlab
  19. Unescape Python Strings From HTTP
  20. Error “(unicode error) ‘unicodeescape’ codec can’t decode bytes in position 2-3: truncated \UXXXXXXXX escape” [duplicate]
  21. How to read one single line of csv data in Python?
  22. IndexError: too many indices for array
  23. Pandas read_csv dtype leading zeros
  24. pandas.read_csv from string or package data
  25. Proper way to reset csv.reader for multiple iterations?
  26. AttributeError: ‘module’ object has no attribute ‘reader’ [duplicate]
  27. Pandas read_csv dtype read all columns but few as string
  28. csv: writer.writerows() splitting my string inputs
  29. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  30. How to convert csv to json in python?

Leave a Comment