Worked Projects
Tripper - the tour guide of the world 🌍
- User-friendly platform that allows tourists to easily match with local guides🧳/ reshape the way to make new frinds
- AI-powered interaction to provide real-time, knowledge-rich interactions and plan. 🤖
- A social forum where users can share and discuss their travel experiences, fostering community interaction and information sharing. 🗣️
🔧 技术栈 Tech Stack
Front End: React, JavaScript, HTML, CSS | Back End: FastAPI, Python, PostgreSQL, Docker | Webpage Design: Figma | Other Technologies: REST APIs, OAuth 2.0
Project Overview Video
For detailed information, please view the provided Materials
📄Detailed report for Tripper (PDF)For detailed Wireframe diagrams, please view the provided Materials
📄Figma_Wireframe for Tripper (PDF)🔑Key Functions
Navigation Simplicity
Sign in via email & password
Sign Up
for Tourists
for Tour Guides
Guide Matching/Filtering and Social Features
Search and Add New Contacts Feature
Homepage for Forum - Filtering/ Setting/ Creating thread
Thread Example
Personal AI Assistant
Users ask Tripper Rabbit to provide travel Plan
Tripper Rabbit provides detailed travelling plan in detail
Preview Page - Provides the preview for customized Attraction/ Restaurant/ Drink information
Attraction Details Card
Restaurant details Card
Backend
FastAPI endpoints
Entity relationship diagram of the forum
Details of each column in the attraction_details
Message entity relationship diagram
🌐Third-Party APIs
Navigator API & Google API Implementation
Bitcoin Price Prediction
This study aims to create an accurate sequence prediction model to forecast Bitcoin price trends. The publicly available dataset is from Kaggle, covering Bitcoin price data from May 5, 2013, to October 23, 2022.
Data Processing and Feature Engineering
Data Processing: Cleaned data, handled missing values and anomalies, converted timestamps to datetime format.
Feature Engineering: Calculated VWAP, selected monthly data to reduce noise, performed stationarity tests, and STL decomposition.
Dayly, Monthly, Seasonally and Yearly
Model Development
Implemented time series prediction through stationarity tests and parameter optimization
MSE, RMSE, MAE statistical histogram of 7 models
LightGBM: Improved training efficiency and prediction accuracy using histogram optimization and leaf-wise growth strategy.
XGBoost: Achieved high accuracy predictions by combining gradient boosting and regularization.
Transformer: Processed complex sequences efficiently through self-attention mechanisms and parallel processing.
Prophet: Modeled seasonality and trends in time series data.
LSTM: Captured long-term dependencies in time series data using long short-term memory networks.
SVM: Implemented classification and regression predictions through kernel functions and support vectors.
Model Comparison
Deep Learning Models: Performed best, effectively capturing long-term dependencies.
Seasonal Models: Handled seasonality and trends well.
Traditional Machine Learning Models: Struggled with long-term dependencies.
🔧 Tech Stack
Data Processing: Python, Pandas
Feature Engineering: VWAP, STL Decomposition
Machine Learning Models: ARIMA, LightGBM, XGBoost, SVM
Deep Learning Models: Transformer, LSTM
Time Series Models: Prophet
Libraries: scikit-learn, statsmodels, lightgbm, xgboost, pytorch, fbprophet
Evaluation Metrics: MSE, RMSE, MAE
Comprehensive Detailed Design& Research for a 22-story Podium Single Tower 🏢 Structure
- A complete Design Package including Design& Research Report, Engineering Drawings, and Calculation Report.
- Shear Core Design Assessment ensuring deflection and drifts at each level met Serviceability Limit State requirements.
- Structural Model Validation through comparison of 2D hand calculation results with 3D Finite Element Analysis outcomes.
🔧 Tech Stack
Structural Design: SAP2000, ETABS | Architectural Design: AutoCAD, Revit | Analysis: MATLAB, Python, Excel | Rendering: Twinmotion, Lumion | Documentation: Microsoft Office, LaTeX
Project Overview Video
🖼️ Rendering Pictures
22楼的商住混合高层建筑
停车场
停车场入口
Technical Drawings
📊 Detailed calculation report
Final Design Report
🏢Sustainable Design and Analysis of a Nine-Story Steel Frame Office Building
- Innovative Structural Solutions: Design of composite slabs, beams, and a cantilever truss system to address site-specific challenges.
- Robust Steel Framework: Detailed analysis and design of steel columns and wind bracing for optimal stability and resilience.
- Precise Connection Design: Meticulous engineering of beam-beam, beam-column, and bracing connections for structural integrity.
- Comprehensive Analysis: Parametric study to explore alternative approaches and drive future enhancements.
- Integrated Documentation: Extensive reporting with detailed drawings and calculations, ensuring transparency and precision in every aspect of the design.
🔧 Tech Stack
Structural Design: SAP2000, Autodesk Revit | Architectural Design: AutoCAD | Analysis: Python, MATLAB, Excel | Rendering: Twinmotion | Documentation: Microsoft Office, LaTeX
Steel Structure Detailed Design
Global Structural Model for Proposal 1 (SAP2000)
Global Structural Model for Proposal 2 (Autodesk)
Ground FloorArchitectural Layout
Design Criteria:Fire rating, deflection checks, and manufacturer’s data considered. | ULS and SLS Checks
3D View for Global Bracing System in Proposal 1 (Autodesk CAD)
Global layout of the bracing system (in SAP2000)
column-column connections (8 bolts per column)
Analysis of Hexagonal and Triangular Lattice Structures in MATLAB
- Simulated different loading scenarios for each model in MATLAB and Excel.
- Validated model accuracy with proposed refinements.