#pandas
#python #pandas #lessonlearned today: (1) Merge does not preserve the order unless you are merging by the index. (2) Make sure to use `ignore_index=True` when you concat or your index might acquire duplicates. Want to hear how much fun I had #debugging to come up with these gems of wisdom? 😂 #pythonprogramming
Pretty useful, thanks Luke Gloege https://towardsdatascience.com/xarray-recipes-for-earth-scientists-c12a10c6a293 #dataAnalysis #climatology #xarray #matplotlib #pandas #fediscience
We have a new version of the data visualization tutorials written in #Python using #Pandas and #Altair:
https://infovis.fh-potsdam.de/tutorials/
The first tutorials lay the foundation, after which common data types are treated in 3 steps:
🛒 Prepare → 🥒 Process → 🥗 Present
If you have any ideas or suggestions for improvement, or if you're using these tutorials in your own teaching (or learning!), I'd love to hear about it. Many thanks already to @ikyriazi for lots of feedback on this revision!
Spent entirely too long to make this chart.
1) I exported data from my #Gqueues task manager app to csv
2) spent many hours with #python #pandas to massage the data into something the bar chart function can use
3) spent more hours customizing the chart to make it somewhat legible
4) there is some data cleanup to do
I've hidden the category/colors legend in this chart to keep personal stuff safe, but each of the colors represents a different priority in my life.

Latest COVID-19 children (0-19 year) deaths for England - 219.
Last updated on 27/05/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics


Deaths within 28 days for COVID-19 in England
Weekly deaths = 320
7-day average = 45
Last updated on 2023-06-01
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas


I am so impressed how easy it is to get beautiful charts with #Python, #Pandas and #Matplotlib together with some well designed database queries. Marvelous.
La implementación del AD8232 de Sparkfun es una solución comercial, pensaba que no daría ese ruido de 50Hz. He tenido que aplicar un pos-procesado con un filtro pasa bajas.

Latest COVID-19 children (0-19 year) deaths for England - 218.
Last updated on 20/05/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics



Deaths within 28 days for COVID-19 in England
Weekly deaths = 355
7-day average = 50
Last updated on 2023-05-25
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas

📢 LANDING TODAY! Learn how to automate your #ACLs with #Aerleon & #Pandas 🐼! Register now over at: https://buff.ly/3NJC4AE #networkautomation #networksecurity #firewalls

CSV, JSON, or Parquet — which data file format should you use with #Pandas in #Python?
https://pythonspeed.com/articles/best-file-format-for-pandas/
⏰ Landing TOMORROW! Learn how to automate your #ACLs with #Aerleon & #Pandas 🐼! Register at: https://buff.ly/3NJC4AE #networkautomation #networksecurity #firewalls

The easiest way to use Google Sheets data in Pandas is to make the Google Sheet public, change the end of the URL to "/export?format=csv", then import the data with
df = pd.read_csv(url)
where url is of course the URL.
Here's an example:
https://colab.research.google.com/github/pbeens/Data-Analysis/blob/main/Misc/Birth-Months.ipynb
Please let me know if you found this tip useful!
Just in time for the #Horizon2020 #ECEMF consortium meeting...
🎉 Release v1.9 of the #pyam_iamc package for #scenario analysis & #dataviz
Now supporting #pandas v2.0 and fully tested on #Python v3.11...
https://github.com/iamconsortium/pyam
Last week I updated my tool for exploring your fediverse connections and added an option to download your data.
Here's a few ideas on what you can do with it.
https://stefanbohacek.com/blog/exploring-your-fediverse-connections
#dataviz #fediverse #data #python #pandas #matplotlib #tutorial
This is a neat #gis blog post about analyzing bicycles’ trajectories from a video source, mapping points from the video onto a map, and projecting those paths from the video onto the map all in #qgis with MovingPandas.
I could see this being used to analyze the paths cyclists actually take vs the infrastructure provided. Could be useful for examining bike lane design.
#geospatial #bikestodon #python #pandas #urbanplanning
https://anitagraser.com/2023/05/21/analyzing-video-based-bicycle-trajectories/
Something you'll only know, if you've done machine learning / data science in anger:
df.dropna(inplace=True) is the best thing when preparing data for training.
df.dropna(inplace=True) is the absolute worst thing when doing inference. It may "eat" recent data rows, which will turn your predictions into absolute garbage. It's hard to spot this during model verfication, because recency is rarely a factor there.
Latest COVID-19 children (0-19 year) deaths for England - 218.
Last updated on 13/05/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics

