#pandas — Public Fediverse posts

#pandas (the software) should be forbidden. I will not elaborate.

We just finished another day at #EuroPython2026 in Krakow. But the fun keeps coming -- either at a social event, or using #Python #Pandas to analyze Krakow tourism data from the Polish government!

Level up your data-analysis skills every Wednesday: https://BambooWeekly.com

We just finished another day at #EuroPython2026 in Krakow. But the fun keeps coming -- either at a social event, or using #Python #Pandas to analyze Krakow tourism data from the Polish government!

Level up your data-analysis skills every Wednesday: https://BambooWeekly.com

I'm in Krakow for #EuroPython, and as such, Bamboo Weekly is about tourism to Krakow. Get data from the Polish government, and answer data-analysis questions with #Python #Pandas!

More info: https://BambooWeekly.com

I'm in Krakow for #EuroPython, and as such, Bamboo Weekly is about tourism to Krakow. Get data from the Polish government, and answer data-analysis questions with #Python #Pandas!

More info: https://BambooWeekly.com

#NVIDIA published a blog post where they present GQE, a GPU-based query engine. Querying data from databases with GPU accelleration is beyond cool, and will certainly optimize the storage requirements for #bigdata due to enabling for more efficient compression algorithms. Here is the blog post:

Designing GPU-Accelerated Query Engines with NVIDIA GQE

#bigdata #databases #polars #pandas #datascience

#NVIDIA published a blog post where they present GQE, a GPU-based query engine. Querying data from databases with GPU accelleration is beyond cool, and will certainly optimize the storage requirements for #bigdata due to enabling for more efficient compression algorithms. Here is the blog post:

Designing GPU-Accelerated Query Engines with NVIDIA GQE

#bigdata #databases #polars #pandas #datascience

Europe has been pretty hot lately -- and in the latest Bamboo Weekly, we used #Python #Pandas, GeoPandas, Marimo, and Plotly to find out just *how* hot.

Every week, get better at data analysis: https://BambooWeekly.com

Europe has been pretty hot lately -- and in the latest Bamboo Weekly, we used #Python #Pandas, GeoPandas, Marimo, and Plotly to find out just *how* hot.

Every week, get better at data analysis: https://BambooWeekly.com

Europe has been very hot for the last few weeks. How hot? In the latest Bamboo Weekly, we use #Python #Pandas to find out, using APIs and GeoPandas. Plus, we use Marimo for interactive plots.

Level up your data skills at https://BambooWeekly.com ... and stay cool!

Europe has been very hot for the last few weeks. How hot? In the latest Bamboo Weekly, we use #Python #Pandas to find out, using APIs and GeoPandas. Plus, we use Marimo for interactive plots.

Level up your data skills at https://BambooWeekly.com ... and stay cool!

#AIP:
"
".. extrem lichtschwache Zwerggalaxie wurde in der Nähe der Andromedagalaxie (M31) erstmals beobachtet. .. Studie legt nahe, dass die Galaxie, benannt And XXXVI, eine der lichtschwächsten Satellitengalaxien im Umfeld von Andromeda ist. ..
"
".. Alter von etwa 12,5 Milliarden Jahren .. erstaunlich arm an schweren Elementen .."

https://www.aip.de/de/news/galaxy-around-andromeda/

29.6.2026

#Andromeda #AndXXXVI #Astronomie #DM #DunkleMaterie #Galaxie #GTC #Kosmologie #PAndAS #Standardmodell #Universum #Zwerggalaxie

#AIP:
"
".. extrem lichtschwache Zwerggalaxie wurde in der Nähe der Andromedagalaxie (M31) erstmals beobachtet. .. Studie legt nahe, dass die Galaxie, benannt And XXXVI, eine der lichtschwächsten Satellitengalaxien im Umfeld von Andromeda ist. ..
"
".. Alter von etwa 12,5 Milliarden Jahren .. erstaunlich arm an schweren Elementen .."

https://www.aip.de/de/news/galaxy-around-andromeda/

29.6.2026

#Andromeda #AndXXXVI #Astronomie #DM #DunkleMaterie #Galaxie #GTC #Kosmologie #PAndAS #Standardmodell #Universum #Zwerggalaxie

Trying to use .loc to retrieve a slice in #Python #Pandas? If the index repeats, you need to sort it:

s = Series([10, 20, 30], index=list('aba'))

s.loc['a':'b'] # KeyError: "Cannot get left slice bound for non-unique label: 'a'"

s.sort_index().loc['a':'b'] # works!

Trying to use .loc to retrieve a slice in #Python #Pandas? If the index repeats, you need to sort it:

s = Series([10, 20, 30], index=list('aba'))

s.loc['a':'b'] # KeyError: "Cannot get left slice bound for non-unique label: 'a'"

s.sort_index().loc['a':'b'] # works!

