frequency
The frequency command calculates the frequency of values in a specified column.
Syntax
qsv frequency [options] <column> <input_file> [<output_file>]
Description
The frequency command is used to calculate the frequency of values in a specified column. This is useful for analyzing the distribution of data.
Options
--no-headers: When set, the first row will not be interpreted as headers
Examples
Calculate Frequency
Calculate the frequency of values in the property_type_en column:
qsv frequency property_type_en DLD_Transactions_English_500.csv | qsv table
Output:
value frequency
Unit 100
Flat 200
...
Common Use Cases
- Analyzing data distribution
- Identifying common values
Tips
- Verify the output to ensure the frequencies are correctly calculated
- Use in combination with other commands for complex data analysis