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 split a csv file with csvkit?
- How to skip the first line with csvkit?
- How to fetch unique values with csvkit?
- How to rename a column with csvkit?
- How to use csvkit on Windows?
- How to remove duplicates with csvkit?
- How to group by in csvkit?
- How to reorder columns with csvkit?
- How to join two files with csvkit?
- How to merge columns with csvkit?
See more codes...