Retrieve from a #Python #Pandas data frame with .loc, which takes 2 arguments:

1. Row selector: index, list of indexes, or a mask index (i.e., booleans)
2. Optional column selector: column name or a list of column names

.loc uses [] and not (), so you can use slices!

Retrieve from a #Python #Pandas data frame with .loc, which takes 2 arguments:

1. Row selector: index, list of indexes, or a mask index (i.e., booleans)
2. Optional column selector: column name or a list of column names

.loc uses [] and not (), so you can use slices!

Looking to level up your #Python, #Pandas, or #Git?

My in-browser, interactive AI tutor — used in all LernerPython courses — has you covered.

This week's new features:

• Live pair programming
• Translation of questions into your native language
• SQL exercises

Try it (free, no obligation) at https://buff.ly/zY4k23g

Looking to level up your #Python, #Pandas, or #Git?

My in-browser, interactive AI tutor — used in all LernerPython courses — has you covered.

This week's new features:

• Live pair programming
• Translation of questions into your native language
• SQL exercises

Try it (free, no obligation) at https://buff.ly/zY4k23g

Just checking if the rain tastes like bamboo today. #pandas #wildlife #animals #nature #humor

Just checking if the rain tastes like bamboo today. #pandas #wildlife #animals #nature #humor

Which governments restrict religion the most? Members of which religions are harassed the most? And how has this changed over the years?

In the latest Bamboo Weekly, we use #Python #Pandas to analyze data from Pew Research.

Level up your data skills every Wednesday, at https://buff.ly/D6C2X2C

Which governments restrict religion the most? Members of which religions are harassed the most? And how has this changed over the years?

In the latest Bamboo Weekly, we use #Python #Pandas to analyze data from Pew Research.

Level up your data skills every Wednesday, at https://buff.ly/D6C2X2C

Filtering a #Python #Pandas data frame by the index? Pandas 3 adds pd.col, removing lambda from our .loc expression.

Before:

df.loc[ lambda df_: df_['x'] > df_['w'] ]

Now:

df.loc[ pd.col('x') > pd.col('w') ]

Note: You cannot use pd.col with a series, only a data frame.

Filtering a #Python #Pandas data frame by the index? Pandas 3 adds pd.col, removing lambda from our .loc expression.

Before:

df.loc[ lambda df_: df_['x'] > df_['w'] ]

Now:

df.loc[ pd.col('x') > pd.col('w') ]

Note: You cannot use pd.col with a series, only a data frame.

To filter a #Python #Pandas data frame by rows, use the same syntax and rules as for series:

df.loc[ lambda df_: df_['x'] > df_['w'] ]

The lambda still returns a boolean series. The expression can use any column from the data frame.

Tomorrow: How Pandas 3 improves on this.

To filter a #Python #Pandas data frame by rows, use the same syntax and rules as for series:

df.loc[ lambda df_: df_['x'] > df_['w'] ]

The lambda still returns a boolean series. The expression can use any column from the data frame.

Tomorrow: How Pandas 3 improves on this.

AI With Python 2026 (Part 5)

Data is only valuable when you can understand it.

Learn:
DataFrames
Data cleaning
Data analysis
Preparing data for AI

Pandas turns raw data into insights.

Read: https://abkarikari23.medium.com/ai-with-python-2026-part-5-data-analysis-with-pandas-turning-data-into-insights-a90172b20912

#AI #Python #Pandas #DataScience #JMSM #KNKA #MachineLearning #AIWithPython2026

AI With Python 2026 (Part 5)

Data is only valuable when you can understand it.

Learn:
DataFrames
Data cleaning
Data analysis
Preparing data for AI

Pandas turns raw data into insights.

Read: https://abkarikari23.medium.com/ai-with-python-2026-part-5-data-analysis-with-pandas-turning-data-into-insights-a90172b20912

#AI #Python #Pandas #DataScience #JMSM #KNKA #MachineLearning #AIWithPython2026

Why do I use loc+lambda to filter a #Python #Pandas series?

1. If earlier lines filter common values, later loc/lambda lines have less to filter -- so queries run faster.
2. It's easier to build queries, one line at a time.
3. No assignment means less to track and clean up.

Why do I use loc+lambda to filter a #Python #Pandas series?

1. If earlier lines filter common values, later loc/lambda lines have less to filter -- so queries run faster.
2. It's easier to build queries, one line at a time.
3. No assignment means less to track and clean up.

Why do we domesticate some animals but not others? It all comes down to the four Fs.

https://web.brid.gy/r/https://www.upworthy.com/domestication-requirements-for-animals-four-f-explained-ex1/

Why do we domesticate some animals but not others? It all comes down to the four Fs.

https://web.brid.gy/r/https://www.upworthy.com/domestication-requirements-for-animals-four-f-explained-ex1/

