Data Analysis with Python
All databases cleaned, arranged, analyzed and plotted using Python (modules Pandas, NumPy, SciPy and Matplotlib)
FUEL CONSUMPTION OF A MOTORCYCLE
Inputs:
Database of each refill of a motorcycle used in city and open road.
Outputs:
Executive summary with fuel consumption performance by type of use and pie plot of kilometers traveled:
________________________________________________________________
ANALYSIS OF FAILURES OF A FLEET OF BUSES
Inputs:
Database of the failures on road and database of the Fleet characteristics.
Outputs:
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
Inputs:
Database of station prices of 13 types of fuel in 33 regions of Colombia.
Outputs:
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
Inputs:
Database of daily USDCOP exchange rate by the Central Bank of Colombia.
Outputs:
Time serie of daily value and trend since 2018:
Projection from trend compared to actual values:
________________________________________________________________
METEOROLOGICAL DATA OF BOGOTÁ & BARRANQUILLA
Inputs:
Database of hourly meteorological data of Bogotá and Barranquilla, Colombia, for a complete year.
Outputs:
Violin plot of the probability distributions of ambient temperature:
Cumulative Density Function plot of ambient temperature: