csvkitHow to update specific records using csvkit?
Updating specific records using csvkit can be done using the csvcut
and csvjoin
commands.
The csvcut
command can be used to select specific columns from a CSV file. For example, the following command will select the columns name
and age
from the file example.csv
:
csvcut -c name,age example.csv
The csvjoin
command can be used to join two CSV files together. For example, the following command will join the file example.csv
with the file update.csv
on the column name
:
csvjoin -c name example.csv update.csv
The output of this command will be a new CSV file with the columns from both example.csv
and update.csv
, with the records from update.csv
replacing the records from example.csv
with the same name
value.
Helpful links
More of Csvkit
- How to convert a tsv file to csv with csvkit?
- How to skip the first line with csvkit?
- How to convert a csv file to tab delimited with csvkit?
- How to select specific columns with csvkit?
- How to merge columns with csvkit?
- How to use csvkit on Windows?
- How to fetch unique values with csvkit?
- How to sort a csv file with csvkit?
- How to remove duplicates with csvkit?
- How to convert a json file to csv with csvkit?
See more codes...