Aotearoa Weekly Kōrero 26/6/2024
Aotearoa Weekly Kōrero 26/6/2024
Welcome to this week’s casual kōrero thread!
This post will be pinned in this community so you can always find it, and will stay for about a week until replaced by the next one.
It’s for talking about anything that might not justify a full post. For example:
- Something interesting that happened to you
- Something humourous that happened to you
- Something frustrating that happened to you
- A quick question
- A request for recommendations
- Pictures of your pet
- A picture of a cloud that kind of looks like an elephant
- Anything else, there are no rules (except the rule)
So how’s it going?
I thought I'd better post an update about the Lemmy.nz census. I have been working on analysing the data and writing a post, but there's probably still a while before I'll be done. There's quite a lot to get through.
Also, if anyone knows any good tools for generating graphs then let me know! I'm using LibreOffice Calc as an excuse to learn how to use it, and it's graphs aren't that great. I can break out Excel if I have to but to be fair Excel graphs aren't much better.
You could do this with python and a couple of libraries. This is just an example, but you could import the data from a DB or use a CSV file.
import matplotlib.pyplot as plt import numpy as np # Pie chart data labels = ['Category A', 'Category B', 'Category C', 'Category D', 'Category E'] sizes = [30, 25, 20, 15, 10] colors = ['#ff9999','#66b3ff','#99ff99','#ffcc99','#c2c2f0'] # Pie chart plt.figure(figsize=(8, 8)) plt.pie(sizes, labels=labels, colors=colors, autopct='%1.1f%%', startangle=140) plt.title('Sample Pie Chart') plt.axis('equal') # Equal aspect ratio ensures that pie is drawn as a circle. plt.show() # Histogram data data = np.random.normal(0, 1, 1000) # Generate 1000 random data points with a normal distribution # Histogram plt.figure(figsize=(10, 6)) plt.hist(data, bins=30, color='#66b3ff', edgecolor='black') plt.title('Sample Histogram') plt.xlabel('Value') plt.ylabel('Frequency') plt.show()Ooh thanks! I'll definitely have a play with this. What's the step before this? Is it as simple as installing python, putting the code in somefile.py, then running it?
Just roll with the LibreCalc charts.
It's the data that's important, perfectly rendered gradients on histogram bars is less important.
Mainly I don't like that the pie charts are hard to tell what is what. If there are 6 or 7 things and you have to tell which is which by colour, that's a bit tricky. Labels on the sections would be better, but I haven't worked out how to do that.
Maybe if I think a pie chart shows it best, I'll also include the bar chart so it's clearer.
I'm curious, can we have something like automation in LibreOffice? I mean like in VBA, where I can pull data and export excel charts.
LibreOffice Calc supports its own macro language as well as a subset of VBA! I recently converted an Excel macro to LibreOffice and it wasn't too painful.
Fudge, I forgot to complete it! I got halfway through and started having an existential crisis about my identity ha ha and thought I'll come back later and fix this.
Well in you hop then, while I'm sorting out how to do graphs. I've removed the expiry so you can finish your submission.
Anyone else can hop in too if you haven't done it, as long as you're quick 🙂
https://survey.lemmy.nz/index.php/493338?lang=en