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

🌗 101 道 Pandas 數據分析練習題(互動式)
➤ 從基礎語法到深度學習:打造專業數據科學家的實戰指南
https://machinelearningplus.com/python/101-pandas-exercises-python-interactive/
本文介紹了 MachineLearningPlus 網站提供的全方位數據科學學習資源,核心亮點為一系列結構化的練習題,特別是「101 道 Pandas 練習題」。這些資源涵蓋了從 Python 基礎、機器學習算法、時間序列預測到深度學習與產業實戰項目等廣泛領域。該平臺透過系統化的練習與教學,協助數據分析師與工程師在實戰中熟練掌握 Pandas 等核心工具,提升處理大型數據集及建立機器學習模型的專業能力。
+ 這些練習題簡直是學習 Pandas 的救星,對於想紮實建立資料處理邏輯的人來說非常實用。
+ 資源庫的廣度令人驚艷,從基礎 Python 到高級的雲端部署都有涉及,是一個很完整的學習路徑。
#資料科學 #Python 教學 #Pandas 實作
101 Pandas Exercises for Data Analysis (Interactive) - machinelearningplus

101 interactive pandas exercises with solutions. Edit and run every code block directly in your browser — no installation needed.

machinelearningplus
101 Pandas Exercises for Data Analysis (Interactive) - machinelearningplus

101 interactive pandas exercises with solutions. Edit and run every code block directly in your browser — no installation needed.

machinelearningplus

Tom is now listening to Find You
https://open.spotify.com/track/5IzVL3gIya2cbzeZTcvyY7

#Pandas&People

Your #Python #Pandas data frame has a multi-index? Return selected parts to columns with the "level" keyword argument:

df.reset_index(level=1) # one column
df.reset_index(level=[0, 2]) # two columns
df.reset_index(level='y') # one column, if named

Yesterday's Claude+#Python workshop was great!

We built a shell utility (to get country info), a FastAPI app (to run a pizzeria), and a Discord bot (to check Python code quality). We discussed generating maintainable code, AI+human interactions, and subagents.

Join my Claude+#Pandas class on March 23rd — or ask about doing this at your company.

More info: https://lernerpython.com/code-with-claude/

Happy National Panda Day! Still adorable after 20 million years!
Knitters, here are some of the 25 panda knitting patterns from my blog post
https://intheloopknitting.com/panda-knitting-patterns.php

#knitting #pandas

Return a #Python #Pandas data frame's index to a regular column with reset_index:

df = df.reset_index()

• 1-column index? It's now a regular column.
• Multi-index? Its columns are all regular columns.

reset_index returns a new data frame. It doesn't modify the original.