Población de 5 estados de Estados Unidos

Cargar base de datos y librerías

library(readr)
library(maps)
library(ggplot2)
library(usmap)
library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(forecast)
## Registered S3 method overwritten by 'quantmod':
##   method            from
##   as.zoo.data.frame zoo
library(ggplot2)
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ forcats   1.0.0     ✔ stringr   1.5.1
## ✔ lubridate 1.9.3     ✔ tibble    3.2.1
## ✔ purrr     1.0.2     ✔ tidyr     1.3.1
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ✖ purrr::map()    masks maps::map()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
# Lee el archivo Excel
db1 <- read_csv("/Users/raquelgarza/Desktop/Rstudio/USA_Population.csv")
## Rows: 6020 Columns: 3
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (1): State
## dbl (2): Year, Population
## 
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

Ejercicio de población en Estados Unidos

# Poner titulos de columna
colnames(db1) <- c("state", "year","population")

Filtrar estados que usaremos para crear series de tiempo y pronósticos

Los cinco estados seleccionados fueron:

Texas
New Jersey
New York
Arizona
Florida

# Ordenar los datos por año
db1 <- db1[order(db1$year), ]

# Filtrar los estados que deseamos incluir (TX, NJ, NY, AZ, FL)
estados_deseados <- c("TX", "NJ", "NY", "AZ", "FL")
datos_filtrados <- db1[db1$state %in% estados_deseados, ]

# Dividir los datos en una lista por estado
estados_panel <- split(datos_filtrados, datos_filtrados$state)

# Comenzar una lista para almacenar los modelos ARIMA
arima_models <- list()

# Iterar sobre cada estado para ajustar un modelo ARIMA y hacer pronósticos
for (state in names(estados_panel)) {
  estados_data <- estados_panel[[state]]
  ts_estados <- ts(data = estados_data$population, start = min(estados_data$year), frequency = 1)
  modelo_arima <- auto.arima(ts_estados)
  forecast_values <- forecast(modelo_arima, h = 60)
  clean_state_name <- state
  arima_models[[clean_state_name]] <- list(model = modelo_arima, forecast = forecast_values)
  
  plot(forecast_values, main = paste("Pronóstico de población en", state))
}

Juntar los pronósticos

# Crear un dataframe vacío para almacenar los pronósticos en forma de panel
pronostico_panel <- data.frame(state = character(), year = numeric(), prediction = numeric())

# Iterar sobre los nombres en panel_list
for (state in names(estados_panel)) {
  # Acceder al pronóstico correspondiente en arima_models
  forecast <- arima_models[[state]]$forecast
  # Crear un dataframe temporal para el estado actual
  pronostico_estado <- data.frame(state = rep(state, length(forecast)), year = seq(2020, 2079), prediction = forecast)
  # Agregar el dataframe temporal al dataframe forecast_panel
  pronostico_panel <- rbind(pronostico_panel, pronostico_estado)
}


# Seleccionar y renombrar columnas pertinentes
pronostico_panel <- pronostico_panel %>% select(1:3)
colnames(pronostico_panel) <- c("state", "year", "population")

# Filtrar el dataframe pronostico_panel para incluir solo los años deseados
pronostico_selected_years <- pronostico_panel %>%
  filter(year %in% c(2030, 2040, 2050, 2060, 2070))


# Renombrar los estados con códigos a nombres completos
    pronostico_selected_years$state[pronostico_selected_years$state == 'TX'] <- 'Texas'
    pronostico_selected_years$state[pronostico_selected_years$state == 'NY'] <- 'Nueva York'
    pronostico_selected_years$state[pronostico_selected_years$state == 'NJ'] <- 'Nueva Jersey'
    pronostico_selected_years$state[pronostico_selected_years$state == 'FL'] <- 'Florida'
    pronostico_selected_years$state[pronostico_selected_years$state == 'AZ'] <- 'Arizona'

Crear mapas por década

#DataFrame con nombres de estados
pronostico_selected_years <- data.frame(
  state = c('arizona', 'arizona', 'arizona', 'arizona', 'arizona', 
            'florida', 'florida', 'florida', 'florida', 'florida',
            'new jersey', 'new jersey', 'new jersey', 'new jersey', 'new jersey',
            'new york', 'new york', 'new york', 'new york', 'new york',
            'texas', 'texas', 'texas', 'texas', 'texas'),
  year = c(2030, 2040, 2050, 2060, 2070,
           2030, 2040, 2050, 2060, 2070,
           2030, 2040, 2050, 2060, 2070,
           2030, 2040, 2050, 2060, 2070,
           2030, 2040, 2050, 2060, 2070),
  population = c(8455900, 9526065, 10596231, 11666397, 12736563,
                 24613196, 27483418, 30353639, 33223861, 36094083,
                 9366470, 9926170, 10493502, 11061426, 11629396,
                 19914471, 20455453, 20996510, 21537568, 22078626,
                 33482027, 37565581, 41649136, 45732691, 49816246)
)


