Skip to content

Latest commit

 

History

History
22 lines (17 loc) · 885 Bytes

README.md

File metadata and controls

22 lines (17 loc) · 885 Bytes
Raw

csv-parse-to-txt

Author: Ian A. Wardell

Description: This script intakes a.csv file and outputs the columns into a.txt file; parse a user specified CSV file into one .txt per row

Usage: In Bash ./csv_to_txt.py -f sample.csv

Requirements:

  • input file must be a .csv file
  • input file must NOT include column headings
  • column headings must be in the following format: referencenumber,House/senate,first,last,district,state,party,title,link,title,cleantext,date,tone(manual),criticismtype,Political/Regular,Counter-majoritarian,Democratic Process,Other

How to convert .xlsx (Microsoft Excel) to .csv: File -> Save As -> Select 'CSV UTF-8 (comma delimated) (*.csv)' from drop down -> Save

Steps to use:

  1. Delete column heading row from the Excel file
  2. Convert .xlsx to .csv
  3. Run the python script ./csv_to_txt.py -f sample.csv
  4. Open the output folder to view results