{"id":28240,"date":"2017-11-23T10:55:36","date_gmt":"2017-11-23T08:55:36","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=28240"},"modified":"2017-11-23T10:55:36","modified_gmt":"2017-11-23T08:55:36","slug":"querying-csv-with-sql","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2017\/11\/23\/querying-csv-with-sql\/","title":{"rendered":"Querying CSV with SQL"},"content":{"rendered":"\n

Excel is not the only tool available when it comes working with CSV files.\u00a0 I have previously mentioned TextQL<\/a> (here<\/a>).\u00a0 Yesterday, I tried another tool, called “q”.\u00a0 But since searching for “q” is not very effective, it’s also known “q text as data<\/a>“.<\/p>\n

For those using Fedora, you can install it by simply running “dnf install q-text-as-data<\/em>“.\u00a0\u00a0 Here’s an example of how it works:<\/p>\n

\r\n$ q-text-as-data -H -d ',' "SELECT COUNT(DISTINCT(Project)) FROM deploy.csv"\r\n95\r\n<\/pre>\n
In the above example, I’m querying the deploy.csv<\/em> file, which is in the current folder. q supports both command and tab separated values, so I’m helping it out with the “-d ‘,’<\/em>” parameter, saying that this particular one is a CSV. “-H<\/em>” tells q that the first row in this file is used for headers. CSV files with headers are more convenient, as you can use headers as column names, instead of numerical indexes.<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n
Excel is not the only tool available when it comes working with CSV files.\u00a0 I have previously mentioned TextQL (here).\u00a0 Yesterday, I tried another tool, called “q”.\u00a0 But since searching for “q” is not very effective, it’s also known “q text as data“. For those using Fedora, you can install it by simply running “dnf … Continue reading Querying CSV with SQL<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Querying CSV with SQL #SQL #CSV #WebDev #stats #databases #CLI","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,6,18,62,1334],"tags":[1960,3510,1559,2351,773,1330],"keyring_services":[],"class_list":["post-28240","post","type-post","status-publish","format-standard","hentry","category-general","category-linux","category-programming","category-technology","category-web-work","tag-command-line","tag-csv","tag-databases","tag-fedora-linux","tag-sql","tag-web-development"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t