csvplait Interactive Tool for Manipulating CSV files
Download

csvplait Ranking & Summary

csvplait Tags

Python csv comma

csvplait Description

csvplait is a Python tool for manipulating CSV files either interactively or via script.UsageInteractive python csvplait.py # Read in the CSV > read myfile.csv # Pretty print the table > pp # Drop first 2 columns > drop 0 1 # Keep first five columns (labeled 0 to 4) > slice 0 4 # this -> This > titleize 0 # foo -> bar > strsub foo bar 0 2 > write fixedup.csvScriptYou can easily create a script by writing out your history to a file:> history script.csvplaitIf you want to make your script even more programatic, you can add variables using a bash-like syntax: cat script.csvplaitread $FILENAMEdrop 0write $FILENAME.fixedupThen, to invoke the script, run csvplait with the script as an argument as well as any environment variables that the script uses: python csvplait.py script.csvplait FILENAME=sept.csvProduct's homepage

csvplait Related Software