{"id":3402,"date":"2020-01-10T08:53:09","date_gmt":"2020-01-10T03:23:09","guid":{"rendered":"http:\/\/reliablesoftwares.com\/blog\/?p=3402"},"modified":"2020-01-04T09:38:09","modified_gmt":"2020-01-04T04:08:09","slug":"xsv-command-line-too-to-use-csv-files-like-tables","status":"publish","type":"post","link":"https:\/\/reliablesoftwares.com\/blog\/xsv-command-line-too-to-use-csv-files-like-tables\/","title":{"rendered":"xsv command line too to use csv files like tables"},"content":{"rendered":"

\"\"<\/a>xsv is a command-line program for indexing, slicing, analyzing, splitting and joining<\/strong> CSV files. Commands should be simple, fast and composable. I was sold on joining, you can use 2 csv file and do a join as you do on a table.<\/p>\n

Installation<\/h3>\n

Binaries for Windows, Linux and macOS are available\u00a0from Github<\/a>.<\/p>\n

If you’re a\u00a0macOS Homebrew<\/strong>\u00a0user, then you can install xsv from homebrew-core:<\/p>\n

$ brew install xsv\r\n<\/code><\/pre>\n
If you’re a\u00a0macOS MacPorts<\/strong>\u00a0user, then you can install xsv from the\u00a0official ports<\/a>:<\/p>\n
$ sudo port install xsv\r\n<\/code><\/pre>\n
If you’re a\u00a0Nix\/NixOS<\/strong>\u00a0user, you can install xsv from nixpkgs:<\/p>\n
$ nix-env -i xsv<\/code><\/pre>\n
For example and tutorial check out\u00a0https:\/\/github.com\/BurntSushi\/xsv<\/a>. also, check out https:\/\/www.johndcook.com\/blog\/2019\/12\/31\/sql-join-csv-files\/<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"
xsv is a command-line program for indexing, slicing, analyzing, splitting and joining CSV files. Commands should be simple, fast and<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","_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":"","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},"categories":[1],"tags":[704,705,706],"class_list":["post-3402","post","type-post","status-publish","format-standard","hentry","category-article","tag-csv","tag-join","tag-xsv"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pgLsB5-SS","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":503,"url":"https:\/\/reliablesoftwares.com\/blog\/how-to-load-game-from-usb-for-wii\/","url_meta":{"origin":3402,"position":0},"title":"How to load game from usb for Wii","author":"saifuddin","date":"January 26, 2012","format":false,"excerpt":"This is just for educational purpose. This work only after\u00a0Homebrew Channel is install, for\u00a0instruction\u00a0on how to install Homebrew Channel click here. You will require 2 softwares: 1.Download USB Loader GX (2.0 r1037) from\u00a0HERE 2. WBFS Manager from\u00a0HERE. (64-bit version of WBFS Manager,\u00a0download from\u00a0HERE; if you need MAC download\u00a0HERE. ) \u00a0\u2026","rel":"","context":"In "Miscellaneous"","block_context":{"text":"Miscellaneous","link":"https:\/\/reliablesoftwares.com\/blog\/category\/miscellaneous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/wp-content\/uploads\/2012\/01\/wii-usb-loader-300x225.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3630,"url":"https:\/\/reliablesoftwares.com\/blog\/the-ultimate-ai-prompt-engineering-guide-turn-anyone-into-a-power-user\/","url_meta":{"origin":3402,"position":1},"title":"The Ultimate AI Prompt Engineering Guide: Turn Anyone into a Power User","author":"saifuddin","date":"September 16, 2025","format":false,"excerpt":"Artificial Intelligence is only as powerful as the prompts you feed it. Whether you\u2019re chatting with ChatGPT, Claude, Gemini, or local open-source models, the real skill lies not in the tool itself\u2014but in how you communicate with it. This guide will walk you through prompt engineering fundamentals, platform-specific tips, advanced\u2026","rel":"","context":"In "AI"","block_context":{"text":"AI","link":"https:\/\/reliablesoftwares.com\/blog\/category\/blog\/ai\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai.jpg?fit=1024%2C1024&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai.jpg?fit=1024%2C1024&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai.jpg?fit=1024%2C1024&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":2975,"url":"https:\/\/reliablesoftwares.com\/blog\/youtube-vanced-with-background-play-dark-mode-and-no-ads-for-android\/","url_meta":{"origin":3402,"position":2},"title":"‘YouTube Vanced’ with background play, Dark Mode, and No ads for Android","author":"saifuddin","date":"August 14, 2018","format":false,"excerpt":"Number one reason I love modified YouTube Vanced is the ability to play even when the app is in the background. Sometimes you use youtube to only listen to things or while watching a video you just need that few seconds to reply to a message and you don't want\u2026","rel":"","context":"In "App"","block_context":{"text":"App","link":"https:\/\/reliablesoftwares.com\/blog\/category\/blog\/app\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2018\/07\/YouTube-Vanced.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3004,"url":"https:\/\/reliablesoftwares.com\/blog\/audacious-an-open-source-audio-player\/","url_meta":{"origin":3402,"position":3},"title":"Audacious an open source audio player","author":"saifuddin","date":"September 4, 2018","format":false,"excerpt":"A descendant of\u00a0XMMS, Audacious plays your music how you want it, without stealing away your computer\u2019s resources from other tasks. Drag and drop folders and individual song files, search for artists and albums in your entire music library, or create and edit your own custom playlists. Listen to CD\u2019s or\u2026","rel":"","context":"In "App"","block_context":{"text":"App","link":"https:\/\/reliablesoftwares.com\/blog\/category\/blog\/app\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2018\/08\/audacious3.1.png?fit=460%2C298&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3625,"url":"https:\/\/reliablesoftwares.com\/blog\/chatgpt-locally-for-free-the-complete-ollama-guide-2024\/","url_meta":{"origin":3402,"position":4},"title":"ChatGPT Locally for FREE: The Complete Ollama Guide (2024)","author":"saifuddin","date":"September 14, 2025","format":false,"excerpt":"Imagine having a ChatGPT-like AI assistant running on your computer, completely offline, with no monthly fees or data privacy concerns. It sounds too good to be true, but it's not only possible\u2014it's surprisingly easy to set up. Meet Ollama, the open-source tool that's revolutionizing how we interact with AI by\u2026","rel":"","context":"In "Article"","block_context":{"text":"Article","link":"https:\/\/reliablesoftwares.com\/blog\/category\/article\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/images.png?fit=243%2C207&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1529,"url":"https:\/\/reliablesoftwares.com\/blog\/swiftkey-keyboard-one-best-android-keyboard\/","url_meta":{"origin":3402,"position":5},"title":"SwiftKey Keyboard one of the best Android keyboard","author":"saifuddin","date":"February 5, 2015","format":false,"excerpt":"In Android you could choose to install any keyboard you like. The current default keyboard with Lollipop is quit good. Still it cannot be as compared\u00a0to SwiftKey yet. SwiftKey is quite easy to use and once you give access to your google account, it can learn from your writing pattern\u2026","rel":"","context":"In "App"","block_context":{"text":"App","link":"https:\/\/reliablesoftwares.com\/blog\/category\/blog\/app\/"},"img":{"alt_text":"swiftkey","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/02\/swiftkey-150x148.jpg?resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/3402","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/comments?post=3402"}],"version-history":[{"count":3,"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/3402\/revisions"}],"predecessor-version":[{"id":3406,"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/3402\/revisions\/3406"}],"wp:attachment":[{"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/media?parent=3402"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/categories?post=3402"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/tags?post=3402"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}