Data Analysis with Python
All databases cleaned, arranged, analyzed and plotted using Python (modules Pandas, NumPy, SciPy and Matplotlib)
FUEL CONSUMPTION OF A MOTORCYCLE
Database of each refill of a motorcycle used in city and open road.
Executive summary with fuel consumption performance by type of use and pie plot of kilometers traveled:
ANALYSIS OF FAILURES OF A FLEET OF BUSES
Database of the failures on road and database of the Fleet characteristics.
Pareto chart of root causes of failures on road, this was feedback for a preventive maintenance process:
Failures on road by brand of bus, showing the reliability of the different brands and helping decision of future vehicle purchases:
PRICE OF FUELS IN COLOMBIA
Database of station prices of 13 types of fuel in 33 regions of Colombia.
Average price of gasoline (regular and premium) and diesel fuel in the country by month:
Average price of regular gasoline in selected regions by month:
Price of regular gasoline in Capital City by brand from cheapest to most expensive in June of 2022:
List of the 5 cheapest stations in June 2022 for buying regular gasoline in the Capital City:
Address Price in June 2022 (COP)
AK 72 NO. 39 H-12 SUR 8459.00
CARRERA 53 No. 52B-11 SUR 8499.00
AVENIDA CARRERA 86 No. 42 F-18 SUR IN 2 8509.00
AVENIDA CALLE 134 No. 53-51 8509.00
CARRERA 72 No. 44B-39 SUR 8545.00
ANALYSIS OF USDCOP EXCHANGE
Database of daily USDCOP exchange rate by the Central Bank of Colombia.
Time serie of daily value and trend since 2018:
Projection from trend compared to actual values:
METEOROLOGICAL DATA OF BOGOTÁ & BARRANQUILLA
Database of hourly meteorological data of Bogotá and Barranquilla, Colombia, for a complete year.
Violin plot of the probability distributions of ambient temperature:
Cumulative Density Function plot of ambient temperature: