df <- read.csv('~/Downloads/readthedocs_traffic_analytics_gdal_2024-11-01_2025-01-30.csv')
driver_hits <- df |>
  filter(str_detect(Path, fixed('/drivers/'))) |>
  mutate(Path = str_remove(Path, '.*/drivers/')) |>
  separate(Path, sep='/', into=c('type', 'page')) |>
  mutate(page = str_remove(page, '.html')) %>%
  filter(page != 'index') |>
  group_by(type, page) |>
  summarize(hits = sum(Views)) |>
  group_by(type) |>
  mutate(ranking=rank(desc(hits), ties.method="first"))
## Warning: Expected 2 pieces. Additional pieces discarded in 1 rows [2038].
## Warning: Expected 2 pieces. Missing pieces filled with `NA` in 8 rows [181, 1253, 1900,
## 3034, 3398, 3890, 5399, 5755].
## `summarise()` has grouped output by 'type'. You can override using the
## `.groups` argument.
driver_hits |> filter(type == 'raster') |> select(ranking, hits, page) |> arrange(ranking) |> kable()
## Adding missing grouping variables: `type`
type ranking hits page
raster 1 3782 gtiff
raster 2 1615 vrt
raster 3 1580 cog
raster 4 906 mbtiles
raster 5 660 netcdf
raster 6 657 ecw
raster 7 626 pdf
raster 8 575 wms
raster 9 492 nitf
raster 10 409 jpeg
raster 11 373 gpkg
raster 12 372 xyz
raster 13 307 dted
raster 14 293 aaigrid
raster 15 289 wmts
raster 16 275 zarr
raster 17 270 jp2openjpeg
raster 18 262 grib
raster 19 242 sentinel2
raster 20 227 openfilegdb
raster 21 212 png
raster 22 210 jp2ecw
raster 23 180 hdf5
raster 24 172 mem
raster 25 166 mrsid
raster 26 165 gti
raster 27 138 hdf4
raster 28 129 srtmhgt
raster 29 129 webp
raster 30 127 bag
raster 31 125 wld
raster 32 117 envi
raster 33 96 postgisraster
raster 34 93 zmap
raster 35 88 georaster
raster 36 88 hfa
raster 37 84 jp2kak
raster 38 84 stacta
raster 39 83 avif
raster 40 77 rasterlite
raster 41 76 jpegxl
raster 42 76 nitf_advanced
raster 43 74 pds
raster 44 73 wcs
raster 45 70 basisu
raster 46 68 cad
raster 47 67 ehdr
raster 48 67 s102
raster 49 60 eedai
raster 50 60 tiledb
raster 51 59 arcinfo_grid_format
raster 52 59 snap_tiff
raster 53 58 lcp
raster 54 57 gxf
raster 55 57 pds4
raster 56 57 stacit
raster 57 56 vrt_processed_dataset
raster 58 54 usgsdem
raster 59 53 safe
raster 60 52 Idrisi
raster 61 52 isis3
raster 62 47 adrg
raster 63 46 aig
raster 64 46 heif
raster 65 46 r
raster 66 46 rraster
raster 67 45 pcidsk
raster 68 45 sdat
raster 69 43 gif
raster 70 43 kea
raster 71 42 map
raster 72 42 ntv2
raster 73 41 dimap
raster 74 41 ogcapi
raster 75 41 rasterlite2
raster 76 40 elas
raster 77 40 exr
raster 78 40 msg
raster 79 39 gsbg
raster 80 39 pcraster
raster 81 38 byn
raster 82 38 cosar
raster 83 38 ngsgeoid
raster 84 37 ers
raster 85 37 esric
raster 86 37 rmf
raster 87 36 bmp
raster 88 36 marfa
raster 89 36 rpftoc
raster 90 35 bsb
raster 91 35 gs7bg
raster 92 34 s104
raster 93 33 ace2
raster 94 33 blx
raster 95 31 grass
raster 96 31 ktx2
raster 97 30 fits
raster 98 30 kmlsuperoverlay
raster 99 29 loslas
raster 100 28 dds
raster 101 28 genbin
raster 102 28 gsag
raster 103 28 gta
raster 104 28 jp2lura
raster 105 28 sar_ceos
raster 106 27 jp2mrsid
raster 107 27 ozi
raster 108 27 plmosaic
raster 109 27 terragen
raster 110 26 grassasciigrid
raster 111 26 vrt_multidimensional
raster 112 25 airsar
raster 113 25 ceos
raster 114 25 nwtgrd
raster 115 24 derived
raster 116 24 isg
raster 117 23 ecrgtoc
raster 118 23 xpm
raster 119 22 jpipkak
raster 120 22 sigdem
raster 121 22 srp
raster 122 21 daas
raster 123 21 gff
raster 124 21 ilwis
raster 125 21 msgn
raster 126 21 s111
raster 127 20 ctable2
raster 128 20 hf2
raster 129 20 iris
raster 130 20 jdem
raster 131 20 l1b
raster 132 20 vicar
raster 133 19 bt
raster 134 19 isce
raster 135 19 isis2
raster 136 18 cals
raster 137 18 fit
raster 138 18 ngw
raster 139 18 rdb
raster 140 18 tga
raster 141 17 ctg
raster 142 17 esat
raster 143 17 til
raster 144 16 kro
raster 145 15 leveller
raster 146 15 ndf
raster 147 15 palsar
raster 148 14 sgi
raster 149 14 wms)
raster 150 13 doq2
raster 151 13 gtiffNo
raster 152 13 noaa_b
raster 153 13 pnm
raster 154 13 rcm
raster 155 13 rik
raster 156 13 rs2
raster 157 12 doq1
raster 158 12 gsc
raster 159 12 lan
raster 160 12 prf
raster 161 12 sdts
raster 162 11 eir
raster 163 11 mff2
raster 164 11 nsidcbin
raster 165 11 roi_pac
raster 166 11 snodas
raster 167 11 tsx
raster 168 10 cpg
raster 169 10 intergraphraster
raster 170 10 mff
raster 171 9 coasp
raster 172 9 dipex
raster 173 9 paux
raster 174 8 jpeg2000
raster 175 7 fast
raster 176 5 geotiff
raster 177 5 gtiff.htm
raster 178 5 libertiff
raster 179 3 driver_summary
raster 180 3 palsar.htm
raster 181 3 wms_openstreetmap_tms.xml
raster 182 2 ecw.htm
raster 183 2 jp2openjpeg.htm
raster 184 2 miramon
raster 185 2 wms.htm
raster 186 1 MEM
raster 187 1 MFF2
raster 188 1 PCRASTER
raster 189 1 Sentinel2
raster 190 1 WMS.htm
raster 191 1 ascii
raster 192 1 dods
raster 193 1 filegdb
raster 194 1 geotif
raster 195 1 index%E3%80%82
raster 196 1 index)
raster 197 1 jp2openjpeg%7D
raster 198 1 levelller
raster 199 1 mg4lidar
raster 200 1 netcdf_vector
raster 201 1 nitf,
raster 202 1 opencl
raster 203 1 ovr
raster 204 1 rda
raster 205 1 rpc
raster 206 1 s3
raster 207 1 sde
raster 208 1 sentL2A%E3%81%A7%E9%9B%B2%E3%81%A8%E5%BD%B1%E3%82%92%E9%99%A4%E5%8E%BB%E3%81%99%E3%82%8B%E3%81%AE%E3%81%8C%E7%9B%AE%E7%9A%84%E3%81%AA%E3%81%AE%E3%81%A7%E3%80%81%E3%81%AA%E3%82%93%E3%81%A8%E3%81%8B%E3%81%9D%E3%82%8C%E3%81%AB%E3%81%82%E3%81%A3%E3%81%9F%E6%96%B9%E6%B3%95%E3%82%92%E8%80%83%E3%81%88%E3%81%9F%E3%81%84%E3%81%A7%E3%81%99%E3%81%AD%E3%80%82inel2
raster 209 1 twms_clementine.xml
raster 210 1 twms_daily.xml
raster 211 1 vrt%3C
raster 212 1 wms_wmts_cache 
driver_hits |> filter(type == 'vector') |> select(ranking, hits, page) |> arrange(ranking) |> kable()
## Adding missing grouping variables: `type`
type ranking hits page
vector 1 2396 shapefile
vector 2 1298 gpkg
vector 3 1073 geojson
vector 4 1033 pg
vector 5 1005 cad
vector 6 909 openfilegdb
vector 7 896 csv
vector 8 772 mvt
vector 9 696 filegdb
vector 10 605 parquet
vector 11 535 s57
vector 12 521 xlsx
vector 13 514 osm
vector 14 493 gml
vector 15 488 dxf
vector 16 348 mssqlspatial
vector 17 342 sqlite
vector 18 331 dwg
vector 19 283 pmtiles
vector 20 269 flatgeobuf
vector 21 254 kml
vector 22 253 gpx
vector 23 244 libkml
vector 24 228 vrt
vector 25 219 mitab
vector 26 210 oci
vector 27 182 pdf
vector 28 175 wfs
vector 29 168 oda
vector 30 167 dgnv8
vector 31 166 mysql
vector 32 154 dgn
vector 33 153 pgeo
vector 34 140 geojsonseq
vector 35 125 arrow
vector 36 124 pg_advanced
vector 37 122 gmlas
vector 38 120 nas
vector 39 120 xodr
vector 40 114 esrijson
vector 41 102 xls
vector 42 101 odbc
vector 43 101 svg
vector 44 97 memory
vector 45 90 pgdump
vector 46 90 tiger
vector 47 86 eeda
vector 48 85 netcdf
vector 49 80 jsonfg
vector 50 73 carto
vector 51 71 oapif
vector 52 69 sosi
vector 53 62 amigocloud
vector 54 62 topojson
vector 55 60 vdv
vector 56 59 sxf
vector 57 48 ods
vector 58 48 tiledb
vector 59 45 aivector
vector 60 45 selafin
vector 61 43 vfk
vector 62 42 elasticsearch
vector 63 41 csw
vector 64 40 miramon
vector 65 40 ogdi
vector 66 38 avce00
vector 67 36 gmt
vector 68 32 ili
vector 69 32 lvbag
vector 70 31 gpsbabel
vector 71 28 avcbin
vector 72 28 georss
vector 73 28 idb
vector 74 28 mapml
vector 75 28 mongodbv3
vector 76 28 sdts
vector 77 27 adbc
vector 78 27 edigeo
vector 79 27 geoconcept
vector 80 25 ntf
vector 81 24 sde
vector 82 21 ngw
vector 83 21 wasp
vector 84 19 hana
vector 85 18 gtfs
vector 86 18 pds
vector 87 17 jml
vector 88 16 plscenes
vector 89 13 gmlas_metadata_layers
vector 90 13 grass
vector 91 11 geopackage_aspatial
vector 92 10 gmlas_mapping_examples
vector 93 10 idrisi
vector 94 9 geomedia
vector 95 9 gpkg_spatialite_computed_geom_column
vector 96 6 plscenes_data_v1
vector 97 5 mapinfo
vector 98 5 mssqlspatial.
vector 99 5 ogr_arch
vector 100 4 mdb
vector 101 4 segukooa
vector 102 3 pmtiles%20https:
vector 103 2 aeronavfaa
vector 104 2 driver_summary
vector 105 2 gpx).
vector 106 2 ingres
vector 107 2 openair
vector 108 2 svg.htm
vector 109 2 vrt.htm
vector 110 1 %20openfilegdb
vector 111 1 citygml
vector 112 1 dbf
vector 113 1 dods
vector 114 1 eeda)%EF%83%81vector
vector 115 1 fme
vector 116 1 geoconcept)
vector 117 1 gft
vector 118 1 gtm
vector 119 1 mssqlspatial.htm
vector 120 1 nas.hmtl
vector 121 1 nde
vector 122 1 ndex
vector 123 1 openfilegdb.h%E2%80%A6
vector 124 1 segy
vector 125 1 xplane