Deaths within 28 days for COVID-19 in England
Weekly deaths = 361
7-day average = 51
Last updated on 2023-05-18
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas



@PandaChronicle @GottaLaff Damn straight! LoL #Pandas
The room is packed of people listening to @datapythonista talking about pandas 2.0 at #PyConLT
Follow @pandas_dev on Mastodon!

Andy Panda - from an ad on the back cover to New Funnies 83 - Dell (Western Publishing) 1944
#AndyPanda #WalterLantz #Comics #WoodyWoodpecker #WesternPublishing #frogs #ilikefrogs #pandas #bears #walterlantznewfunnies

🚀🔒Get ready for our upcoming webinar on the 25th of May! Join Packet Coders as we dive into automating #ACLs with #Aerleon & #Pandas 🐼! From Excel to ACL! Don't miss out - register now: https://buff.ly/3NJC4AE #networkautomation

Latest COVID-19 children (0-19 year) deaths for England - 217.
Last updated on 06/05/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics

Deaths within 28 days for COVID-19 in England
Weekly deaths = 407
7-day average = 58
Last updated on 2023-05-11
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas



For the #DataScience, #FediScience and #DataCuration folks ... just released version 1.0 of **whyqd** (/wɪkɪd/) - https://whyqd.readthedocs.io/
It's curatorial toolkit intended to produce well-structured and predictable data for research analysis. Underneath is #Pandas and #Pydantic, and you get nice, readable schema #ETL #crosswalks which you can run in a CI task.
I'd appreciate your thoughts.
Tonight! Last chance to book.
Aberdeen Python User Group "Animal face-off: Pandas vs. Polars – The battle of data analysis libraries in Python" - Arturo Regalado https://pythonaberdeen.github.io/ Arturo will present a relatively new data analysis library: Pola-rs.
pandera 0.15.0 is out!
pandera allows you to define schemas for your DataFrames, tighten them with rules, and validate your data to prevent errors.
The new version ships support for pandas 2.0, bare data dtypes for schemas, default values, and more.
Install it with `pip install "pandera==0.15.0"`
More information https://github.com/unionai-oss/pandera/releases/tag/v0.15.0
Tomorrow! #Aberdeen #Python User Group "Animal face-off: #Pandas vs. Polars – The battle of data analysis libraries in Python" - Arturo Regalado https://pythonaberdeen.github.io/ Arturo will present a relatively new data analysis library: Pola-rs. #Python #DataScience #pizza #booknow
On Wednesday #Aberdeen Python User Group
"Animal face-off: Pandas vs. Polars – The battle of data analysis libraries in Python" - Arturo Regalado
https://pythonaberdeen.github.io
In this talk, Arturo will present a relatively new data analysis library: Pola-rs. The new library claims to be a lightning-fast data frame library and a substitute to the industry standard Pandas. He will provide data analysis examples and challenges to discover the use cases of each library.
#Python #DataScience #Pandas
📝 "Formato en tablas Pandas"
👤 Karina Bartolome (@karbartolome)
Pandas eat a lot, and they’re apparently not fond of washing the dishes. At least, that’s what publisher Ravensburger would have you believe in Paku Paku.
https://www.meeplemountain.com/reviews/paku-paku/
On Wednesday #Aberdeen Python User Group
"Animal face-off: Pandas vs. Polars – The battle of data analysis libraries in Python" - Arturo Regalado
https://pythonaberdeen.github.io/
In this talk, Arturo will present a relatively new data analysis library: Pola-rs. The new library claims to be a lightning-fast data frame library and a substitute to the industry standard Pandas. He will provide data analysis examples and challenges to discover the use cases of each library.
Latest COVID-19 children (0-19 year) deaths for England - 217.
Last updated on 29/04/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics

