Skip to main content
Home GrN.dk

Main navigation

  • Contact
  • Your Digital Project Manager
  • About Greg Nowak
  • Services
  • Portfolio
  • Container
    • Excel Freelancer
    • Kubuntu - tips and tricks
    • Linux Apache MySQL and PHP
    • News
    • Image Gallery

CSV Kit Notes Tips and Examples

Nice thing to use when working with CSV-files is CSV Kit.

See the file statistics: csvstat -e UTF-16 test.csv

Merge all files in a folder: csvstack -e UTF-16 -t *.csv > all.csv

Save column 2 to output .csv: csvcut -c 2 -e UTF-8 all.csv > output.csv

Remove duplicates:

Sort the file first: sort -n output.csv > sorted.csv

Save only unique values: uniq -u sorted.csv > unique.csv

 

 

 

 

 

Last modified
2017-06-13
Tags
Linux
csv
Data
  • Log in to post comments

Review Greg on Google

Greg Nowak Google Reviews

 

Search

Recent content

  • Scraping Tools And Browser Automation
  • Portfolio
  • Drupal Commerce
  • Webshop systems
  • Drupal 9
More

Tag Cloud

gregmanagementwebshopBusiness IntelligencecronFile TransferVBAphpveganismcrontabbootmobileWebDesignExportstockgrzegorzwordpressViby J.DatascienceMigratejobprogrammingevidencelogisticsnotechiang maiAsiaLinuxScriptcustomerCaptureprojectpythonTravelingaqireviewtext recognitionMusicnowakhealthvillaMicrosoftAndroidDrushHardwarescrapingexcelSportcvkøbDrupal 8Visual BasicDrupal 7WindowsfoodFreefacebookGPSplantveganrestaurantsdocumentationSmartphonerscriptfreelancerAudioThemesInvestbackupdevelopmentThailandDashboardgraphicshostingStatisticsr-projectyoutubecurriculum vitaeeconomicsgoogledownloadsalgVideoseoservertradingroutescyclingImportoptimizationEcommercecsvTechblogGarminmailrstudiosælgspreadsheetsprogramming, javaDrupal

GrN.dk web platforms, web optimization, data analysis, data handling - CSV files, spreadsheets Excel, and logistics.