datos_originales <- readr::read_delim(
ruta, delim=delimitador, trim_ws=TRUE, show_col_types=FALSE,
name_repair="minimal", col_types=readr::cols(.default=readr::col_character())
)
## Carga exitosa: 47.501 registros.
campo_productor_limpio <- datos_originales |>
dplyr::transmute(CampoProductor=stringr::str_squish(as.character(.data[[columna_campo]]))) |>
dplyr::filter(!is.na(CampoProductor), CampoProductor != "",
!toupper(CampoProductor) %in% c("NA", "N/A", "NULL"))
N <- nrow(campo_productor_limpio)
if (N == 0L) stop("No hay registros válidos de PRODUCING_FIELD.")
k_campos <- dplyr::n_distinct(campo_productor_limpio$CampoProductor)
cat("Registros válidos:", fmt_entero(N),
" | Campos productores distintos:", fmt_entero(k_campos), "\n")
## Registros válidos: 41.785 | Campos productores distintos: 353
| VARIABLE | TIPO | ESCALA DE MEDICIÓN | UNIDAD DE ANÁLISIS | CATEGORÍAS (k) | REGISTROS VÁLIDOS (N) |
|---|---|---|---|---|---|
| PRODUCING_FIELD (Campo productor) | Cualitativa nominal | Nominal | Pozo regulado | 353 | 41.785 |
El Cuadro N° 1 presenta la frecuencia absoluta (nᵢ), la frecuencia relativa (hᵢ) y el porcentaje de cada uno de los 353 campos productores, considerando 41.785 registros válidos. Desplázate dentro de la tabla para consultar todas las categorías.
cat(crear_cuadro(tabla_frecuencias, 1,
"Distribución de frecuencias de los pozos regulados según el campo productor, Nueva York, 1860 - 2026",
desplazamiento=(k_campos > 15L)))
| CAMPO PRODUCTOR | FRECUENCIA ABSOLUTA (nᵢ) | FRECUENCIA RELATIVA (hᵢ) | FRECUENCIA RELATIVA PORCENTUAL (%) |
|---|---|---|---|
| Montezuma Marsh | 5 | 0.0001 | 0.01% |
| Ellicott Creek | 2 | 0.0000 | 0.00% |
| South Fulton | 7 | 0.0002 | 0.02% |
| Bradley Brook - Herkimer pool | 31 | 0.0007 | 0.07% |
| Dry Run Creek | 1 | 0.0000 | 0.00% |
| Woodhull | 65 | 0.0016 | 0.16% |
| Derby | 23 | 0.0006 | 0.06% |
| Hog Hollow | 4 | 0.0001 | 0.01% |
| Hunt Hollow | 8 | 0.0002 | 0.02% |
| Short Tract | 3 | 0.0001 | 0.01% |
| Stagecoach | 44 | 0.0011 | 0.11% |
| Tozier’s Corners | 4 | 0.0001 | 0.01% |
| Clymer Hill | 1 | 0.0000 | 0.00% |
| Doolittle Hill | 1 | 0.0000 | 0.00% |
| Skye-Top | 1 | 0.0000 | 0.00% |
| Ashland Farms | 1 | 0.0000 | 0.00% |
| Thorn Hill | 2 | 0.0000 | 0.00% |
| North Collins | 347 | 0.0083 | 0.83% |
| Stony Ridge | 2 | 0.0000 | 0.00% |
| Big Creek | 1 | 0.0000 | 0.00% |
| West Union | 14 | 0.0003 | 0.03% |
| Red House | 109 | 0.0026 | 0.26% |
| Boyle | 30 | 0.0007 | 0.07% |
| Triangle | 2 | 0.0000 | 0.00% |
| Cryder Creek | 9 | 0.0002 | 0.02% |
| Roanoke | 27 | 0.0006 | 0.06% |
| Utley Brook | 11 | 0.0003 | 0.03% |
| Hulbert Hollow | 1 | 0.0000 | 0.00% |
| Purdy Creek | 1 | 0.0000 | 0.00% |
| Zoar | 80 | 0.0019 | 0.19% |
| Northwest Harrison | 4 | 0.0001 | 0.01% |
| Ford’s Brook | 800 | 0.0191 | 1.91% |
| Limestone | 23 | 0.0006 | 0.06% |
| North Harmony | 58 | 0.0014 | 0.14% |
| Sugar Hill | 1 | 0.0000 | 0.00% |
| Cutler Creek | 3 | 0.0001 | 0.01% |
| North Wales | 1 | 0.0000 | 0.00% |
| Hamlin | 2 | 0.0000 | 0.00% |
| Central Wales | 7 | 0.0002 | 0.02% |
| Sanborn | 1 | 0.0000 | 0.00% |
| Fredonia | 1 | 0.0000 | 0.00% |
| Lakeshore | 5.682 | 0.1360 | 13.60% |
| Wells College | 1 | 0.0000 | 0.00% |
| International Salt | 4 | 0.0001 | 0.01% |
| Dansville | 20 | 0.0005 | 0.05% |
| Dale | 195 | 0.0047 | 0.47% |
| Bennington | 112 | 0.0027 | 0.27% |
| Whiskey Creek | 1 | 0.0000 | 0.00% |
| Cassadaga Creek | 3 | 0.0001 | 0.01% |
| Melvin Hill | 1 | 0.0000 | 0.00% |
| State Line | 23 | 0.0006 | 0.06% |
| Alexander | 12 | 0.0003 | 0.03% |
| Vandermark Creek | 10 | 0.0002 | 0.02% |
| Rathbone | 35 | 0.0008 | 0.08% |
| Watkins Glen | 8 | 0.0002 | 0.02% |
| Chaffee-Arcade | 79 | 0.0019 | 0.19% |
| Veteran Hill | 1 | 0.0000 | 0.00% |
| Indian Falls | 116 | 0.0028 | 0.28% |
| Seeley Creek | 1 | 0.0000 | 0.00% |
| Rayner | 2 | 0.0000 | 0.00% |
| Whiskey Hill | 2 | 0.0000 | 0.00% |
| Conesus | 2 | 0.0000 | 0.00% |
| Summerhill | 1 | 0.0000 | 0.00% |
| Dutch Hill | 5 | 0.0001 | 0.01% |
| Grass Hill South | 1 | 0.0000 | 0.00% |
| Danley Corners | 141 | 0.0034 | 0.34% |
| Savona | 15 | 0.0004 | 0.04% |
| Conewango Creek | 1 | 0.0000 | 0.00% |
| Vincent | 18 | 0.0004 | 0.04% |
| Thomas Corners | 25 | 0.0006 | 0.06% |
| Belmont | 1 | 0.0000 | 0.00% |
| Sheridan | 40 | 0.0010 | 0.10% |
| Crosby Creek | 3 | 0.0001 | 0.01% |
| Halsey Valley | 2 | 0.0000 | 0.00% |
| English Brook | 20 | 0.0005 | 0.05% |
| Dutch Hollow | 1 | 0.0000 | 0.00% |
| Bergen | 3 | 0.0001 | 0.01% |
| Sardinia | 25 | 0.0006 | 0.06% |
| Darling Creek | 2 | 0.0000 | 0.00% |
| Beech Hill | 90 | 0.0022 | 0.22% |
| Bethany | 47 | 0.0011 | 0.11% |
| Latta Brook | 1 | 0.0000 | 0.00% |
| West River | 1 | 0.0000 | 0.00% |
| Gingerbread Corners | 2 | 0.0000 | 0.00% |
| Cagwin | 1 | 0.0000 | 0.00% |
| Madison Hill | 35 | 0.0008 | 0.08% |
| Coopers Plains | 1 | 0.0000 | 0.00% |
| Attica | 6 | 0.0001 | 0.01% |
| Woodhull Austinburg | 1 | 0.0000 | 0.00% |
| Ellery | 47 | 0.0011 | 0.11% |
| Hotchkiss Hollow | 14 | 0.0003 | 0.03% |
| New Field Wildcat | 223 | 0.0053 | 0.53% |
| Nashville | 113 | 0.0027 | 0.27% |
| North Penn Yan | 15 | 0.0004 | 0.04% |
| Little France | 1 | 0.0000 | 0.00% |
| Country Club | 1 | 0.0000 | 0.00% |
| Auburn | 12 | 0.0003 | 0.03% |
| Moreland | 1 | 0.0000 | 0.00% |
| Irish Hill | 1 | 0.0000 | 0.00% |
| Cafferty Hill | 2 | 0.0000 | 0.00% |
| Bixby Hill | 3 | 0.0001 | 0.01% |
| Concord | 101 | 0.0024 | 0.24% |
| Howland Hill | 5 | 0.0001 | 0.01% |
| Cramer Hollow | 1 | 0.0000 | 0.00% |
| Rome | 20 | 0.0005 | 0.05% |
| Sherry Hill | 1 | 0.0000 | 0.00% |
| Akron | 33 | 0.0008 | 0.08% |
| Buffalo | 94 | 0.0022 | 0.22% |
| Trapping Brook | 3 | 0.0001 | 0.01% |
| Sullivan Park | 1 | 0.0000 | 0.00% |
| Perrysburg | 70 | 0.0017 | 0.17% |
| Hartsville | 7 | 0.0002 | 0.02% |
| Java | 37 | 0.0009 | 0.09% |
| Spooner Creek | 1 | 0.0000 | 0.00% |
| Hungry Hollow | 1 | 0.0000 | 0.00% |
| Greenwood | 18 | 0.0004 | 0.04% |
| Busti | 774 | 0.0185 | 1.85% |
| Avon | 28 | 0.0007 | 0.07% |
| Stone Hill | 3 | 0.0001 | 0.01% |
| Steege Hill | 2 | 0.0000 | 0.00% |
| Northwoods | 2 | 0.0000 | 0.00% |
| Nile | 33 | 0.0008 | 0.08% |
| Farmington | 8 | 0.0002 | 0.02% |
| Cooper Hill | 1 | 0.0000 | 0.00% |
| Cross Lake | 1 | 0.0000 | 0.00% |
| Genegantslet | 7 | 0.0002 | 0.02% |
| Green Hill | 1 | 0.0000 | 0.00% |
| Forest Hill | 1 | 0.0000 | 0.00% |
| Bath | 3 | 0.0001 | 0.01% |
| Quackenbush Hill | 14 | 0.0003 | 0.03% |
| Wilson Hollow | 11 | 0.0003 | 0.03% |
| Beech Hill-Independence | 1.060 | 0.0254 | 2.54% |
| North Fulton | 6 | 0.0001 | 0.01% |
| Salt Point Storage | 38 | 0.0009 | 0.09% |
| Baldwinsville | 64 | 0.0015 | 0.15% |
| Caton | 6 | 0.0001 | 0.01% |
| Carrollton | 1 | 0.0000 | 0.00% |
| Alfred | 9 | 0.0002 | 0.02% |
| Onoville | 1 | 0.0000 | 0.00% |
| Elma | 84 | 0.0020 | 0.20% |
| Marsh | 435 | 0.0104 | 1.04% |
| Auburn Geothermal | 2 | 0.0000 | 0.00% |
| Sheldon | 64 | 0.0015 | 0.15% |
| Meads Creek | 1 | 0.0000 | 0.00% |
| Bradford | 5.711 | 0.1367 | 13.67% |
| Burr Bear Pool | 1 | 0.0000 | 0.00% |
| Wolf Run | 5 | 0.0001 | 0.01% |
| Baldwin Creek | 1 | 0.0000 | 0.00% |
| Benton Run | 2 | 0.0000 | 0.00% |
| Longhorn - Hamilton Pool | 1 | 0.0000 | 0.00% |
| Longhorn - Oneida Pool | 1 | 0.0000 | 0.00% |
| Sharon | 43 | 0.0010 | 0.10% |
| Milwaukee Creek | 1 | 0.0000 | 0.00% |
| Lawtons | 76 | 0.0018 | 0.18% |
| Bradley Brook | 40 | 0.0010 | 0.10% |
| Reading | 4 | 0.0001 | 0.01% |
| Watkins Glen Village | 41 | 0.0010 | 0.10% |
| East Independence | 19 | 0.0005 | 0.05% |
| Lamoka | 1 | 0.0000 | 0.00% |
| Tug Hill | 6 | 0.0001 | 0.01% |
| Whetstone Brook | 1 | 0.0000 | 0.00% |
| Monterey | 5 | 0.0001 | 0.01% |
| Sexton Hollow | 2 | 0.0000 | 0.00% |
| McDuffy Hollow | 2 | 0.0000 | 0.00% |
| Finnegan Hill | 10 | 0.0002 | 0.02% |
| Scio | 257 | 0.0062 | 0.62% |
| Brick House | 2 | 0.0000 | 0.00% |
| Carroll | 6 | 0.0001 | 0.01% |
| Wyoming Village | 196 | 0.0047 | 0.47% |
| Brant-Eden | 441 | 0.0106 | 1.06% |
| Zimmer Hill | 1 | 0.0000 | 0.00% |
| Horseheads | 1 | 0.0000 | 0.00% |
| Dayton | 9 | 0.0002 | 0.02% |
| East Otto | 20 | 0.0005 | 0.05% |
| Clarence | 3 | 0.0001 | 0.01% |
| Jasper | 15 | 0.0004 | 0.04% |
| Four Mile | 525 | 0.0126 | 1.26% |
| Indian Creek | 2 | 0.0000 | 0.00% |
| Bath-Lpg | 1 | 0.0000 | 0.00% |
| West Seneca | 84 | 0.0020 | 0.20% |
| Humphrey | 6 | 0.0001 | 0.01% |
| Lebanon | 22 | 0.0005 | 0.05% |
| Beaver Meadow - Herkimer pool | 22 | 0.0005 | 0.05% |
| John Hill | 1 | 0.0000 | 0.00% |
| Tully Brine | 170 | 0.0041 | 0.41% |
| Wayne-Dundee | 181 | 0.0043 | 0.43% |
| Jackson Hill | 1 | 0.0000 | 0.00% |
| Sandy Creek | 67 | 0.0016 | 0.16% |
| Beans Station | 3 | 0.0001 | 0.01% |
| Alma | 50 | 0.0012 | 0.12% |
| Glenwood | 18 | 0.0004 | 0.04% |
| Sugar Creek | 1 | 0.0000 | 0.00% |
| Wales | 30 | 0.0007 | 0.07% |
| Honeoye-Oriskany | 5 | 0.0001 | 0.01% |
| Whitesville | 1 | 0.0000 | 0.00% |
| Pike Corners | 1 | 0.0000 | 0.00% |
| Fayette-Waterloo | 308 | 0.0074 | 0.74% |
| Brookfield | 3 | 0.0001 | 0.01% |
| Richburg | 11.659 | 0.2790 | 27.90% |
| Millpond | 4 | 0.0001 | 0.01% |
| Painted Post | 5 | 0.0001 | 0.01% |
| West Bloomfield | 47 | 0.0011 | 0.11% |
| Elmira | 18 | 0.0004 | 0.04% |
| Castile | 11 | 0.0003 | 0.03% |
| Gerry-Charlotte | 55 | 0.0013 | 0.13% |
| Huron Creek | 207 | 0.0050 | 0.50% |
| Romulus | 1 | 0.0000 | 0.00% |
| Adrian Reef | 17 | 0.0004 | 0.04% |
| Lansing | 3 | 0.0001 | 0.01% |
| Coover Hollow Northeast | 1 | 0.0000 | 0.00% |
| Blue Tail Rooster | 13 | 0.0003 | 0.03% |
| Houghton | 3 | 0.0001 | 0.01% |
| French Creek | 3 | 0.0001 | 0.01% |
| Hannon | 1 | 0.0000 | 0.00% |
| Rice Brook | 61 | 0.0015 | 0.15% |
| Andover | 496 | 0.0119 | 1.19% |
| Browning | 242 | 0.0058 | 0.58% |
| Ludlowville | 22 | 0.0005 | 0.05% |
| Gilbert | 1 | 0.0000 | 0.00% |
| Bockhahn | 3 | 0.0001 | 0.01% |
| Kelly Hill | 1 | 0.0000 | 0.00% |
| Pigeon Hill | 7 | 0.0002 | 0.02% |
| Laurel Run | 5 | 0.0001 | 0.01% |
| West Auburn | 352 | 0.0084 | 0.84% |
| Alden-Lancaster | 693 | 0.0166 | 1.66% |
| Bass Lake | 1 | 0.0000 | 0.00% |
| Tuscarora | 17 | 0.0004 | 0.04% |
| Honeoye | 48 | 0.0011 | 0.11% |
| Bryant Hill Creek | 5 | 0.0001 | 0.01% |
| Cleveland Hill | 3 | 0.0001 | 0.01% |
| Ellicotville | 15 | 0.0004 | 0.04% |
| Quinlan Reef | 12 | 0.0003 | 0.03% |
| East Bloomfield | 27 | 0.0006 | 0.06% |
| Portville | 2 | 0.0000 | 0.00% |
| Uhley Corners-Caledonia | 157 | 0.0038 | 0.38% |
| Pulaski | 97 | 0.0023 | 0.23% |
| Kent Hill | 1 | 0.0000 | 0.00% |
| Wirt | 18 | 0.0004 | 0.04% |
| South Wales | 1 | 0.0000 | 0.00% |
| Beaver Meadow | 10 | 0.0002 | 0.02% |
| Gordon Brook | 19 | 0.0005 | 0.05% |
| Olean | 30 | 0.0007 | 0.07% |
| Jersey Hollow | 1 | 0.0000 | 0.00% |
| Groveland | 3 | 0.0001 | 0.01% |
| Geneva | 59 | 0.0014 | 0.14% |
| Colden | 280 | 0.0067 | 0.67% |
| Cascade Brook | 22 | 0.0005 | 0.05% |
| Hawley Brook Field | 1 | 0.0000 | 0.00% |
| Sangerfield | 5 | 0.0001 | 0.01% |
| Mud Creek | 3 | 0.0001 | 0.01% |
| Fulmer Valley | 938 | 0.0224 | 2.24% |
| Danby | 3 | 0.0001 | 0.01% |
| Confidential | 36 | 0.0009 | 0.09% |
| Bowman Hill | 1 | 0.0000 | 0.00% |
| Guyanoga Valley | 1 | 0.0000 | 0.00% |
| Rush Creek | 1 | 0.0000 | 0.00% |
| East Harrison | 2 | 0.0000 | 0.00% |
| Sprague Hill | 7 | 0.0002 | 0.02% |
| Salt Point Brine | 88 | 0.0021 | 0.21% |
| Big Inlet Pool | 1 | 0.0000 | 0.00% |
| North Corning | 7 | 0.0002 | 0.02% |
| Camden | 15 | 0.0004 | 0.04% |
| Howard | 13 | 0.0003 | 0.03% |
| Muck Farm | 4 | 0.0001 | 0.01% |
| Rushford | 9 | 0.0002 | 0.02% |
| Allegany State Park | 5 | 0.0001 | 0.01% |
| Orchard Park-Hamburg | 164 | 0.0039 | 0.39% |
| Cowlesville | 26 | 0.0006 | 0.06% |
| Tonawanda | 45 | 0.0011 | 0.11% |
| Memphis | 5 | 0.0001 | 0.01% |
| Chipmunk | 2.931 | 0.0701 | 7.01% |
| Clymer | 18 | 0.0004 | 0.04% |
| Beaver Meadow - Vernon pool | 6 | 0.0001 | 0.01% |
| Longhorn | 1 | 0.0000 | 0.00% |
| Pangburn | 3 | 0.0001 | 0.01% |
| Glodes Corners Road | 15 | 0.0004 | 0.04% |
| McNutt Run | 1 | 0.0000 | 0.00% |
| Harrison | 2 | 0.0000 | 0.00% |
| Harmony | 6 | 0.0001 | 0.01% |
| Watkins Glen - Marcellus Pool | 2 | 0.0000 | 0.00% |
| Deyo | 1 | 0.0000 | 0.00% |
| Karr Valley | 1 | 0.0000 | 0.00% |
| Snyders Corners Pool | 1 | 0.0000 | 0.00% |
| Kasoag | 1 | 0.0000 | 0.00% |
| Lodi | 8 | 0.0002 | 0.02% |
| Little Valley | 3 | 0.0001 | 0.01% |
| Big Flats | 1 | 0.0000 | 0.00% |
| South Corning | 2 | 0.0000 | 0.00% |
| Ceres | 34 | 0.0008 | 0.08% |
| Holland | 55 | 0.0013 | 0.13% |
| Orangeville | 4 | 0.0001 | 0.01% |
| Pavilion | 101 | 0.0024 | 0.24% |
| Wethersfield | 2 | 0.0000 | 0.00% |
| Wyoming | 16 | 0.0004 | 0.04% |
| Corbin Hill | 39 | 0.0009 | 0.09% |
| Avoca | 14 | 0.0003 | 0.03% |
| Seneca Lake | 9 | 0.0002 | 0.02% |
| Ballyhack Creek | 3 | 0.0001 | 0.01% |
| Allen | 19 | 0.0005 | 0.05% |
| Bristol | 14 | 0.0003 | 0.03% |
| Buffalo Creek | 47 | 0.0011 | 0.11% |
| Goundry Hill | 1 | 0.0000 | 0.00% |
| Card School | 3 | 0.0001 | 0.01% |
| Apple Core | 1 | 0.0000 | 0.00% |
| Fancy Tract | 12 | 0.0003 | 0.03% |
| Rushville | 26 | 0.0006 | 0.06% |
| Wyckoff | 18 | 0.0004 | 0.04% |
| Connoisarauley Creek | 1 | 0.0000 | 0.00% |
| Langdon Hill | 16 | 0.0004 | 0.04% |
| Rose Hill | 3 | 0.0001 | 0.01% |
| McClure Hollow | 2 | 0.0000 | 0.00% |
| West Independence | 83 | 0.0020 | 0.20% |
| Mallory | 5 | 0.0001 | 0.01% |
| Lakeview | 167 | 0.0040 | 0.40% |
| Riverside | 1 | 0.0000 | 0.00% |
| Oak Hill | 2 | 0.0000 | 0.00% |
| North Greenwood | 10 | 0.0002 | 0.02% |
| Van Etten | 14 | 0.0003 | 0.03% |
| Sparta | 1 | 0.0000 | 0.00% |
| Bradley Brook - Vernon pool | 1 | 0.0000 | 0.00% |
| Ashford | 23 | 0.0006 | 0.06% |
| Folsom Creek | 3 | 0.0001 | 0.01% |
| Collins | 71 | 0.0017 | 0.17% |
| Groton | 8 | 0.0002 | 0.02% |
| South Penn Yan | 5 | 0.0001 | 0.01% |
| Farmersville | 21 | 0.0005 | 0.05% |
| East Aurora | 64 | 0.0015 | 0.15% |
| Pine Hill | 4 | 0.0001 | 0.01% |
| Hamilton | 1 | 0.0000 | 0.00% |
| Five Mile | 602 | 0.0144 | 1.44% |
| Terry Hill South | 7 | 0.0002 | 0.02% |
| Corning | 6 | 0.0001 | 0.01% |
| Chestnut Ridge | 1 | 0.0000 | 0.00% |
| Sunset Point | 3 | 0.0001 | 0.01% |
| Clyde | 7 | 0.0002 | 0.02% |
| County Line | 4 | 0.0001 | 0.01% |
| South Bradford | 7 | 0.0002 | 0.02% |
| Rawson | 2 | 0.0000 | 0.00% |
| Reeder Creek | 1 | 0.0000 | 0.00% |
| Silver Lake | 47 | 0.0011 | 0.11% |
| Silver Springs | 63 | 0.0015 | 0.15% |
| Colonel Bills Creek | 1 | 0.0000 | 0.00% |
| Dublin Hollow | 1 | 0.0000 | 0.00% |
| Leicester | 146 | 0.0035 | 0.35% |
| Crosby Creek - Fulmer Valley Pool | 1 | 0.0000 | 0.00% |
| Butler Creek | 1 | 0.0000 | 0.00% |
| Travers | 1 | 0.0000 | 0.00% |
| Seneca Falls | 15 | 0.0004 | 0.04% |
| Harford Mills | 4 | 0.0001 | 0.01% |
| Churchville | 20 | 0.0005 | 0.05% |
| Clarksville | 310 | 0.0074 | 0.74% |
| Naples | 19 | 0.0005 | 0.05% |
| Great Valley | 1 | 0.0000 | 0.00% |
| TOTAL | 41.785 | 1.0000 | 100.00% |
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
Interpretación: el campo productor más frecuente es Richburg, con 11.659 pozos (27.90% del total). La menor frecuencia registrada es 1, compartida por 94 campos productores.
if (usar_resumen) {
cat("## Top ", numero_top, " de campos productores con mayor frecuencia {-}\n\n", sep="")
cat("El Cuadro N° 2 presenta los ", numero_top,
" campos productores más frecuentes, ordenados de mayor a menor, ",
"y agrupa los restantes en Otros campos productores. ",
"El Top ", numero_top, " representa el ", sprintf("%.2f%%", pct_top),
" de los ", fmt_entero(N), " registros válidos.\n\n", sep="")
cat(crear_cuadro(tabla_resumen, 2,
paste0("Distribución de frecuencias de los pozos regulados: Top ", numero_top,
" campos productores y Otros, Nueva York, 1860 - 2026")))
}
El Cuadro N° 2 presenta los 10 campos productores más frecuentes, ordenados de mayor a menor, y agrupa los restantes en Otros campos productores. El Top 10 representa el 73.83% de los 41.785 registros válidos.
| CAMPO PRODUCTOR | FRECUENCIA ABSOLUTA (nᵢ) | FRECUENCIA RELATIVA (hᵢ) | FRECUENCIA RELATIVA PORCENTUAL (%) |
|---|---|---|---|
| Richburg | 11.659 | 0.2790 | 27.90% |
| Bradford | 5.711 | 0.1367 | 13.67% |
| Lakeshore | 5.682 | 0.1360 | 13.60% |
| Chipmunk | 2.931 | 0.0701 | 7.01% |
| Beech Hill-Independence | 1.060 | 0.0254 | 2.54% |
| Fulmer Valley | 938 | 0.0224 | 2.24% |
| Ford’s Brook | 800 | 0.0191 | 1.91% |
| Busti | 774 | 0.0185 | 1.85% |
| Alden-Lancaster | 693 | 0.0166 | 1.66% |
| Five Mile | 602 | 0.0144 | 1.44% |
| Otros campos productores | 10.935 | 0.2617 | 26.17% |
| TOTAL | 41.785 | 1.0000 | 100.00% |
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
ggplot2::ggplot(tabla_local, ggplot2::aes(x=CampoProductor,y=ni,fill=CampoProductor)) +
ggplot2::geom_col(width=.72,color="#244861",linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=fmt_entero(ni)),vjust=-.48,
size=4.5,fontface="bold",color="#15364C") +
ggplot2::scale_fill_manual(values=colores) +
escala_campos +
ggplot2::scale_y_continuous(limits=c(0,limite_ni_local),
labels=fmt_entero,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::coord_cartesian(clip="off") +
ggplot2::labs(title="Gráfica N° 1: Frecuencia absoluta (nᵢ) local",
x="Campo productor",y="Frecuencia absoluta (nᵢ)",caption=fuente_graficas) +
tema_barras
ggplot2::ggplot(tabla_global, ggplot2::aes(x=CampoProductor,y=ni)) +
ggplot2::geom_col(fill="#286492",color="#244861",width=.72,linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=fmt_entero(ni)),vjust=-.48,
size=4.5,fontface="bold",color="#15364C") +
escala_campos +
ggplot2::scale_y_continuous(limits=c(0,limite_ni_global),
labels=fmt_entero,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::coord_cartesian(clip="off") +
ggplot2::labs(title="Gráfica N° 2: Frecuencia absoluta (nᵢ) global",
x="Campo productor",y="Frecuencia absoluta (nᵢ)",caption=fuente_graficas) +
tema_barras
ggplot2::ggplot(tabla_local, ggplot2::aes(x=CampoProductor,y=hi,fill=CampoProductor)) +
ggplot2::geom_col(width=.72,color="#244861",linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=sprintf("%.2f%%",100*hi)),vjust=-.48,
size=4.3,fontface="bold",color="#15364C") +
ggplot2::scale_fill_manual(values=colores) +
escala_campos +
ggplot2::scale_y_continuous(limits=c(0,limite_hi_local),labels=etiqueta_pct,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::coord_cartesian(clip="off") +
ggplot2::labs(title="Gráfica N° 3: Frecuencia relativa (hᵢ) local",
x="Campo productor",y="Frecuencia relativa (%)",caption=fuente_graficas) +
tema_barras
ggplot2::ggplot(tabla_global, ggplot2::aes(x=CampoProductor,y=hi)) +
ggplot2::geom_col(fill="#286492",color="#244861",width=.72,linewidth=.36) +
ggplot2::geom_text(ggplot2::aes(label=sprintf("%.2f%%",100*hi)),vjust=-.48,
size=4.3,fontface="bold",color="#15364C") +
escala_campos +
ggplot2::scale_y_continuous(limits=c(0,limite_hi_global),
breaks=seq(0,1,by=.2),labels=etiqueta_pct,
expand=ggplot2::expansion(mult=c(0,0))) +
ggplot2::coord_cartesian(clip="off") +
ggplot2::labs(title="Gráfica N° 4: Frecuencia relativa (hᵢ) global",
x="Campo productor",y="Frecuencia relativa (%)",caption=fuente_graficas) +
tema_barras
leyenda <- paste0(stringr::str_wrap(as.character(tabla_local$CampoProductor),width=23),
" — ",sprintf("%.2f%%",tabla_local$porcentaje))
ggplot2::ggplot(tabla_local,ggplot2::aes(x=1,y=ni,fill=CampoProductor)) +
ggplot2::geom_col(width=1,color="#244861",linewidth=.48) +
ggplot2::coord_polar(theta="y",start=0) +
ggplot2::scale_fill_manual(values=colores,labels=leyenda) +
ggplot2::labs(title="Gráfica N° 5: Distribución porcentual por campo productor",
fill="Campo productor — porcentaje",caption=fuente_graficas) +
ggplot2::theme_void(base_size=15) +
ggplot2::theme(
plot.title=ggplot2::element_text(hjust=.5,face="bold",size=17,color="#15364C"),
plot.subtitle=ggplot2::element_text(hjust=.5,size=12,color="#49657A",
margin=ggplot2::margin(t=7,b=12)),
legend.position="right",
legend.title=ggplot2::element_text(face="bold",size=13,color="#15364C"),
legend.text=ggplot2::element_text(size=12,color="#253B4B",lineheight=1.05),
legend.key.size=grid::unit(.56,"cm"),
plot.caption=ggplot2::element_text(hjust=0,face="italic",size=10.5,
color="#546775",margin=ggplot2::margin(t=14)),
plot.margin=ggplot2::margin(18,30,25,24)
)
cat(crear_indicadores())
| VARIABLE ANALIZADA | Media (X̄) | Mediana (Me) | Moda (Mo) | Desviación estándar (Sd) | Coeficiente de variación (CV %) | Asimetría (As) | Curtosis (K) | Valores atípicos (Outliers) |
|---|---|---|---|---|---|---|---|---|
| PRODUCING_FIELD (Campo productor) | N/A | N/A | Richburg | N/A | N/A | N/A | N/A | N/A |
N/A: No aplicable a una variable cualitativa nominal.
Registros válidos (N): 41.785 | Categorías: 353 | Frecuencia modal: 11.659 | Porcentaje modal: 27.90%.
Fuente: Oil, Gas & Other Regulated Wells: Beginning 1860.
La variable PRODUCING_FIELD (Campo productor) es cualitativa nominal y presenta 353 categorías en 41.785 registros válidos. La moda corresponde a Richburg, con una frecuencia de 11.659 pozos (27.90% del total), lo que evidencia una mayor concentración de registros en determinados campos productores del estado de Nueva York.
Autor: Jennifer Cordones | Análisis Estadístico — Oil, Gas & Other Regulated Wells - NY State