Gas Prices in USA, historical analysis This report is intended to review gas prices in the USA historically for comparison against various claims. One such claim is that the sitting US President has a direct affect on gas prices. Data from the EIA - US Energy Information Administration This dataframe set GasPrices_eia_prices_1970_2022 comes from the EIA website as a downloadable CSV. The EIA provides an FAQ for using the data, which includes instructions to download the CSV and for a reference Excel document that helps with conversion. “To obtain the historical prices from the SEDS data, use the CSV file for All States—Prices. In the file, the code for gasoline prices for the transportation sector, in $/MMBtu , is: State Abbreviation (in column A) and MGACD (in column B). For example, the code for Alaska is AK—MGACD . Those prices, in $/MMBtu, can be converted to approximate dollars per gallon using the heat contents in Table A3 Petroleum consumption and fuel eth...