Embedded Files
Date:
August 2022
Role:
Freelancer
Colleagues:
Mrs. Hamideh Andevari
Mr. Milad Gashangi Agdam
Skills:
Python Programming Language
Pandas
Numpy
Business Intelligence
MS Power BI
Data Visualization
Abstract
The customer could not take advantage of his data since they were not structured. CSV files had rows with different formats, in which columns were different. Moreover, some features had string values which made analysis impossible. After making data structured using Pandas and NumPy in Python, string values were encoded. Then, I developed a Python script to convert every given CSV to a cleaned one with no strings and the same columns.
Left: Raw CSV / Right: CSV after data cleaning and conversions
Ultimately, different dashboards were designed in MS Power BI using the outputs of the script.
Google Sites
Report abuse