weihaolun Goto Github PK

amazon_vine_analysis

AWS Project: AWS RDS, PySpark, ETL, pgAdmin, SQL, Pandas.

belly-button-biodiversity

JavaScrip Project: JavaScript, HTML, CSS, Dashboard, json, Bootstrap.

bikesharing

Tableau Project: Tableau; Dashboard; Workbook; Tableau Story; Python; Panda.

credit_risk_analysis

Supervised Machine Learning Project: imbalanced-learn; scikit-learn; RandomOverSampler; SMOTE; ClusterCentroids; SMOTEENN; BalancedRandomForestClassifier; EasyEnsembleClassifier.

cryptocurrencies

election-analysis

Python Analysis Project: Load, Read and Export files; CSV Module; Write to txt. file; Loops; For Loops; If statement; Calculation; Determine; Formatting.

kickstarter-analysis

Excel Analysis project: Pivot Table, Pivot Chart, Vlookup, COUNTIFS, Analysis Visualization.

linear_regression_salary

mapping_earthquakes

JavaScript Leaflet project: GeoJSON; JavaScript; D3; Leaflet; Mapbox; API.

mechacar_statistical_analysis

Statistics and R: R, linear Regression, Multiple Linear Regression, t-test, Summary Statistics, Study Design, ANOVA test

mission-to-mars

Web Scraping Project: NoSQL; HTML; BeautifulSoup; Splinter; web scraping; MongoDB; Flask; CSS; Bootstrap.

movies-etl

neural_network_charity_analysis

pewlett-hackard-analysis

SQL Project: PostgreSQL, SELECT, ORDER BY, DISTINCT, WHERE, AND, BETWEEN, INNER JOIN, GROUP BY, COUNT

pyber_analysis

Matplotlib project: Merge DataFrame; groupby.(); Create DataFrame; pivot(); loc time range; resample(); object-oriented interface; multiple-line chart.

school-district-analysis

Python & Pandas Analysis Project: Read and external CSV into DataFrame; Retrieve data from DataFrame; Data cleaning; Merge, filter, slice and sort; groupby; loc; replace; bins&cut; function; calculation; create DataFrame; format DataFrame.

stock-analysis

Excel VBA project: Loops, Nested Loops, If-then statement, Arrays, Static Formatting, Conditional Formatting, Run Analysis for different years, Code Performance Measurement, Code Refactoring.

surfs_up

SQLite Project: SQLite; SQL Alchemy; Flask; Python.

twitter-sentiment-analysis

twitter-visualization

ufo-analysis

JavaScript Project: JavaScript Basics; Building Webpages with JavaScript; JavaScript for Loops; Building Dynamic Tables; Build the HTML; CSS; Bootstrap.

world-weather-analysis

Python API project: Pandas; CityPy; Python Requests; APIs; JSON Traversals; try/except; Python functions; Matplotlib; Linear Regression; heatmaps, Google Maps API.