Product Prices analysis for various online retail stores ( Amazon,Flipkart,Snapdeal,HomeShop18 etc.)
Billion Prices Project is an initiative by two MIT profs to compute inflation statistics from online prices of goods instead of physical sampling as done by BLS. We are replicating the same for India.
Using the same category of products that RBI uses, we mine various online stores for prices of goods on a daily basis. We generate category indices for each category of products using appropriate weighting and then create a final inflation index.
Comparing All Store Analysis - https://s3-us-west-2.amazonaws.com/midsprojectoutput/compareall/part-00000
Comparing Flipkart & Amazon - https://s3-us-west-2.amazonaws.com/midsprojectoutput/compareamazonflipkart/part-00000
Comparing Snapdeal and FlipKart - https://s3-us-west-2.amazonaws.com/midsprojectoutput/comparelipkartsnapdeal/part-00000
Stores Sorted from Min to Max Price for a Product -
https://s3-us-west-2.amazonaws.com/midsprojectoutput/vendorpricesorted/part-00000 https://s3-us-west-2.amazonaws.com/midsprojectoutput/vendorpricesorted/part-00001 https://s3-us-west-2.amazonaws.com/midsprojectoutput/vendorpricesorted/part-00002 https://s3-us-west-2.amazonaws.com/midsprojectoutput/vendorpricesorted/part-00003
Store at which item is available at minimum price -
https://s3-us-west-2.amazonaws.com/midsprojectoutput/minprice/part-00000 https://s3-us-west-2.amazonaws.com/midsprojectoutput/minprice/part-00001 https://s3-us-west-2.amazonaws.com/midsprojectoutput/minprice/part-00002 https://s3-us-west-2.amazonaws.com/midsprojectoutput/minprice/part-00003
The data is provided by Ministry of Consumer Affairs, Food and Public Distribution We also analysed the commodity prices across various items ( rice/sugar/gasoline etc.) and the variation in prices across Tier 1 cities in India. The results are below
https://public.tableausoftware.com/views/bpp_wpi_0/PriceAnalysis?:embed=y&:display_count=no
| CPI | Inflation |
|---|---|
| 106.8312 | " |
| 137.511053 | 28.718065 |
| 133.878712 | -2.641491 |
| 442.792329 | 230.741403 |
| 514.803536 | 16.262975 |
| 797.175041 | 54.850343 |
| 412.962419 | -48.19677 |
| 823.945396 | 99.520673 |
| 455.254099 | -44.747055 |
| 792.8606 | 74.157807 |
| 804.37898 | 1.452768 |
| 447.536169 | -44.362523 |
| 477.174856 | 6.622635 |
| 1025.633529 | 114.938721 |
| 647.224839 | -36.895117 |
| 749.369954 | 15.782014 |
| 832.454373 | 11.087236 |
| 463.089626 | -44.37057 |
| 307.903021 | -33.511138 |
| 977.612001 | 217.506466 |
| 699.300975 | -28.468454 |
| 543.599912 | -22.265243 |
| 1.839218 | -99.66166 |