jq vs pandas

jq

7.3 #6 in JSON Tools

About jq

pandas

6.5 #12 in Data Transformation Tools

About pandas
jqpandas
Free planYesNo
Free trialNoNo
Paid fromFree—
Open sourceNoNo
PlatformsLinux, macOS, self-hosted, Web, WindowsWindows, macOS, Linux
Free planYes—
Deployment model—self_hosted
Transformation interface—code
Supported data formats—CSV, delimited text, fixed-width text, clipboard, Excel, OpenDocument, JSON, HTML, XML, LaTeX, HDF5, Feather, Parquet, Apache Iceberg, ORC, SQL, Google BigQuery, Stata, SAS, SPSS, Python Pickle
Data quality checks—Yes

Both are listed in Best Data Transformation Tools. On Samsung Mobile US Press, jq scores higher on our published basis.