headers
The headers command displays or modifies the headers of a CSV file.
Syntax
qsv headers [options] <input_file> [<output_file>]
Description
The headers command is used to display or modify the headers of a CSV file. This is useful for understanding the structure of a dataset or renaming columns.
Options
--no-headers: When set, the first row will not be interpreted as headers--rename <old_name>:<new_name>: Rename a column
Examples
Display Headers
Display the headers of a CSV file:
qsv headers DLD_Transactions_English_500.csv
Output:
transaction_id trans_group_en procedure_name_en instance_date property_type_en property_sub_type_en property_usage_en reg_type_en area_name_en building_name_en project_number project_name_en master_project_en nearest_landmark_en nearest_metro_en nearest_mall_en rooms_en has_parking procedure_area actual_worth meter_sale_price rent_value meter_rent_price no_of_parties_role_1 no_of_parties_role_2 no_of_parties_role_3
Rename Headers
Rename the property_type_en column to property_type:
qsv headers --rename property_type_en:property_type DLD_Transactions_English_500.csv | qsv table
Output:
transaction_id trans_group_en procedure_name_en instance_date property_type property_sub_type_en property_usage_en reg_type_en area_name_en building_name_en project_number project_name_en master_project_en nearest_landmark_en nearest_metro_en nearest_mall_en rooms_en has_parking procedure_area actual_worth meter_sale_price rent_value meter_rent_price no_of_parties_role_1 no_of_parties_role_2 no_of_parties_role_3
1-102-2022-29434 Sales Sell - Pre registration 28-09-2022 Unit Hotel Rooms Hospitality Off-Plan Properties Al Barsha South Fifth TERHAB HOTEL & TOWERS - TOWER 3 1722 TERHAB HOTEL & TOWERS AT JUMEIRAH VILLAGE TRIANGLE Jumeirah Village Triangle Sports City Swimming Academy Damac Properties Marina Mall Studio 1 34.35 555379.00 16168.24 null null 2 1 0
1-11-2024-19676 Sales Sell 31-05-2024 Flat Residential Existing Properties Marsa Dubai MARINA STAR 551 MARINA STAR Dubai Marina Sports City Swimming Academy Jumeirah Beach Residency Marina Mall 2 B/R 1 161.71 3481260.00 21527.80 null null 1 1 0
...
Common Use Cases
- Understanding the structure of a dataset
- Renaming columns for better readability
Tips
- Verify the output to ensure the headers are correctly displayed or modified
- Use in combination with other commands for complex data processing