Best filter method for a #Python #Pandas series? Use loc + lambda, thus filtering the series you got, not the global s:

s = pd.Series([10, 15, 20, 25, 30])

(
s
.loc[ lambda s_: (s_ > 20)] # filters s
.loc[ lambda s_: (s_ % 2 == 1) ] # filters output from first 1
)

Best filter method for a #Python #Pandas series? Use loc + lambda, thus filtering the series you got, not the global s:

s = pd.Series([10, 15, 20, 25, 30])

(
s
.loc[ lambda s_: (s_ > 20)] # filters s
.loc[ lambda s_: (s_ % 2 == 1) ] # filters output from first 1
)

My favorite way to apply multiple filters to a #Python #Pandas series? Method chaining calling loc 2x:

s = pd.Series([10, 15, 20, 25, 30])

(
s
.loc[ (s > 20)] # filters s
.loc[ (s % 2 == 1) ] # filters line 1
)

But: This can break! Tomorrow, a better way.

My favorite way to apply multiple filters to a #Python #Pandas series? Method chaining calling loc 2x:

s = pd.Series([10, 15, 20, 25, 30])

(
s
.loc[ (s > 20)] # filters s
.loc[ (s % 2 == 1) ] # filters line 1
)

But: This can break! Tomorrow, a better way.

When applying multiple filters to a #Python #Pandas series, it's often best to use multiple lines:

s = pd.Series([10, 15, 20, 25, 30])

s.loc[ (s > 20) &
(s % 2 == 1) ]

This is easier to read, write, and maintain.

When applying multiple filters to a #Python #Pandas series, it's often best to use multiple lines:

s = pd.Series([10, 15, 20, 25, 30])

s.loc[ (s > 20) &
(s % 2 == 1) ]

This is easier to read, write, and maintain.

Want to filter a #Python #Pandas series with two conditions? One option: Combine two boolean series with &.

But careful: Put () around each boolean condition.

s = pd.Series([10, 15, 20, 25, 30])
s.loc[ (s > 20) & (s % 2 == 1) ] # just 25

Want to filter a #Python #Pandas series with two conditions? One option: Combine two boolean series with &.

But careful: Put () around each boolean condition.

s = pd.Series([10, 15, 20, 25, 30])
s.loc[ (s > 20) & (s % 2 == 1) ] # just 25

How high is inflation? And is it the same in every country?

The latest Bamboo Weekly poses six inflation-related questions to solve with #Python #Pandas, using the latest OECD data.

Read it at: https://BambooWeekly.com

How high is inflation? And is it the same in every country?

The latest Bamboo Weekly poses six inflation-related questions to solve with #Python #Pandas, using the latest OECD data.

Read it at: https://BambooWeekly.com

Retrieve selected items from a #Python #Pandas series by broadcasting a condition, then using it as a boolean ("mask") index:

s = pd.Series([10, 20, 30], index=list('abc'))
s >= 20 # [False, True, True]
s.loc[ s >= 20 ] # returns [20, 30]

Retrieve selected items from a #Python #Pandas series by broadcasting a condition, then using it as a boolean ("mask") index:

s = pd.Series([10, 20, 30], index=list('abc'))
s >= 20 # [False, True, True]
s.loc[ s >= 20 ] # returns [20, 30]

Retrieve from a #Python #Pandas series with .loc and indexes:

s = pd.Series([10, 20, 30], index=list('abc'))
s.loc[['a', 'c']] # [10, 30]

If you pass booleans, True means "return a value," and False means "ignore it."

s.loc[[True, False, True]] # [10, 30]

Retrieve from a #Python #Pandas series with .loc and indexes:

s = pd.Series([10, 20, 30], index=list('abc'))
s.loc[['a', 'c']] # [10, 30]

If you pass booleans, True means "return a value," and False means "ignore it."

s.loc[[True, False, True]] # [10, 30]

#travel #travelguides #pandas #southkorea

https://www.koreatimes.co.kr/business/companies/20260617/everlands-famous-twin-pandas-become-koreas-newest-travel-guides?utm_source=flipboard&utm_medium=activitypub

Posted into THE TRAVEL EXCHANGE 3.0 @the-travel-exchange-3-0-Econopass

Apply an operator to a #Python #Pandas series, with a scalar value, *broadcasts*:

s = pd.Series([10, 20, 30], index=list('abc'))

Arithmetic is most obvious:

s + 5 # [15, 25, 35]
s ** 2 # [100, 400, 900]

But comparisons work, too:

s >= 20 # [False, True, True]

Apply an operator to a #Python #Pandas series, with a scalar value, *broadcasts*:

s = pd.Series([10, 20, 30], index=list('abc'))

Arithmetic is most obvious:

s + 5 # [15, 25, 35]
s ** 2 # [100, 400, 900]

But comparisons work, too:

s >= 20 # [False, True, True]