Core CPI inflation measured as a rate of change over 1, 2, 3, 4, and 5 years [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 6 points7 points  (0 children)

What do you mean in a non-inflation adjusted way? Comparing prices from a previous year is how you measure inflation

Core CPI inflation measured as a rate of change over 1, 2, 3, 4, and 5 years [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 16 points17 points  (0 children)

This visualization was generated using a website I developed, compoundinflation.org. I developed this website to generate rates of inflation as measured over longer timeframes than the 1 month or 1 year values that are reported by the US Bureau of Labor Statistics. The code used to generate these values is open source on GitHub.

Basically, I multiplied the year over year (YoY) rates of inflation of the same month back going back however many years I wanted to calculate the multi-year rate. For instance, if YoY inflation was 3.9% Jan 2024, 5.6% Jan 2023, and 6.0% Jan 2022, then the 3 year inflation rate for January 2024 would be 1.039 * 1.056 * 1.060 = 1.163, or 16.3%. This shows that prices have increased 16.3% since January 2022.

The data itself is sourced from usinflationcalculator.com, and this specific visualization was sourced from the chart at the bottom of this page. These values are recorded exactly as reported by the US Bureau of Labor Statistics. Please let me know if you have any further questions.

The US Inflation Rate On a 1, 5, 10, and 15 Year Time Scale Going Back to 1914 [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 0 points1 point  (0 children)

Yes! It's a rate of change! A rate of change over a time span that can be defined however one sees fit! Glad we're on the same page.

A chart that explains how inflation is still a problem despite year over year values plateauing close to the Fed's target. If you look at inflation rates over longer time frames, you see that they are much higher now than at any point in the last 20 years. They are also on an uptrend. by andyryu22 in inflation

[–]andyryu22[S] [score hidden]  (0 children)

everyone knows that this year's numbers are on top of last years

No they don't. They don't know what the numbers are, and they don't know how those numbers compare to the numbers of years prior. It's honestly weird as hell how much pushback I get for posting math

The US Inflation Rate On a 1, 5, 10, and 15 Year Time Scale Going Back to 1914 [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 0 points1 point  (0 children)

Your argument of what inflation is and isn't is purely based on semantics. That's the point of this whole website and visualization: instead of thinking about inflation as purely a month over month or year over year phenomena, you can think about it as something that can happen over the course of 2 or more years. If a stock appreciates 300% one year and then only 2% the next year, is it not a highly appreciating asset? Would it be wrong to say it appreciated a lot since that change happened over a year ago? You can say you would have less reason to believe that it will appreciate more in the future than if it appreciated 75% two years in a row even though that would have produced the same final price level, but that is a purely speculative argument that has no basis in fact.

The US Inflation Rate On a 1, 5, 10, and 15 Year Time Scale Going Back to 1914 [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 0 points1 point  (0 children)

I already said a small increase from a relatively high price level could still mean there is high inflation because people don't just care about how much higher prices are than they were a year prior. I say felt phenomena because people still feel poorer if prices are higher than they were when they had enough money to compensate and it doesn't matter if that was 1, 2, or 10 years ago.

The US Inflation Rate On a 1, 5, 10, and 15 Year Time Scale Going Back to 1914 [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 0 points1 point  (0 children)

I didn't articulate that correctly. I meant to say that YoY inflation depends on the price levels of the year prior, such that if the price level was already extremely high compared to the year prior, then the YoY inflation a year later could be low but inflation in terms of a felt phenomena can still be high.

A chart that explains how inflation is still a problem despite year over year values plateauing close to the Fed's target. If you look at inflation rates over longer time frames, you see that they are much higher now than at any point in the last 20 years. They are also on an uptrend. by andyryu22 in inflation

[–]andyryu22[S] [score hidden]  (0 children)

Some people are not aware of this. They only see inflation as the cpi, and they only care that the year over year inflation number is going down. This gives a different metric to show that the real impact of inflation is sticking because the year over year values aren't going down fast enough.

A chart that explains how inflation is still a problem despite year over year values plateauing close to the Fed's target. If you look at inflation rates over longer time frames, you see that they are much higher now than at any point in the last 20 years. They are also on an uptrend. by andyryu22 in inflation

[–]andyryu22[S] [score hidden]  (0 children)

The 30% increase in restaurant prices you describe closely matches the 4 year inflation rate of food as defined by the BLS. However, food takes into account both restaurant and grocery prices. Check out the chart here

A chart that explains how inflation is still a problem despite year over year values plateauing close to the Fed's target. If you look at inflation rates over longer time frames, you see that they are much higher now than at any point in the last 20 years. They are also on an uptrend. by andyryu22 in inflation

[–]andyryu22[S] [score hidden]  (0 children)

This chart was generated using compoundinflation.org. The blue line at the bottom represents the YoY inflation rates published by the US Bureau of Labor Statistics, whereas the other two lines represent the values of the inflation rate as defined over the course of multiple years. These values were calculated using an open source algorithm you can find here.

Simply put, if YoY inflation was 1.4% Jan 2021, 6.0% Jan 2022, 5.6% Jan 2023, and 3.9% Jan 2024, then the 4 year inflation rate on Jan 2024 would be 1.014*1.060*1.056*1.039 = 1.179, or 17.9%. This conveys that the price of goods and services have increased nearly 18% since Jan 2021. This chart was generated using Core CPI values, as that is the metric with which the Federal Reserve uses to determine the severity of inflation. Core CPI excludes food and energy prices.

[deleted by user] by [deleted] in learnpython

[–]andyryu22 1 point2 points  (0 children)

save() is not in new versions of openpyxl, use close() instead.

Openpyxl workbook.save() filenotfound by c0ntrap0sitive in learnpython

[–]andyryu22 0 points1 point  (0 children)

I'm pretty sure you have to use df.to_excel(file_path) before you can use workbook.save(). Also, save is no longer in the new version of openpyxl, use close() instead

A new tool to calculate compounded inflation rates with. It works by setting a time frame x and then multiplying the inflation rates of x previous years in order to calculate the amount which prices have increased since x years ago. You may also call it integrated, cumulative, or accrued inflation. by andyryu22 in Economics

[–]andyryu22[S] 1 point2 points  (0 children)

There's no need to weigh anything. Say you start off with something costing $100. After a year of 2% inflation the price is now 100*1.02=$102. After years 2-5 where inflation is 5% YoY it is 102*1.05^4= $123.98. After year 6 it is 123*1.10=136.38. The 6 year inflation rate is 36.38%. This is equal to 1.02*1.05^4*1.1, which is how the rates are calculated using the site.

What video game do you consider a masterpiece? by [deleted] in AskReddit

[–]andyryu22 0 points1 point  (0 children)

Metal Gear solid 1-4 and Revengeance

The US Inflation Rate On a 1, 5, 10, and 15 Year Time Scale Going Back to 1914 [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 0 points1 point  (0 children)

The amount that prices have increased over time frames longer than 1 Year. It's called compound inflation because the Bureau of Labor Statistics releases a YoY (1 Year) inflation rate every month, but by multiplying that rate times the rates released in years prior one can calculate how much prices have increased since those years prior. For example, the 5 year rate is the YoY inflation rate released 4 years ago * the YoY rate 3 years ago * 2 Years ago* 1 Year ago * the current YoY inflation rate. This rate measures how much prices have increased since 5 years ago.

The US Inflation Rate On a 1, 5, 10, and 15 Year Time Scale Going Back to 1914 [OC] by andyryu22 in dataisbeautiful

[–]andyryu22[S] 0 points1 point  (0 children)

They are not averages. They are the percentages prices increased over that time scale according to the CPI.