This is a Portfolio of my projects at works and in the UofT Boot Camp
University of Toronto SCS (School of Continuing Studies) Boot Camp, Data analytics (2021-06) Link is an innovative, part-time program teaching participants market-driven skills: Learn Advanced Excel, Python, JavaScript (D3.js, Leaflet.js), HTML5/CSS, API Interactions, Social Media Mining, SQL, Tableau, Fundamental Statistics, Machine Learning, R, and Git/GitHub.
As an industrial engineer, I dealt with data in manufacturing companies with SQL, Excel VBA, Access, and so on. I could understand the way that data works and what business and operation departments really need. As time goes by, new techs lead the trend of data mining and visualization. Then I came to the point to catch up. After a 6-month condensed study of Data Analytics, many skills & tools have become acquainted to me.
The project data in SE and HyperfineAutos will keep confidential.
Part-time Contract Position 2021.10 - 2022.01
The task is to transfer data from an old platform to the new platform. Item_ids for the same item on the two platforms are different and irrelevant. Item names and discriptions are not exactily the same, too. Compare the item name on the two platforms, then link the two names for each item. Nested loop needs nearly a billion comparison. The team was planed to do it with VBA, but I used Python and filtered data in advance to make it possible.
Techs & Tools : Python pandas difflib
The PlanMyTrip app (Repo Link M6) is recommended a few changes to be taken to the next level. Specifically, they recommend adding the weather description to the weather data you’ve already retrieved in this module. Then, add statements to filter the data for the weather preferences, which will be used to identify potential travel destinations and nearby hotels. From the list of potential travel destinations, the beta tester will choose four cities to create a travel itinerary. Finally, using the Google Maps Directions API, a travel route between the four cities as well as a marker layer map is created.
Techs & Tools : Python pandas jupyter notebook API Google Map API matplotlib.pyplot citipy requests gmaps json
The project (Repo Link M5) analyzed all the rideshare data from January to early May of 2019 and create a compelling visualization for the CEO. Pandas is used to manapulate the data, and Matplotlib is used for the visualization.
Techs & Tools : Python pandas Matplotlib jupyter notebook
The project (Repo Link M4) analyzed the performance of the students in each high school in a district, using pandas.DataFrame, numpy, jupyter notebook, including the average math&reading scores and passing rate of each school, and by grade/ budget/ school size/ school type.
Techs & Tools : Python pandas numpy jupyter notebook
The project (Repo Link M3) is an analysis with Python and external files: .csv and .txt files.
Techs & Tools : Python CSV
Part-time volunteering consulting position since 2019
...Tobe edited
The project (Repo Link M2) is the data searching and visualization in EXCEL VBA. Based on historical exchange data, the customer can select stocks to see their performances ran by Macro.
Techs & Tools : Excel VBA, InputBox, 'If' Condition, 'For' Loop, Run-time tracing, Conditional Formatting
The project (Repo Link M1) is the data analysis and visualizaiton using EXCEL. No matter how far data analysis develops, Excel is always the Alpha. Using Excel for nearly 20 years, there are still some new functions that can be discovered, regardless of the new version. Using the data of over 4000 crowdfunding projects needs to be organized and visualized for the manager to analyze easily.
Techs & Tools : Excel Macro, UNIX timestamp, Pivot table, Formulas, Charts, Charts Editing, COUNTIFS(), Conditional Formatting
- Gitbash
- SSH Gitbash SSH
- GitHub desktop
- VS code - Work Space
CMD line Jupyter Notebook quick links Most Frequent Used Markdown Syntax Link