Dinge, die mich davon abhalten, noch produktiver in meiner Arbeit zu sein:

- HTTP Error 503 einer gewissen API (mal wieder...)
- marodes Streckennetz der #Bahn
- dieser eine Spezialfall in #pandas, den ich schon wieder vergessen habe
- unbefugte Personen im Gleis
- #PyCharm "updating skeletons"/ "indexing"
- "Dieser Zug fährt heute nur bis Ahrensburg. Grund dafür sind Maßnahmen zur Stabilisierung des Betriebsablaufs."
- Windows macht ein Update

#Pendler #Python #Coding #Montagslaune 😂

Changing your clocks this weekend? Or did you do so a few weeks ago? Or maybe you never do?

In the latest Bamboo Weekly, we use #Python #Pandas to see which countries observe DST, and for how long each year.

Check it out: https://BambooWeekly.com

A #Python #Pandas column contains comma-separated values. How can you get the first of those?

First, break each string into a list:

df['x'].str.split(',')

Then use .str[0] to grab the first element from the resulting list:

df['x'].str.split(',').str[0]

Want to check whether a #Python #Pandas string series only contains digits? Use str.isdigit:

df['x'].str.isdigit()

This returns a boolean series, with df's index. You can then convert the digit-containing strings to integers:

df.loc[pd.col('x').str.isdigit(), 'x'].astype(int)

Want to retrieve a slice from a string column in your #Python #Pandas data frame? Use .str.slice:

df['a'].str.slice(1, 10) # or .str[1:10]
df['a'].str.slice(1, 10, 2) # or .str[1:10:2]
df['a'].str.slice(None, 10) # or .str[:10]
df['a'].str.slice(1, None) # or .str[1:]

Want to retrieve from a string column in your #Python #Pandas data frame? Use .str.get:

df['a'].str.get(0) # one character
df['a'].str.get(i) # using an index variable

But wait: You can use [], in place of .get:

df['a'].str[0] # alt syntax!

A recent paper finds that when new albums drop, streaming traffic increases — and so do traffic fatalities. 🤯

In today's Bamboo Weekly, we investigate this data with #Python #Pandas, using a variety of data-analysis techniques — grouping, joins, and datetime values.

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

Your #Python #Pandas data frame has a multi-index, and you want to remove one part — not return it to be a regular column? Add drop=True:

df.reset_index(level=1) # index level 1 becomes a column in df
df.reset_index(level=1, drop=True) # index level 1 is removed

Pandas Exercises for Data Analysis (Interactive)

https://machinelearningplus.com/python/101-pandas-exercises-python-interactive/

#HackerNews #Pandas #Exercises #DataAnalysis #Interactive #Python #MachineLearning