# Cambiar los nombres de los estados a minúsculas para que coincidan con la base de datos
pronostico_selected_years$state <- tolower(pronostico_selected_years$state)

# Crear mapas para cada década
for (decade in seq(2030, 2070, by = 10)) {
  # Filtrar la base de datos de pronósticos para el año actual
  df_decade <- pronostico_selected_years %>% filter(year == decade)
  
  if (nrow(df_decade) > 0) {  # Verificar si hay datos en df_decade
    # Crear el mapa utilizando ggplot2 y usmap
    population_map <- plot_usmap(data = df_decade, values = "population", labels = TRUE) +
      scale_fill_continuous(name = "Población", low = "lightblue", high = "darkblue") +
      theme(legend.position = "right") +
      ggtitle(paste("Mapa de población en", decade))
    
    # Mostrar la gráfica utilizando print
    print(population_map)
  } else {
    cat("No hay datos para la década", decade, "\n")
  }
}

LS0tCnRpdGxlOiAiQWN0aXZpZGFkIEludGVncmFkb3JhIgphdXRob3I6ICJEYW5pZWxhIEdhcnphIC0gQTAxNzIxMDcxLCBSYXF1ZWwgR2FyemEtIEEwMDgzMDIwMywgR2VyYXJkbyBHYXJ6YSBBMDEzODMyODciCmRhdGU6ICIyMDI0LTAyLTIxIgpvdXRwdXQ6IAogIGh0bWxfZG9jdW1lbnQ6CiAgICB0b2M6IFRSVUUKICAgIHRvY19mbG9hdDogVFJVRQogICAgY29kZV9kb3dubG9hZDogVFJVRQotLS0KCmBgYHtyIHNldHVwLCBpbmNsdWRlPUZBTFNFfQprbml0cjo6b3B0c19jaHVuayRzZXQoZWNobyA9IFRSVUUpCmBgYAoKIVtdKGZsYWcuZ2lmKQoKIyBQb2JsYWNpw7NuIGRlIDUgZXN0YWRvcyBkZSBFc3RhZG9zIFVuaWRvcwoKIyMgQ2FyZ2FyIGJhc2UgZGUgZGF0b3MgeSBsaWJyZXLDrWFzCmBgYHtyfQpsaWJyYXJ5KHJlYWRyKQpsaWJyYXJ5KG1hcHMpCmxpYnJhcnkoZ2dwbG90MikKbGlicmFyeSh1c21hcCkKbGlicmFyeShkcGx5cikKbGlicmFyeShmb3JlY2FzdCkKbGlicmFyeShnZ3Bsb3QyKQpsaWJyYXJ5KHRpZHl2ZXJzZSkKCiMgTGVlIGVsIGFyY2hpdm8gRXhjZWwKZGIxIDwtIHJlYWRfY3N2KCIvVXNlcnMvcmFxdWVsZ2FyemEvRGVza3RvcC9Sc3R1ZGlvL1VTQV9Qb3B1bGF0aW9uLmNzdiIpCmBgYAoKIyMgRWplcmNpY2lvIGRlIHBvYmxhY2nDs24gZW4gRXN0YWRvcyBVbmlkb3MKYGBge3J9CiMgUG9uZXIgdGl0dWxvcyBkZSBjb2x1bW5hCmNvbG5hbWVzKGRiMSkgPC0gYygic3RhdGUiLCAieWVhciIsInBvcHVsYXRpb24iKQpgYGAKCiMjIEZpbHRyYXIgZXN0YWRvcyBxdWUgdXNhcmVtb3MgcGFyYSBjcmVhciBzZXJpZXMgZGUgdGllbXBvIHkgcHJvbsOzc3RpY29zCgpMb3MgY2luY28gZXN0YWRvcyBzZWxlY2Npb25hZG9zIGZ1ZXJvbjogICAgICAgCgpUZXhhcyAgICAgICAgCk5ldyBKZXJzZXkgICAgICAgCk5ldyBZb3JrICAgICAgIApBcml6b25hICAgICAgICAKRmxvcmlkYSAgICAgICAgCiAgICAgIAoKYGBge3J9CiMgT3JkZW5hciBsb3MgZGF0b3MgcG9yIGHDsW8KZGIxIDwtIGRiMVtvcmRlcihkYjEkeWVhciksIF0KCiMgRmlsdHJhciBsb3MgZXN0YWRvcyBxdWUgZGVzZWFtb3MgaW5jbHVpciAoVFgsIE5KLCBOWSwgQVosIEZMKQplc3RhZG9zX2Rlc2VhZG9zIDwtIGMoIlRYIiwgIk5KIiwgIk5ZIiwgIkFaIiwgIkZMIikKZGF0b3NfZmlsdHJhZG9zIDwtIGRiMVtkYjEkc3RhdGUgJWluJSBlc3RhZG9zX2Rlc2VhZG9zLCBdCgojIERpdmlkaXIgbG9zIGRhdG9zIGVuIHVuYSBsaXN0YSBwb3IgZXN0YWRvCmVzdGFkb3NfcGFuZWwgPC0gc3BsaXQoZGF0b3NfZmlsdHJhZG9zLCBkYXRvc19maWx0cmFkb3Mkc3RhdGUpCgojIENvbWVuemFyIHVuYSBsaXN0YSBwYXJhIGFsbWFjZW5hciBsb3MgbW9kZWxvcyBBUklNQQphcmltYV9tb2RlbHMgPC0gbGlzdCgpCgojIEl0ZXJhciBzb2JyZSBjYWRhIGVzdGFkbyBwYXJhIGFqdXN0YXIgdW4gbW9kZWxvIEFSSU1BIHkgaGFjZXIgcHJvbsOzc3RpY29zCmZvciAoc3RhdGUgaW4gbmFtZXMoZXN0YWRvc19wYW5lbCkpIHsKICBlc3RhZG9zX2RhdGEgPC0gZXN0YWRvc19wYW5lbFtbc3RhdGVdXQogIHRzX2VzdGFkb3MgPC0gdHMoZGF0YSA9IGVzdGFkb3NfZGF0YSRwb3B1bGF0aW9uLCBzdGFydCA9IG1pbihlc3RhZG9zX2RhdGEkeWVhciksIGZyZXF1ZW5jeSA9IDEpCiAgbW9kZWxvX2FyaW1hIDwtIGF1dG8uYXJpbWEodHNfZXN0YWRvcykKICBmb3JlY2FzdF92YWx1ZXMgPC0gZm9yZWNhc3QobW9kZWxvX2FyaW1hLCBoID0gNjApCiAgY2xlYW5fc3RhdGVfbmFtZSA8LSBzdGF0ZQogIGFyaW1hX21vZGVsc1tbY2xlYW5fc3RhdGVfbmFtZV1dIDwtIGxpc3QobW9kZWwgPSBtb2RlbG9fYXJpbWEsIGZvcmVjYXN0ID0gZm9yZWNhc3RfdmFsdWVzKQogIAogIHBsb3QoZm9yZWNhc3RfdmFsdWVzLCBtYWluID0gcGFzdGUoIlByb27Ds3N0aWNvIGRlIHBvYmxhY2nDs24gZW4iLCBzdGF0ZSkpCn0KCmBgYAoKIyMgSnVudGFyIGxvcyBwcm9uw7NzdGljb3MKYGBge3J9CiMgQ3JlYXIgdW4gZGF0YWZyYW1lIHZhY8OtbyBwYXJhIGFsbWFjZW5hciBsb3MgcHJvbsOzc3RpY29zIGVuIGZvcm1hIGRlIHBhbmVsCnByb25vc3RpY29fcGFuZWwgPC0gZGF0YS5mcmFtZShzdGF0ZSA9IGNoYXJhY3RlcigpLCB5ZWFyID0gbnVtZXJpYygpLCBwcmVkaWN0aW9uID0gbnVtZXJpYygpKQoKIyBJdGVyYXIgc29icmUgbG9zIG5vbWJyZXMgZW4gcGFuZWxfbGlzdApmb3IgKHN0YXRlIGluIG5hbWVzKGVzdGFkb3NfcGFuZWwpKSB7CiAgIyBBY2NlZGVyIGFsIHByb27Ds3N0aWNvIGNvcnJlc3BvbmRpZW50ZSBlbiBhcmltYV9tb2RlbHMKICBmb3JlY2FzdCA8LSBhcmltYV9tb2RlbHNbW3N0YXRlXV0kZm9yZWNhc3QKICAjIENyZWFyIHVuIGRhdGFmcmFtZSB0ZW1wb3JhbCBwYXJhIGVsIGVzdGFkbyBhY3R1YWwKICBwcm9ub3N0aWNvX2VzdGFkbyA8LSBkYXRhLmZyYW1lKHN0YXRlID0gcmVwKHN0YXRlLCBsZW5ndGgoZm9yZWNhc3QpKSwgeWVhciA9IHNlcSgyMDIwLCAyMDc5KSwgcHJlZGljdGlvbiA9IGZvcmVjYXN0KQogICMgQWdyZWdhciBlbCBkYXRhZnJhbWUgdGVtcG9yYWwgYWwgZGF0YWZyYW1lIGZvcmVjYXN0X3BhbmVsCiAgcHJvbm9zdGljb19wYW5lbCA8LSByYmluZChwcm9ub3N0aWNvX3BhbmVsLCBwcm9ub3N0aWNvX2VzdGFkbykKfQoKCiMgU2VsZWNjaW9uYXIgeSByZW5vbWJyYXIgY29sdW1uYXMgcGVydGluZW50ZXMKcHJvbm9zdGljb19wYW5lbCA8LSBwcm9ub3N0aWNvX3BhbmVsICU+JSBzZWxlY3QoMTozKQpjb2xuYW1lcyhwcm9ub3N0aWNvX3BhbmVsKSA8LSBjKCJzdGF0ZSIsICJ5ZWFyIiwgInBvcHVsYXRpb24iKQoKIyBGaWx0cmFyIGVsIGRhdGFmcmFtZSBwcm9ub3N0aWNvX3BhbmVsIHBhcmEgaW5jbHVpciBzb2xvIGxvcyBhw7FvcyBkZXNlYWRvcwpwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzIDwtIHByb25vc3RpY29fcGFuZWwgJT4lCiAgZmlsdGVyKHllYXIgJWluJSBjKDIwMzAsIDIwNDAsIDIwNTAsIDIwNjAsIDIwNzApKQoKCiMgUmVub21icmFyIGxvcyBlc3RhZG9zIGNvbiBjw7NkaWdvcyBhIG5vbWJyZXMgY29tcGxldG9zCiAgICBwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzJHN0YXRlW3Byb25vc3RpY29fc2VsZWN0ZWRfeWVhcnMkc3RhdGUgPT0gJ1RYJ10gPC0gJ1RleGFzJwogICAgcHJvbm9zdGljb19zZWxlY3RlZF95ZWFycyRzdGF0ZVtwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzJHN0YXRlID09ICdOWSddIDwtICdOdWV2YSBZb3JrJwogICAgcHJvbm9zdGljb19zZWxlY3RlZF95ZWFycyRzdGF0ZVtwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzJHN0YXRlID09ICdOSiddIDwtICdOdWV2YSBKZXJzZXknCiAgICBwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzJHN0YXRlW3Byb25vc3RpY29fc2VsZWN0ZWRfeWVhcnMkc3RhdGUgPT0gJ0ZMJ10gPC0gJ0Zsb3JpZGEnCiAgICBwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzJHN0YXRlW3Byb25vc3RpY29fc2VsZWN0ZWRfeWVhcnMkc3RhdGUgPT0gJ0FaJ10gPC0gJ0FyaXpvbmEnCiAgICAKCmBgYAoKIyBDcmVhciBtYXBhcyBwb3IgZMOpY2FkYQpgYGB7cn0KI0RhdGFGcmFtZSBjb24gbm9tYnJlcyBkZSBlc3RhZG9zCnByb25vc3RpY29fc2VsZWN0ZWRfeWVhcnMgPC0gZGF0YS5mcmFtZSgKICBzdGF0ZSA9IGMoJ2FyaXpvbmEnLCAnYXJpem9uYScsICdhcml6b25hJywgJ2FyaXpvbmEnLCAnYXJpem9uYScsIAogICAgICAgICAgICAnZmxvcmlkYScsICdmbG9yaWRhJywgJ2Zsb3JpZGEnLCAnZmxvcmlkYScsICdmbG9yaWRhJywKICAgICAgICAgICAgJ25ldyBqZXJzZXknLCAnbmV3IGplcnNleScsICduZXcgamVyc2V5JywgJ25ldyBqZXJzZXknLCAnbmV3IGplcnNleScsCiAgICAgICAgICAgICduZXcgeW9yaycsICduZXcgeW9yaycsICduZXcgeW9yaycsICduZXcgeW9yaycsICduZXcgeW9yaycsCiAgICAgICAgICAgICd0ZXhhcycsICd0ZXhhcycsICd0ZXhhcycsICd0ZXhhcycsICd0ZXhhcycpLAogIHllYXIgPSBjKDIwMzAsIDIwNDAsIDIwNTAsIDIwNjAsIDIwNzAsCiAgICAgICAgICAgMjAzMCwgMjA0MCwgMjA1MCwgMjA2MCwgMjA3MCwKICAgICAgICAgICAyMDMwLCAyMDQwLCAyMDUwLCAyMDYwLCAyMDcwLAogICAgICAgICAgIDIwMzAsIDIwNDAsIDIwNTAsIDIwNjAsIDIwNzAsCiAgICAgICAgICAgMjAzMCwgMjA0MCwgMjA1MCwgMjA2MCwgMjA3MCksCiAgcG9wdWxhdGlvbiA9IGMoODQ1NTkwMCwgOTUyNjA2NSwgMTA1OTYyMzEsIDExNjY2Mzk3LCAxMjczNjU2MywKICAgICAgICAgICAgICAgICAyNDYxMzE5NiwgMjc0ODM0MTgsIDMwMzUzNjM5LCAzMzIyMzg2MSwgMzYwOTQwODMsCiAgICAgICAgICAgICAgICAgOTM2NjQ3MCwgOTkyNjE3MCwgMTA0OTM1MDIsIDExMDYxNDI2LCAxMTYyOTM5NiwKICAgICAgICAgICAgICAgICAxOTkxNDQ3MSwgMjA0NTU0NTMsIDIwOTk2NTEwLCAyMTUzNzU2OCwgMjIwNzg2MjYsCiAgICAgICAgICAgICAgICAgMzM0ODIwMjcsIDM3NTY1NTgxLCA0MTY0OTEzNiwgNDU3MzI2OTEsIDQ5ODE2MjQ2KQopCgoKIyBDYW1iaWFyIGxvcyBub21icmVzIGRlIGxvcyBlc3RhZG9zIGEgbWluw7pzY3VsYXMgcGFyYSBxdWUgY29pbmNpZGFuIGNvbiBsYSBiYXNlIGRlIGRhdG9zCnByb25vc3RpY29fc2VsZWN0ZWRfeWVhcnMkc3RhdGUgPC0gdG9sb3dlcihwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzJHN0YXRlKQoKIyBDcmVhciBtYXBhcyBwYXJhIGNhZGEgZMOpY2FkYQpmb3IgKGRlY2FkZSBpbiBzZXEoMjAzMCwgMjA3MCwgYnkgPSAxMCkpIHsKICAjIEZpbHRyYXIgbGEgYmFzZSBkZSBkYXRvcyBkZSBwcm9uw7NzdGljb3MgcGFyYSBlbCBhw7FvIGFjdHVhbAogIGRmX2RlY2FkZSA8LSBwcm9ub3N0aWNvX3NlbGVjdGVkX3llYXJzICU+JSBmaWx0ZXIoeWVhciA9PSBkZWNhZGUpCiAgCiAgaWYgKG5yb3coZGZfZGVjYWRlKSA+IDApIHsgICMgVmVyaWZpY2FyIHNpIGhheSBkYXRvcyBlbiBkZl9kZWNhZGUKICAgICMgQ3JlYXIgZWwgbWFwYSB1dGlsaXphbmRvIGdncGxvdDIgeSB1c21hcAogICAgcG9wdWxhdGlvbl9tYXAgPC0gcGxvdF91c21hcChkYXRhID0gZGZfZGVjYWRlLCB2YWx1ZXMgPSAicG9wdWxhdGlvbiIsIGxhYmVscyA9IFRSVUUpICsKICAgICAgc2NhbGVfZmlsbF9jb250aW51b3VzKG5hbWUgPSAiUG9ibGFjacOzbiIsIGxvdyA9ICJsaWdodGJsdWUiLCBoaWdoID0gImRhcmtibHVlIikgKwogICAgICB0aGVtZShsZWdlbmQucG9zaXRpb24gPSAicmlnaHQiKSArCiAgICAgIGdndGl0bGUocGFzdGUoIk1hcGEgZGUgcG9ibGFjacOzbiBlbiIsIGRlY2FkZSkpCiAgICAKICAgICMgTW9zdHJhciBsYSBncsOhZmljYSB1dGlsaXphbmRvIHByaW50CiAgICBwcmludChwb3B1bGF0aW9uX21hcCkKICB9IGVsc2UgewogICAgY2F0KCJObyBoYXkgZGF0b3MgcGFyYSBsYSBkw6ljYWRhIiwgZGVjYWRlLCAiXG4iKQogIH0KfQoKCmBgYAoK