Consumer Price Index

X-axis label	CPI	HICP
Apr 2025	2.2	2
May 2025	1.7	1.4
Jun 2025	1.8	1.6
Jul 2025	1.7	1.6
Aug 2025	2	1.9
Sep 2025	2.7	2.7
Oct 2025	2.9	2.8
Nov 2025	3.2	3.1
Dec 2025	2.8	2.7
Jan 2026	2.7	2.5
Feb 2026	2.7	2.5
Mar 2026	3.6	3.6
Apr 2026	3.7	3.6

All required packages are already installed. All required packages are already installed. - / / - - / / - - / / - - / / - - / / - - / / - - / / - All required packages are already installed. All required packages are already installed. - / / - All required packages are already installed. All required packages are already installed. All required packages are already installed. - / / - - / / - All required packages are already installed. - / / - All required packages are already installed. - / / - All required packages are already installed. - / / - All required packages are already installed. - / / - All required packages are already installed. [1] "Aldi_Data_2022_31.RDS" [1] "No Aldi data to save after processing!" [1] "Aldi_Data_2024_23.RDS" [1] "No Aldi data to save after processing!" [1] "aldiscanner2025w4_trf" [1] "Error encountered with aldiscanner2025w4_trf" Error in `db_query_fields.DBIConnection()`: ! Can't query fields. ℹ Using SQL: SELECT * FROM cpi_aldiscanner_transformed.aldiscanneraldiscanner2025w4_trfwaldiscanner2025w4_trf_trf `q01` WHERE (0 = 1) Caused by error in `source()`: ! ODBC failed with error 00000 from [RStudio][SQLEngine]. ✖ (31740) Table or view not found: HIVE.cpi_aldiscanner_transformed.aldiscanneraldiscanner2025w4_trfwaldiscanner2025w4_trf_trf • 'SELECT * • FROM cpi_aldiscanner_transformed.aldiscanneraldiscanner2025w4_trfwaldiscanner2025w4_trf_trf `q01` • WHERE (0 = 1)' ℹ From 'nanodbc/nanodbc.cpp:1722'. --- Backtrace: ▆ 1. ├─base::source(paste0(location, "/Development/Faith_Greene/Production_Workbench_COPY/01_Download_Weekly_Shop_Data_COPY.R")) 2. │ ├─base::withVisible(eval(ei, envir)) 3. │ └─base::eval(ei, envir) 4. │ └─base::eval(ei, envir) 5. ├─base::tryCatch(...) at Faith_Greene/Production_Workbench_COPY/01_Download_Weekly_Shop_Data_COPY.R:114:9 6. │ └─base (local) tryCatchList(expr, classes, parentenv, handlers) 7. │ └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]]) 8. │ └─base (local) doTryCatch(return(expr), name, parentenv, handler) 9. ├─... %>% mutate(across(where(is.character), ~ na_if(., ""))) at Faith_Greene/Production_Workbench_COPY/01_Download_Weekly_Shop_Data_COPY.R:116:11 10. ├─dplyr::mutate(., across(where(is.character), ~na_if(., ""))) 11. ├─dplyr::select(...) 12. ├─dplyr::mutate(...) 13. ├─dplyr::mutate_at(...) 14. │ └─dplyr:::manip_at(...) 15. │ └─dplyr:::tbl_at_syms(...) 16. │ └─dplyr:::tbl_at_vars(...) 17. │ └─dplyr::tbl_vars(tbl) 18. │ ├─dplyr:::new_sel_vars(tbl_vars_dispatch(x), group_vars(x)) 19. │ │ └─base::structure(...) 20. │ └─dplyr:::tbl_vars_dispatch(x) 21. ├─dplyr::rename(...) 22. ├─tibble::as_tibble(.) 23. ├─dplyr::tbl(...) 24. ├─dplyr:::tbl.DBIConnection(...) 25. │ ├─dplyr::tbl(...) 26. │ └─dbplyr:::tbl.src_dbi(...) 27. │ └─dbplyr::tbl_sql(c(subclass, "dbi"), src = src, from = from, ...) 28. │ ├─base::withCallingHandlers(...) 29. │ ├─vars %||% dbplyr_query_fields(src$con, source) 30. │ └─dbplyr:::dbplyr_query_fields(src$con, source) 31. │ └─dbplyr:::dbplyr_fallback(con, "db_query_fields", ...) 32. │ ├─rlang::eval_bare(expr((!!fun)(con, ...))) 33. │ └─dbplyr:::db_query_fields.DBIConnection(con, ...) 34. │ └─dbplyr:::db_get_query(con, sql, "Can't query fields.") 35. │ ├─dbplyr:::dbi_wrap(...) 36. │ │ └─base::withCallingHandlers(...) 37. │ ├─DBI::dbGetQuery(con, sql) 38. │ └─odbc::dbGetQuery(con, sql) 39. │ └─odbc (local) .local(conn, statement, ...) 40. │ ├─DBI::dbSendQuery(...) 41. │ └─odbc::dbSendQuery(...) 42. │ └─odbc (local) .local(conn, statement, ...) 43. │ └─odbc:::OdbcResult(...) 44. │ └─odbc:::new_result(p = connection@ptr, sql = statement, immediate = immediate) 45. └─odbc (local) ``("nanodbc/nanodbc.cpp:1722: 00000\n[RStudio][SQLEngine] (31740) Table or view not found: HIVE.cpi_aldiscanner_transformed.aldiscanneraldiscanner2025w4_trfwaldiscanner2025w4_trf_trf \n 'SELECT *\nFROM cpi_aldiscanner_transformed.aldiscanneraldiscanner2025w4_trfwaldiscanner2025w4_trf_trf `q01`\nWHERE (0 = 1)'") [1] "Aldi_Data_2026_14.RDS" [1] "Error encountered with Aldi_Data_2026_14.RDS" [1] "Aldi_Data_2026_15.RDS" [1] "Error encountered with Aldi_Data_2026_15.RDS" [1] "Aldi_Data_2026_16.RDS" [1] "Error encountered with Aldi_Data_2026_16.RDS" [1] "Aldi_Data_2026_17.RDS" [1] "Error encountered with Aldi_Data_2026_17.RDS" [1] "Lidl_Data_2024_08.RDS" [1] "No Lidl data to save after processing!" [1] "Lidl_Data_2024_22.RDS" [1] "No Lidl data to save after processing!" [1] "Lidl_Data_2024_27.RDS" [1] "No Lidl data to save after processing!" [1] "Lidl_Data_2024_28.RDS" [1] "No Lidl data to save after processing!" [1] "Lidl_Data_2024_41.RDS" [1] "No Lidl data to save after processing!" [1] "Lidl_Data_2025_00.RDS" [1] "No Lidl data to save after processing!" [1] "Lidl_Data_2026_16.RDS" [1] "Error encountered with Lidl_Data_2026_16.RDS" [1] "Lidl_Data_2026_17.RDS" [1] "Error encountered with Lidl_Data_2026_17.RDS" [1] "Lidl_Data_2026_18.RDS" [1] "Error encountered with Lidl_Data_2026_18.RDS" [1] "svscanner2022_src" [1] "svscanner2023_src" [1] "svscanner2024_src" [1] "svscanner2025_src" [1] "svscanner2026_src" [1] "2026 16" [1] "Error encountered with Supervalu 16 2026" [1] "2026 17" [1] "Error encountered with Supervalu 17 2026" [1] "2026 18" [1] "Error encountered with Supervalu 18 2026" [1] "2026 01" [1] "Error encountered with Tesco 01 2026" [1] "2026 02" [1] "Error encountered with Tesco 02 2026" Error in `collect()`: ! Failed to collect lazy table. Caused by error in `source()`: ! ODBC failed with error 00000 from . ✖ • 'SELECT • `tescoscanner_weekly_sales_data2026w02_trf`.`year_number` AS `year_number.x`, • `tescoscanner_weekly_sales_data2026w02_trf`.`week_number` AS `week_number.x`, • `tescoscanner_weekly_sales_data2026w02_trf`.`gtin` AS `gtin`, • `tpnb`, • `tpnc`, • `source_of_transaction`, • `revenue`, • `tescoscanner_weekly_sales_data2026w02_trf`.`quantity` AS `quantity.x`, • `price`, • `product_description`, • `brand`, • `subclass`, • `section`, • `division`, • `department`, • `class`, • `tescoscanner_product_data2026w02_trf`.`quantity` AS `quantity.y`, • `quantity_unit`, • `replaced_tpnb` • FROM cpi_tescoscanner_transformed.tescoscanner_weekly_sales_data2026w02_trf • LEFT JOIN cpi_tescoscanner_transformed.tescoscanner_product_data2026w02_trf • ON (`tescoscanner_weekly_sales_data2026w02_trf`.`gtin` = `tescoscanner_product_data2026w02_trf`.`gtin`)' ℹ From 'nanodbc/nanodbc.cpp:1783'. --- Backtrace: ▆ 1. ├─base::source(paste0(location, "/Development/Faith_Greene/Production_Workbench_COPY/01_Download_Weekly_Shop_Data_COPY.R")) 2. │ ├─base::withVisible(eval(ei, envir)) 3. │ └─base::eval(ei, envir) 4. │ └─base::eval(ei, envir) 5. ├─base::tryCatch(...) at Faith_Greene/Production_Workbench_COPY/01_Download_Weekly_Shop_Data_COPY.R:384:9 6. │ └─base (local) tryCatchList(expr, classes, parentenv, handlers) 7. │ └─base (local) tryCatchOne(expr, names, parentenv, handlers[[1L]]) 8. │ └─base (local) doTryCatch(return(expr), name, parentenv, handler) 9. ├─... %>% mutate(across(where(is.character), ~ na_if(., ""))) at Faith_Greene/Production_Workbench_COPY/01_Download_Weekly_Shop_Data_COPY.R:385:11 10. ├─dplyr::mutate(., across(where(is.character), ~na_if(., ""))) 11. ├─dplyr::select(...) 12. ├─dplyr::mutate(...) 13. ├─dplyr::mutate_at(...) 14. │ └─dplyr:::manip_at(...) 15. │ └─dplyr:::tbl_at_syms(...) 16. │ └─dplyr:::tbl_at_vars(...) 17. │ └─dplyr::tbl_vars(tbl) 18. │ ├─dplyr:::new_sel_vars(tbl_vars_dispatch(x), group_vars(x)) 19. │ │ └─base::structure(...) 20. │ └─dplyr:::tbl_vars_dispatch(x) 21. ├─dplyr::rename(...) 22. ├─tibble::as_tibble(.) 23. ├─tibble:::as_tibble.default(.) 24. │ ├─tibble::as_tibble(...) 25. │ ├─base::as.data.frame(value, stringsAsFactors = FALSE) 26. │ └─dbplyr:::as.data.frame.tbl_sql(value, stringsAsFactors = FALSE) 27. │ ├─base::as.data.frame(collect(x, n = n)) 28. │ ├─dplyr::collect(x, n = n) 29. │ └─dbplyr:::collect.tbl_sql(x, n = n) 30. │ ├─base::withCallingHandlers(...) 31. │ ├─dbplyr::db_collect(...) 32. │ └─dbplyr:::db_collect.DBIConnection(...) 33. │ ├─DBI::dbSendQuery(con, sql) 34. │ └─odbc::dbSendQuery(con, sql) 35. │ └─odbc (local) .local(conn, statement, ...) 36. │ └─odbc:::OdbcResult(...) 37. │ └─odbc:::new_result(p = connection@ptr, sql = statement, immediate = immediate) 38. └─odbc (local) ``("nanodbc/nanodbc.cpp:1783: 00000\n\n 'SELECT\n `tescoscanner_weekly_sales_data2026w02_trf`.`year_number` AS `year_number.x`,\n `tescoscanner_weekly_sales_data2026w02_trf`.`week_number` AS `week_number.x`,\n `tescoscanner_weekly_sales_data2026w02_trf`.`gtin` AS `gtin`,\n `tpnb`,\n `tpnc`,\n `source_of_transaction`,\n `revenue`,\n `tescoscanner_weekly_sales_data2026w02_trf`.`quantity` AS `quantity.x`,\n `price`,\n `product_description`,\n `brand`,\n `subclass`,\n `section`,\n `division`,\n `department`,\n `class`,\n `tescoscanner_product_data2026w02_trf`.`quantity` AS `quantity.y`,\n `quantity_unit`,\n `replaced_tpnb`\nFROM cpi_tescoscanner_transformed.tescoscanner_weekly_sales_data2026w02_trf\nLEFT JOIN cpi_tescoscanner_transformed.tescoscanner_product_data2026w02_trf\n ON (`tescoscanner_weekly_sales_data2026w02_trf`.`gtin` = `tescoscanner_product_data2026w02_trf`.`gtin`)'") [1] "2026 06" [1] "Error encountered with Tesco 06 2026" [1] "2026 15"