Our great sponsors
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
Quite useful summary I must admit. I have myself written a few navi cheatsheets of awk/sed that I regularly use and I found that they sped up my work consistently (however we want to turn it around awk grammar is pretty hard to remember...).
I even opened some merge requests to have them included in the official navi repository but they weren't looked at ever.
xsv is the best command line interface to query csv files. If you aren't using it you should stop what you are doing right now and install it immediately :)
And sometimes it's nice to throw csv files into a database. You can do that with https://github.com/simonw/csvs-to-sqlite
Related posts
- Show HN: TextQuery – Query and Visualize Your CSV Data in Minutes
- OpenOffice. Necesito ver una hoja de cálculo que tiene 6 millones de columnas, pero no puedo
- A fast SQLite PWA notebook for CSV files
- Show HN: Work with CSV files using SQL. For data scientists and engineers
- Joining CSV Data Without SQL: An IP Geolocation Use Case