Based on your detailed breakdown, here's a revised version of the code that incorporates all the steps:

Customizing Jupyter Notebooks with HTMLExporter for Presentation Layer Design

Working with MultiIndex DataFrames in Python: Mastering Complex Data Structures for Efficient Analysis.

Setting Non-Constant Values on a Subset of Rows and Columns in a DataFrame Using Multiple Approaches

Understanding Bigrams and Duplicate Frequency Summation Using Pandas in Python

Handling Lists as Column Values in Pandas DataFrames: A Step-by-Step Solution

Remove Duplicate Records in Pandas DataFrame Based on Alphabetical Order

Pandas: Combining Data Frames with IDs in Common

Understanding Negative Array Indexing in Python

Negating str.contains() with pandas .query()