GUESS WHAT GUESS WHAT GUESS WHAT!!!! The next version of Excel will have auto-updating pivot tables!!!

https://www.pcworld.com/article/2862319/microsoft-finally-fixes-the-worst-thing-about-excels-pivot-tables.html

#Excel #PivotTables #DataNerds

I have just updated my project on the veteran trees in Italy:

http://trovawiki.altervista.org/alberi_monumentali.php

I (re)used the dataset which was released by the Italian Ministry. You can browse the catalogue by species and province.
I also added some statistics and figures for #datanerds :)

🌲 🌳 🍃 🍁 🍂 🌴

#trees #nature #opendata #maps #veterantrees

🚗⚡ Curious about EV chargers, alternative fuels, and the real power of pivot tables? I sat down with @podfeet to explore the U.S. Department of Energy’s treasure trove of data on EVs and chargers. 🤓 Dive in with us! #EVs #DataNerds #KilowattPodcast

https://shows.acast.com/kilowatt/episodes/ev-data-made-fun-with-allison-sheridan

I was delighted at work today to discover that the computer system documentation template I'm filling out uses ISO 8601 date format on the cover sheet. Hooray! I'm extending that by using it in the version history table.

#ISO8601 #DataNerds

Sometimes I love data analysis. Occasionally though, the data is capable of evoking a state of grief... so here's some of that type for other #datanerds. Climate change is real, obviously.

*"Our World in Data"*
- https://ourworldindata.org/energy
- https://github.com/owid/co2-data
- https://github.com/owid/energy-data
- https://gml.noaa.gov/webdata/ccgg/trends/co2/co2_mm_mlo.txt

#ClimateChange #CO2 #PPM #GreenhouseGas #NOAA #Analytics #Data

The drive from Galway to Waterford is my go to time for catching up on #podcasts .This one is a takedown of #freakonomics.

Kind of sad nobody got to witness the faces I was making as they read some of the passages.

A good example of how data can be manipulated to further a particular agenda. Or where its interpretation relies on bias.

Recommended to all #datanerds out there.

#ifbookscouldkill #statsadon

https://open.spotify.com/episode/5wHpooGMRsSBrUHhQZbOZp?si=53aVUOQsSjGQdhAn_q1rag&utm_source=copy-link

Hey #dataNerds 🤓, good news:

#DuckDB v0.6.0 brings reading #CSV data on par with #PyArrow & #Polars and loads 1.66 GB of #ChicagoCrimes data in 1.9s with 12 cores/24 threads when experimental parallel CSV reader & unordered insertion are enabled.

🧐 https://github.com/RandomFractals/chicago-crimes#with-duckdb

#dataTools 🔬 ...