Manipulating the CPI Data Series
Explore how to automate cleaning and formatting of Consumer Price Index data series using Python methods like str.replace and str.contains. Understand filtering techniques to prepare quarterly CPI data for wage trend comparisons and save cleaned data efficiently.
We'll cover the following...
We'll cover the following...
Solution from Python
Solution
Python has a few tools we can use to fix the formatting problem between our columns. Sure, we could always open up the data in CSV files and manually edit each row. But that would be boring and time-consuming since we’re working with hundreds of rows. It’s better to learn to do it automatically because manual editing is impossible when working with larger analytics projects.
So we’re going to automate our ...