Administered by:
Luana @luana@wetdry.worldIn a few days I’ll have a CSV/json of exported Cryptpad answers for some kind of census. Are there any open source softwares out there that make analysing these kind of stuff easier?
Instead of just like opening it on a fucking libreoffice spreadsheet or something.
Ideally it’d give me like the amount of people who selected each option on a question, same for written ones (being able to set aliases like “abcd = ABCD” and “Guix = GNU Guix” bc people can’t be consistent when answering polls), with the ability to understand comma-separated replies to those questions as if they were multiple selections on a checkbox question).
Maybe being able to generate some graphs too, but at least giving me a list with like “question1, reply1, amount” for each so I can easily make graphs myself.
@luana If you're comfy with Python, I'd use the Pandas library, which can import CSVs and JSON and stuff directly. There are lots of functions for cleaning data spreadaheet-style, then it has a pivot function that'll give you the counts you want: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.pivot.html#pandas.DataFrame.pivot
Also, KDE has LabPlot (https://labplot.kde.org/), which I've used in the past when Calc would be awkward or was missing features for visualizations. Can't give you much advice on how to use it, though, lol.