Deaths within 28 days for COVID-19 in England
Weekly deaths = 588
7-day average = 84
Last updated on 2023-05-04
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas
Next Wednesday #Aberdeen Python User Group
"Animal face-off: Pandas vs. Polars – The battle of data analysis libraries in Python" - Arturo Regalado
https://pythonaberdeen.github.io/
In this talk, Arturo will present a relatively new data analysis library: Pola-rs. The new library claims to be a lightning-fast data frame library and a substitute to the industry standard Pandas. He will provide data analysis examples and challenges to discover the use cases of each library. #Python #DataScience #Pandas
#Aberdeen Python User Group 10th May 2023
"Animal face-off: Pandas vs. Polars – The battle of data analysis libraries in Python" - Arturo Regalado https://pythonaberdeen.github.io/
In this talk, Arturo will present a relatively new data analysis library: Pola-rs. The new library claims to be a lightning-fast data frame library and a substitute to the industry standard Pandas. He will provide data analysis examples and challenges to discover the use cases of each library. #Python #DataScience #Pandas
Latest COVID-19 children (0-19 year) deaths for England - 217.
Last updated on 22/04/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics
Deaths within 28 days for COVID-19 in England
Weekly deaths = 614
7-day average = 87
Last updated on 2023-04-27
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas
🎉🆕 blog post! A Netflixstory
How to make sense of your Netflix viewing data.
➡️ https://instantiator.dev/post/netflix-history/
#netflix #tv #watch #data #visualisation #csv #jupyter #python #pandas
Latest COVID-19 children (0-19 year) deaths for England - 217.
Last updated on 15/04/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics
Deaths within 28 days for COVID-19 in England
Weekly deaths = 758
7-day average = 108
Last updated on 2023-04-20
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas
How can you see something like this and not just fall in love with pandas?
Latest COVID-19 children (0-19 year) deaths for England - 216.
Last updated on 08/04/2023
#COVID19 #python #pandas
newDeaths28DaysByDeathDateAgeDemographics
https://coronavirus.data.gov.uk/details/developers-guide/main-api#structure-metrics
Deaths within 28 days for COVID-19 in England
Weekly deaths = 775
7-day average = 110
Last updated on 2023-04-13
https://coronavirus.data.gov.uk/details/whats-new/record/4d64ce27-f18c-4908-b204-23c11da2da9c
#COVID19 #python #pandas
Noticias sobre Python y Datos de la semana, episodio 72 🐍⚙️🐼
En resumen: ¡pandas 2.0! Versiones nuevas de Polars y Great Expectations, anotando cantos de pájaros, y despidiéndome para unas breves vacaciones
https://astrojuanlu.substack.com/p/episodio-72-pandas-20
Apoya el noticiero suscribiéndote por correo 📬
¡Y sigue a @pandas_dev!
#pandas #polars #python #pydata #pycamp #noticieropythonydatos
While everyone is excited about the release #GPT-4 and similar, I am excited about #PyTorch 2 and #Pandas 2. We have come a long way in the relatively short time since I started venturing into this area. Long gone are the days of difficult-to-comprehend #deeplearning frameworks and unstable data processing due to breaking changes in pandas 0.xx :-)
🎉 Big congrats to the #pandas team with the new 2.0 release! https://pandas.pydata.org/pandas-docs/version/2.0/whatsnew/v2.0.0.html#what-s-new-in-2-0-0-april-3-2023
pandas 2.0 is out! 🎉
https://pypi.org/project/pandas/2.0.0/
Use `pip install "pandas==2.0.0"` and get it while it's hot!
Pandas v2.0 Released: https://github.com/pandas-dev/pandas/releases/tag/v2.0.0
#linux #update #foss #release #pandas #python #dataanalysis
Today is #pandas 2.0 release date, and I'm live tweeting the progress with the release: https://twitter.com/datapythonista/status/1642779019476123649
A group of #pandas is called an embarrassment.
An embarrassment of pandas.
#TermsOfVenery #AnimalGroupNames #animals #wildlife #nature #english #AnimalGroupingNouns #trivia #fun #words #mammals #bears #panda