Search and Filter
The search command allows you to filter your data based on specific conditions. This guide will demonstrate various ways to use the search command with qsv.
Basic Search
The search command offers several options to refine your search:
-i: Ignore case--literal: Treat the regex as a literal string-s: Select specific columns to search-v: Invert the match (select non-matching rows)-f: Flag matched rows in a new column-q: Quick mode (return on first match)-c: Count matches--json: Output results as JSON
Case-insensitive search across all columns
Case-insensitive search across all columns
qsv search '.*rawda.*' -i 'DLD_Transactions_English.csv' \
| qsv sample 10 \
| qsv table
This command performs a case-insensitive search for "rawda" across all columns, samples 10 rows from the results, and displays them in a table format.
Sample 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
1-41-2020-6885 Sales Delayed Sell 18-11-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 1 B/R 1 57.06 799888.00 14018.37 null null 1 1 0
2-13-2023-3505 Mortgages Mortgage Registratio... 08-03-2023 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 3 B/R 1 140.35 1187200.00 8458.85 null null 1 1 0
1-11-2024-19360 Sales Sell 30-05-2024 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 86.62 955000.00 11025.17 null null 2 1 0
1-41-2020-4984 Sales Delayed Sell 31-08-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkside 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 1 B/R 1 59.09 658888.00 11150.58 null null 1 1 0
1-41-2020-5068 Sales Delayed Sell 01-09-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkside 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 214.59 1082888.00 5046.31 null null 1 1 0
1-11-2023-2670 Sales Sell 30-01-2023 Unit Flat Residential Existing Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 90.65 860000.00 9487.04 null null 1 1 0
1-41-2021-3337 Sales Delayed Sell 05-04-2021 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 3 B/R 1 146.97 1678888.00 11423.34 null null 1 1 0
1-41-2020-4187 Sales Delayed Sell 22-07-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 92.16 982888.00 10665.02 null null 1 1 0
1-41-2021-9471 Sales Delayed Sell 14-09-2021 Unit Flat Residential Existing Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 3 B/R 1 134.77 1598888.00 11863.83 null null 1 1 0
1-102-2017-18119 Sales Sell - Pre registrat... 18-09-2017 Unit Flat Residential Off-Plan Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 85.87 979888.00 11411.30 null null 1 1 0
Case-insensitive search across a specific column
Case-insensitive search across a specific column
qsv search '.*rawda.*' -i -s 'project_name_en' 'DLD_Transactions_English.csv' \
| qsv sample 10 \
| qsv table
This command performs a case-insensitive search for "rawda" in the 'project_name_en' column, samples 10 rows from the results, and displays them in a table format.
Sample 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
1-41-2020-6885 Sales Delayed Sell 18-11-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 1 B/R 1 57.06 799888.00 14018.37 null null 1 1 0
2-13-2023-3505 Mortgages Mortgage Registratio... 08-03-2023 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 3 B/R 1 140.35 1187200.00 8458.85 null null 1 1 0
1-11-2024-19360 Sales Sell 30-05-2024 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 86.62 955000.00 11025.17 null null 2 1 0
1-41-2020-4984 Sales Delayed Sell 31-08-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkside 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 1 B/R 1 59.09 658888.00 11150.58 null null 1 1 0
1-41-2020-5068 Sales Delayed Sell 01-09-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkside 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 214.59 1082888.00 5046.31 null null 1 1 0
1-11-2023-2670 Sales Sell 30-01-2023 Unit Flat Residential Existing Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 90.65 860000.00 9487.04 null null 1 1 0
1-41-2021-3337 Sales Delayed Sell 05-04-2021 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 3 B/R 1 146.97 1678888.00 11423.34 null null 1 1 0
1-41-2020-4187 Sales Delayed Sell 22-07-2020 Unit Flat Residential Existing Properties Al Yelayiss 2 Parkviews 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 92.16 982888.00 10665.02 null null 1 1 0
1-41-2021-9471 Sales Delayed Sell 14-09-2021 Unit Flat Residential Existing Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 3 B/R 1 134.77 1598888.00 11863.83 null null 1 1 0
1-102-2017-18119 Sales Sell - Pre registrat... 18-09-2017 Unit Flat Residential Off-Plan Properties Al Yelayiss 2 TOWN SQUARE - RAWDA ... 1836 RAWDA APARTMENTS TOWN SQUARE Dubai Cycling Course 2 B/R 1 85.87 979888.00 11411.30 null null 1 1 0
Advanced Search Techniques
Inverting the search
Inverting the search
qsv search 'Residential' -v -s 'property_usage_en' 'DLD_Transactions_English.csv' \
| qsv sample 10 \
| qsv table
This command finds all rows where the 'property_usage_en' column does not contain 'Residential', samples 10 rows from the results, and displays them in a table format.
Sample 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
1-102-2018-451 Sales Sell - Pre registration 14-05-2018 Unit Hotel Apartment Hospitality Off-Plan Properties Jabal Ali First ROY MEDITERRANEAN 1762 Roy Mediterranean Hotel Apartments Al Furjan Expo 2020 Site Ibn Battuta Metro Station Ibn-e-Battuta Mall Studio 1 45.38 632592.00 13939.89 null null 1 2 0
1-102-2014-6357 Sales Sell - Pre registration 16-06-2014 Unit Hotel Rooms Hospitality Off-Plan Properties Business Bay DAMAC TOWERS BY PARAMOUNT (C) 443 DAMAC TOWERS BY PARAMOUNT Business Bay Downtown Dubai Buj Khalifa Dubai Mall Metro Station Dubai Mall Studio 1 45.33 1563000.00 34480.48 null null 1 1 0
1-11-2016-12451 Sales Sell 24-10-2016 Unit Office Commercial Existing Properties Al Thanyah Fifth PLATINUM TOWER 505 PLATINUM TOWER Jumeirah Lakes Towers Sports City Swimming Academy Jumeirah Lakes Towers Marina Mall Office 1 98.27 1210000.00 12313.02 null null 1 1 0
1-11-2010-10416 Sales Sell 01-07-2010 Unit Shop Commercial Existing Properties Marsa Dubai PANORAMIC null Dubai Marina Sports City Swimming Academy Jumeirah Beach Residency Marina Mall Shop 1 69.96 2500000.00 35734.71 null null 1 1 0
1-11-2006-187 Sales Sell 13-02-2006 Building Commercial Existing Properties Al Mararr null Dubai International Airport Palm Deira Metro Stations Dubai Mall 0 290.23 9600000.00 33077.21 null null 1 1 0
2-110-2011-1757 Mortgages Lease to Own Registration 27-07-2011 Unit Office Commercial Existing Properties Business Bay ASPECT TOWER null Business Bay Burj Khalifa Business Bay Metro Station Dubai Mall Office 1 184.32 2430000.00 13183.59 2430000.00 13183.59 2 2 2
1-11-2021-4538 Sales Sell 22-03-2021 Land Other Existing Properties Nad Al Shiba Third null Nad Al Shiba Villas Creek Metro Station City Centre Mirdif 0 469.20 2398000.00 5110.83 null null 1 1 0
1-11-2009-1995 Sales Sell 04-11-2009 Villa Commercial Existing Properties Al Thanayah Fourth null Meadows 4 Sports City Swimming Academy Damac Properties Marina Mall 0 590.58 3790888.00 6418.92 null null 1 1 0
2-13-2011-31 Mortgages Mortgage Registration 03-01-2011 Villa Commercial Existing Properties Al Thanayah Fourth null Meadows 4 Sports City Swimming Academy Damac Properties Marina Mall 0 618.73 3150000.00 5091.07 null null 1 1 0
1-102-2010-3176 Sales Sell - Pre registration 15-12-2010 Unit Office Commercial Off-Plan Properties Al Thanyah Fifth JUMEIRA Business Center 2 7 JUMEIRAH BUSINESS CENTRE2 Jumeirah Lakes Towers Burj Al Arab Damac Properties Marina Mall Office 1 126.26 813756.00 6445.08 null null 1 1 0
Counting matches
Counting matches
qsv search 'Residential' -c -s 'property_usage_en' 'DLD_Transactions_English.csv'
This command counts how many rows have 'Residential' in the 'property_usage_en' column.
Sample Output:
1081
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
2-14-2013-878 Mortgages Modify Mortgage 21-11-2013 Building Agricultural Existing Properties Wadi Al Amardi null City Centre Mirdif 0 24535.12 17100000.00 696.96 null null 1 1 0
1-11-2005-800 Sales Sell 21-03-2005 Land Agricultural Existing Properties Tawi Al Muraqqab null 0 147192.26 6000000.00 40.76 null null 1 1 0
1-11-2000-765 Sales Sell 20-11-2000 Land Agricultural Existing Properties Al Ruwayyah null IMG World Adventures 0 30126.77 400000.00 13.28 null null 1 1 0
1-11-2013-4113 Sales Sell 11-02-2013 Building Agricultural Existing Properties Wadi Al Amardi null City Centre Mirdif 0 9399.74 8000000.00 851.09 null null 11 1 0
2-13-2008-2759 Mortgages Mortgage Registration 17-11-2008 Land Agricultural Existing Properties Wadi Al Amardi null Etisalat Metro Station City Centre Mirdif 0 62778.46 61340000.00 977.09 null null 2 1 0
2-13-2009-1209 Mortgages Mortgage Registration 02-07-2009 Villa Agricultural Existing Properties Wadi Al Amardi null City Centre Mirdif 0 30099.64 35638845.00 1184.03 null null 1 1 0
2-14-2018-610 Mortgages Modify Mortgage 05-06-2018 Building Agricultural Existing Properties Wadi Al Amardi null City Centre Mirdif 0 74622.48 20000000.00 268.02 null null 1 1 0
2-14-2015-1024 Mortgages Modify Mortgage 21-09-2015 Building Agricultural Existing Properties Wadi Al Amardi null Rashidiya Metro Station City Centre Mirdif 0 115512.43 42000000.00 363.60 null null 1 1 0
1-4-2008-25 Sales Adding Land By Sell 14-08-2008 Villa Agricultural Existing Properties Al Lusaily null 0 10039.84 864544.00 86.11 null null 1 0 0
1-11-2005-1349 Sales Sell 24-05-2005 Land Agricultural Existing Properties Tawi Al Muraqqab null 0 147192.26 7000000.00 47.56 null null 1 1 0
Using regular expressions
Using regular expressions
qsv search '^[1-9][0-9]{0,2}(,[0-9]{3})*(.[0-9]+)?$' -s 'actual_worth' 'DLD_Transactions_English.csv' \
| qsv sample 10 \
| qsv table
This command finds all rows where the 'actual_worth' column contains a number with 6 or more digits (excluding leading zeros), samples 10 rows from the results, and displays them in a table format.
Sample 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
1-102-2016-6365 Sales Sell - Pre registration 30-05-2016 Unit Flat Residential Off-Plan Properties Al Barshaa South Third AL MADAR SIRAJ TOWER 181 SIRAJ TOWER Arjan Motor City Sharaf Dg Metro Station Mall of the Emirates Studio 1 13.38 67.00 5.05 null null 2 1 0
3-9-2017-1818 Gifts Grant 20-09-2017 Unit Flat Residential Existing Properties Al Warsan First EMR-07 1288 INTERNATIONAL CITY EMARATI International City Phase 1 Rashidiya Metro Station City Centre Mirdif 1 B/R 0 32.23 208.00 6.46 null null 1 1 0
1-133-2023-255 Sales Development Registration 23-06-2023 Unit Office Commercial Existing Properties Nadd Hessa PALACE TOWERS T1 213 PALACE TOWER Silicon Oasis IMG World Adventures Office 1 147.77 100.00 0.68 null null 1 1 0
1-110-2021-80 Sales Lease to Own Registration 15-02-2021 Villa Residential Existing Properties Hadaeq Sheikh Mohammed Bin Rashid 1727 SIDRA DUBAI HILLS - SIDRA 1 Motor City First Abu Dhabi Bank Metro Station Mall of the Emirates 0 576.62 1.00 0.00 null null 2 2 2
3-9-2016-49 Gifts Grant 12-01-2016 Unit Flat Residential Existing Properties Al Thanyah Fifth SABA 3 464 SABA TOWER 3 Jumeirah Lakes Towers Burj Al Arab Marina Mall Metro Station Marina Mall Studio 1 14.14 266.00 18.85 null null 1 1 0
1-102-2008-44637 Sales Sell - Pre registration 27-04-2009 Unit Flat Residential Off-Plan Properties Wadi Al Safa 2 MAZAYA 27 1221 QPOINT LIWAN-PLOT R068 Liwan IMG World Adventures 1 B/R 1 60.53 651.00 10.76 null null 1 1 0
3-9-2020-2209 Gifts Grant 30-11-2020 Building Residential Existing Properties Al Jafliya null Burj Khalifa Al Jafiliya Metro Station Dubai Mall 0 25.22 428.00 16.98 null null 2 1 0
2-13-2023-9101 Mortgages Mortgage Registration 31-05-2023 Unit Flat Residential Existing Properties Al Hebiah Fourth EAGLE HEIGHTS 712 EAGLE HEIGHTS Dubai Sports City Sports City Swimming Academy Nakheel Metro Station Marina Mall 1 B/R 1 74.02 416.00 5.62 null null 1 1 0
1-41-2017-3204 Sales Delayed Sell 22-05-2017 Villa Residential Existing Properties Al Yufrah 3 1647 DAMAC HILLS (2) - PACIFICA DAMAC HILLS 2 Dubai Cycling Course 0 174.80 251.00 1.44 null null 1 1 0
1-11-2022-24084 Sales Sell 04-10-2022 Unit Flat Residential Existing Properties Al Barsha South Fourth BELGRAVIA 2 1820 Belgravia 2 Jumeirah Village Circle Sports City Swimming Academy Nakheel Metro Station Marina Mall Studio 1 46.95 220.00 4.69 null null 1 1 0
These interactive examples demonstrate various ways to use the search command in qsv. You can adjust the parameters to explore different search scenarios on your dataset.