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
Home Page design
Navigation Simplicity
Registration and Login Functionality
Sign in via email & password
Registration and Login Functionality
Sign Up
User center
for Tourists
User center
for Tour Guides
Tour Guide Matching and Social Features
Guide Matching/Filtering and Social Features
Instant Messaging Interface
Search and Add New Contacts Feature
Instant Messaging Interface
Forum
Homepage for Forum - Filtering/ Setting/ Creating thread
Forum
Thread Example
AI Tripper Rabbit
Personal AI Assistant
AI Tripper Rabbit
Users ask Tripper Rabbit to provide travel Plan
AI Tripper Rabbit
Tripper Rabbit provides detailed travelling plan in detail
Explore
Preview Page - Provides the preview for customized Attraction/ Restaurant/ Drink information
Explore
Attraction Details Card
Explore
Restaurant details Card
Backend
FastAPI Framework
FastAPI endpoints
Database SQLite
Entity relationship diagram of the forum
Database SQLite
Details of each column in the attraction_details
Database Firebase
Message entity relationship diagram
🌐Third-Party APIs
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.
Close price against time
Dayly, Monthly, Seasonally and Yearly
Seasonal and Trend decomposition visualization
Model Development
ARIMA Model
Implemented time series prediction through stationarity tests and parameter optimization
Parameters Comparison
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
Overview
Overview
22楼的商住混合高层建筑
Overview
Car Parking Level
停车场
Car Parking Entrance
停车场入口
Technical Drawings
Car parking plan view
Elevation_view
Reinforcament Detailings
Reinforcament Detailings
Typical Level_Plan View
📊 Detailed calculation report
Detailed calculation report
Final Design Report
3D profile model acces design
Deflection contour for core frame and core FEA model
Deflection and drift comparison between 2D and 3D results
Design report final
FEA Analysis
FEA Model Level 2
HvAc energy comparison between double and single-layer glass curtains
Lighting comparison between flat slab and traditional beam-to-slab system
🏢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
OverView
Global Structural Model for Proposal 1 (SAP2000)
OverView
Global Structural Model for Proposal 2 (Autodesk)
OverView
Ground FloorArchitectural Layout
Composite Slabs Design
Design Criteria:Fire rating, deflection checks, and manufacturer’s data considered. | ULS and SLS Checks
Bracing Design
3D View for Global Bracing System in Proposal 1 (Autodesk CAD)
Bracing Design
Global layout of the bracing system (in SAP2000)
Isolated cantilever region
Connection design
column-column connections (8 bolts per column)
Beam Section with Critical Section
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.