![]() $csvgrep -c phone_number -r "d" mydata.csv > matchrx.csv # Find cells matching a regular expression (e.g. $csvcut -c RespondentID,CollectorID,StartDate,EndDate Sheet_1.csv | csvlook | head # Chain commands to pass data along using the pipeline symbol | $csvcut -c col1,col2,col3 myfile.csv # can also specify by name (make sure not to leave spaces) $csvcut -c 2,5,6 myfile.csv # Cut out columns to just 2,5,6 # Look at data, formats nicely with borders $in2csv myfile.xlsx > myfile.csv # can write xlsx file to csv by chaining operations ![]() # Peak at excel file to display in terminal ![]() col names, type, nulls, min, max, median, std deviation, unique values, most frequent) # Cleans a CSV file of common syntax errors. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |