Comparison Unit price vs Fuel type
Name of stations vs State
A glimpse of the data
| Unnamed: 0.1 | Unnamed: 0 | SiteId | Site_Name | Site_Brand | Sites_Address_Line_1 | Site_Suburb | Site_State | Site_Post_Code | Site_Latitude | Site_Longitude | Fuel_Type | Price | TransactionDateutc | X_id | unit_price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1 | 61290151 | Liberty Surat | Liberty | 61 Burrowes Street | Surat | QLD | 4417 | -27.151687 | 149.067742 | Diesel | 1999 | 2023-10-12 21:56:00 | NaN | 1.999 |
| 1 | 1 | 2 | 61290151 | Liberty Surat | Liberty | 61 Burrowes Street | Surat | QLD | 4417 | -27.151687 | 149.067742 | PULP 98 RON | 2159 | 2023-12-30 06:54:00 | NaN | 2.159 |
| 2 | 2 | 3 | 61290151 | Liberty Surat | Liberty | 61 Burrowes Street | Surat | QLD | 4417 | -27.151687 | 149.067742 | Unleaded | 1959 | 2023-12-30 06:54:00 | NaN | 1.959 |
| 3 | 3 | 4 | 61291313 | Lowes Mungindi Opt | BP | 126 Barwon Street | Mungindi | QLD | 4497 | -28.973467 | 148.983829 | Diesel | 1990 | 2023-06-12 22:00:00 | NaN | 1.990 |
| 4 | 4 | 5 | 61291313 | Lowes Mungindi Opt | BP | 126 Barwon Street | Mungindi | QLD | 4497 | -28.973467 | 148.983829 | Unleaded | 1920 | 2023-06-12 22:00:00 | NaN | 1.920 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 615624 | 615972 | 615973 | 61478211 | Metro Petroleum Walkerston | Metro Fuel | 2 Dutton St | Walkerston | QLD | 4751 | -21.160166 | 149.063728 | Unleaded | 1959 | 2023-09-20 05:14:00 | NaN | 1.959 |
| 615625 | 615973 | 615974 | 61478211 | Metro Petroleum Walkerston | Metro Fuel | 2 Dutton St | Walkerston | QLD | 4751 | -21.160166 | 149.063728 | Unleaded | 1989 | 2023-09-25 08:08:00 | NaN | 1.989 |
| 615626 | 615974 | 615975 | 61478212 | Pitt Stop Classic Café | Independent | 34 Palm Ave | Seaforth | QLD | 4741 | -20.899741 | 148.964986 | Unleaded | 2049 | 2023-04-09 04:15:00 | NaN | 2.049 |
| 615627 | 615975 | 615976 | 61478212 | Pitt Stop Classic Café | Independent | 34 Palm Ave | Seaforth | QLD | 4741 | -20.899741 | 148.964986 | Unleaded | 2039 | 2023-04-09 04:24:00 | NaN | 2.039 |
| 615628 | 615976 | 615977 | 61478212 | Pitt Stop Classic Café | Independent | 34 Palm Ave | Seaforth | QLD | 4741 | -20.899741 | 148.964986 | Unleaded | 2099 | 2023-09-25 06:26:00 | NaN | 2.099 |
615629 rows × 16 columns
Statistics unit price
count 615629.000000
mean 2.006312
std 0.196784
min 0.799000
25% 1.869000
50% 1.999000
75% 2.139000
max 3.610000
Name: unit_price, dtype: float64Average price $:
2.006312449543475