qsv
fortune-sheet
qsv | fortune-sheet | |
---|---|---|
13 | 11 | |
2,228 | 2,174 | |
- | 1.5% | |
9.9 | 8.1 | |
6 days ago | 7 days ago | |
Rust | TypeScript | |
The Unlicense | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
qsv
- FLaNK Weekly 31 December 2023
-
Qsv: Efficient CSV CLI Toolkit
Thanks for the detailed feedback @snidane!
As maintainer of qsv, here's my reply:
- Given qsv's rapid release cycle (173 releases over three years), the auto-update check is essential at the moment. Once we reach 1.0, I'll turn it off. For now, given your feedback, I've only made it check 10% of the time.
- Pivot is in the backlog and I'll be sure to add unpivot when I implement it. (https://github.com/jqnatividad/qsv/issues/799)
- I'll add a dedicated summing command with the group by (-by) and window by (-over) capability (https://github.com/jqnatividad/qsv/issues/1514). Do note that `stats` has basic sum as @ezequiel-garzon pointed out.
- With the `enum` command, qsv can achieve what you proposed with `laminate`. E.g. qsv enum --new-column newcol --constant newconstant mydata.csv --output laminated-data.csv
- With the cat rowskey command, qsv can already concatenate files with mismatched headers.
- other file formats. qsv supports parquet, csv, tsv, excel, ods, datapackage, sqlite and more (see https://github.com/jqnatividad/qsv/tree/master#file-formats). Fixed-format though is not supported yet and quite interesting, and have added it to the backlog (https://github.com/jqnatividad/qsv/issues/1515)
- as to "enable embedding outputs of commands", qsv is composable by design, so you can use standard stdin/stdout redirection/piping techniques to have it work with other CLI tools like jq, awk, etc.
Finally, just released v0.120.0 that already incorporates the less aggressive self-update check. https://github.com/jqnatividad/qsv/releases/tag/0.120.0
- Joining CSV Data Without SQL: An IP Geolocation Use Case
-
Why my favourite API is a zipfile on the European Central Bank's website
qsv [1] also has a sqlp command which lets you run Polars SQL queries (even on multiple files). Here I'll send the csv data from stdin (represented by -) and then (optionally) pipe the output to the table command for formatting. The shape of the result is also printed to stderr (the (4, 2) below).
[1] https://github.com/jqnatividad/qsv
$ echo 'Name,Department,Salary
- Qsv: Ultra-fast CSV data-wrangling toolkit
- Qsv: CSVs sliced, diced and analyzed (fork of xsv)
- Nushell.sh ls – where size > 10mb – –sort-by modified
-
Do Rust and Lua work well together?
It works quite well IMHO. Using the mlua crate, I’ve managed to integrate Luau as a very powerful data-wrangling DSL for qsv (https://github.com/jqnatividad/qsv)
-
How manipulate this CSV in Python?
Maybe this might be better done using this? https://github.com/jqnatividad/qsv
-
How to convert xslx to csv using Rust?
https://github.com/jqnatividad/qsv is another option.
fortune-sheet
-
REACTJS and Excel Data
Exactly, here is one: https://github.com/ruilisi/fortune-sheet/
-
Which spreadsheet program do you guys use? (even if it's not emacs related)
Microsoft Excel (web version), have been reconsider using it and replace it with fortune-sheet (a project I recently came across).
-
I created an Excel-like React spreadsheet with collabration support
I posted this project to r/reactjs a couple of weeks a ago and received many feedbacks. It's more refined now and I would like share with r/webdev too! It's like Google Sheets, and completely open source. Github: https://github.com/ruilisi/fortune-sheet Live Demo: https://ruilisi.github.io/fortune-sheet-demo BTW, one thing to be mentioned is that in the collabration demo, I didn't use any OT or CRDT algorithms to ensure all clients are strictly synchronized. There're chances that one client make changes that collides with another client (e.g. editing the same cell), and result in different state. Any ideas of improving this?
- Show HN: A drop-in Excel-like spreadsheet library with collabration support
-
Creating collabrative javascript spreadsheet made easy
In the last post, we have introduced how to create a javascript spreadsheet using FortuneSheet. This time, we will show you how to enable it's collabration feature.
- I created a new Excel-like spreadsheet component for React with collabration support
- Create Excel-like javascript spreadsheet in less than 10 lines of code
- I created an Excel-like spreadsheet library for React with collabration support
- FortuneSheet - Rich-featured online spreadsheet library for React
-
Any replacement of Luckysheet
Take a look at FortuneSheet https://github.com/ruilisi/fortune-sheet
What are some alternatives?
miller - Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON
MUI X - MUI X is a collection of advanced React UI components for complex use cases. Use the native integration with Material UI or extend your design system. They feature state-of-the-art functionality and complex UX workflows for data-rich applications and support a wide range of use cases. MUI X is open core—base components are MIT-licensed, while more advanced features require a Pro or Premium commercial license. Components: - Data Grid - Date and Time Pickers - Charts - Tree View
calamine - A pure Rust Excel/OpenDocument SpreadSheets file reader: rust on metal sheets
ReactGrid - Add spreadsheet-like behavior to your React app
tsv-utils - eBay's TSV Utilities: Command line tools for large, tabular data files. Filtering, statistics, sampling, joins and more.
Luckysheet - Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
csvquote
revo-grid - Powerful virtual data grid smartsheet with advanced customization. Best features from excel plus incredible performance 🔋
goawk - A POSIX-compliant AWK interpreter written in Go, with CSV support
react-select - The Select Component for React.js
ess-view-data - View data support for ESS
univer - Univer is an open-source alternative to Google Sheets, Slides, and Docs