10
Firstly, can you even open the Csvs? If you can then Power Bi Desktop by Microsoft is the emerging goto for data visualisation
Yes, no problem reading the CSVs, sorry if that wasn't clear.
I was looking for something more specific. Ideally something like a local web app that renders the posts, comments,... in a webpage with thumbnails and links to reddit elements.
But that's probably asking too much :).
Thanks for the suggestion!
If you find one, let me know pretty please...
I found a UI for my Hangouts data a while back, occasionally skim through those old chats once in a while. It's nice to have a tool that visualises data request files in a user friendly way
I'm searching on github different CSV filenames and I found a couple of projects that may be relevant:
-
humandataincome/hudi-packages-connectors: hudi-packages-connectors is a library that provides a toolset to parse and extract relevant information from the personal data sources provided by major websites or social networks.
-
d4data-official/archive-lib: Standardize GDPR data archives from various providers.
EDIT: This one also looks interesting:
- karlicoss/HPI: Human Programming Interface ๐ง๐ฝ๐ค
I'm still trying to figure out how to use them.
Those first two look interesting - thanks!
Power Query can search line by line without loading a file much bigger than your RAM.
The links you posted are weird:
-
https://pixeldrain.com/u/KfgV7bqn: It offers to download a file with the name
Antimutt in r-Excel ultra.paq8owhich I have no idea what is for. -
https://the-eye.eu/redarcs: It says "This Reddit Community Has Been Archived"
The first is the result when I extracted all lines with my nick in them from the csv, stored with the best compression around. The second is where to get the csv - and a lot of communities have been archived there, like it says.
Just to confirm I understand: you are talking about Power Query VS Power Bi for dealing with huge datasets, right?
Because, in my case, with 16Mb, I don't see the need for anything specially powerful. My problem is not performace, but convenience.
Thanks for the input.
Power Query is a component of Excel and Power BI.
this post was submitted on 12 Aug 2023
10 points (91.7% liked)
16744 readers
293 users here now
News and Discussions about Reddit
Welcome to !reddit. This is a community for all news and discussions about Reddit.
The rules for posting and commenting, besides the rules defined here for lemmy.world, are as follows:
Rules
Rule 1- No brigading.
**You may not encourage brigading any communities or subreddits in any way. **
YSKs are about self-improvement on how to do things.
Rule 2- No illegal or NSFW or gore content.
**No illegal or NSFW or gore content. **
Rule 3- Do not seek mental, medical and professional help here.
Do not seek mental, medical and professional help here. Breaking this rule will not get you or your post removed, but it will put you at risk, and possibly in danger.
Rule 4- No self promotion or upvote-farming of any kind.
That's it.
Rule 5- No baiting or sealioning or promoting an agenda.
Posts and comments which, instead of being of an innocuous nature, are specifically intended (based on reports and in the opinion of our crack moderation team) to bait users into ideological wars on charged political topics will be removed and the authors warned - or banned - depending on severity.
Rule 6- Regarding META posts.
Provided it is about the community itself, you may post non-Reddit posts using the [META] tag on your post title.
Rule 7- You can't harass or disturb other members.
If you vocally harass or discriminate against any individual member, you will be removed.
Likewise, if you are a member, sympathiser or a resemblant of a movement that is known to largely hate, mock, discriminate against, and/or want to take lives of a group of people, and you were provably vocal about your hate, then you will be banned on sight.
Rule 8- All comments should try to stay relevant to their parent content.
Rule 9- Reposts from other platforms are not allowed.
Let everyone have their own content.
:::spoiler Rule 10- Majority of bots aren't allowed to participate here.
founded 1 year ago
MODERATORS