Worked Projects
Tripper - the tour guide of the world 🌍
![Logo](./pictures/pictures%20for%20projects/Tripper/tripper_logo.png)
- 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
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Home Page.png)
Home Page design
Navigation Simplicity
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Sign in 1.png)
Registration and Login Functionality
Sign in via email & password
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Sign Up Page.png)
Registration and Login Functionality
Sign Up
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/User center for Tourists.png)
User center
for Tourists
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/User center for Tour Guides.png)
User center
for Tour Guides
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Guide Matching and Social Features.png)
Tour Guide Matching and Social Features
Guide Matching/Filtering and Social Features
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Search and Add New Contacts Feature.png)
Instant Messaging Interface
Search and Add New Contacts Feature
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Instant Messaging Interface.png)
Instant Messaging Interface
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Home Page for Forum.jpg)
Forum
Homepage for Forum - Filtering/ Setting/ Creating thread
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/thread example.jpg)
Forum
Thread Example
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/AI Tripper Rabbit.png)
AI Tripper Rabbit
Personal AI Assistant
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Chat history With Tripper AI 1.png)
AI Tripper Rabbit
Users ask Tripper Rabbit to provide travel Plan
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Chat history With Tripper AI 2.png)
AI Tripper Rabbit
Tripper Rabbit provides detailed travelling plan in detail
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Explore Preview Page.png)
Explore
Preview Page - Provides the preview for customized Attraction/ Restaurant/ Drink information
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Attraction Details Card.png)
Explore
Attraction Details Card
![overview](./pictures/pictures%20for%20projects/Tripper/Functionality/Restaurant details Card.png)
Explore
Restaurant details Card
Backend
![overview](./pictures/pictures%20for%20projects/Tripper/backend/FastAPI endpoints.png)
FastAPI Framework
FastAPI endpoints
![overview](./pictures/pictures%20for%20projects/Tripper/backend/entity relationship diagram of the forum.png)
Database SQLite
Entity relationship diagram of the forum
![overview](./pictures/pictures%20for%20projects/Tripper/backend/details of each column in the attraction_details.png)
Database SQLite
Details of each column in the attraction_details
![overview](./pictures/pictures%20for%20projects/Tripper/backend/Message entity relationship diagram.png)
Database Firebase
Message entity relationship diagram
🌐Third-Party APIs
![overview](./pictures/pictures%20for%20projects/Tripper/apis/Navigator API & Google API Implementation.png)
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.
![overview](./pictures/pictures%20for%20projects/bitcoin price prediction/close price against time.png)
Close price against time
Dayly, Monthly, Seasonally and Yearly
![overview](./pictures/pictures%20for%20projects/bitcoin price prediction/Seasonal and Trend decomposition visualization.png)
Seasonal and Trend decomposition visualization
Model Development
![overview](./pictures/pictures%20for%20projects/bitcoin price prediction/ARIMA Model Prediction Result.png)
ARIMA Model
Implemented time series prediction through stationarity tests and parameter optimization
![overview](./pictures/pictures%20for%20projects/bitcoin price prediction/Diagram of MSE, RMSE, MAE statistical histogram of 7 models.png)
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](./pictures/pictures%20for%20projects/final_design_report/Rendering_pictures/Image 16.png)
Overview
![overview](./pictures/pictures%20for%20projects/final_design_report/Rendering_pictures/Image 18.png)
Overview
22楼的商住混合高层建筑
![overview](./pictures/pictures%20for%20projects/final_design_report/Rendering_pictures/Image 19.png)
Overview
![overview](./pictures/pictures%20for%20projects/final_design_report/Rendering_pictures/Image 23.png)
Car Parking Level
停车场
![overview](./pictures/pictures%20for%20projects/final_design_report/Rendering_pictures/Carparking.png)
Car Parking Entrance
停车场入口
Technical Drawings
![overview](./pictures/pictures for projects/final_design_report/Technical_dws/car_parking_plan_view.png)
Car parking plan view
![overview](./pictures/pictures for projects/final_design_report/Technical_dws/elevation_view.png)
Elevation_view
![overview](./pictures/pictures for projects/final_design_report/Technical_dws/reinforcament_detailings_2.png)
Reinforcament Detailings
![overview](./pictures/pictures for projects/final_design_report/Technical_dws/reinforcement_detailing.png)
Reinforcament Detailings
![overview](./pictures/pictures for projects/final_design_report/Technical_dws/typical_level_plan view.png)
Typical Level_Plan View
📊 Detailed calculation report
![overview](./pictures/pictures for projects/final_design_report/Detailed_calculation_report/detailed_calculation_report.png)
Detailed calculation report
Final Design Report
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/3D_profile_model_acces_design.png)
3D profile model acces design
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/Deflection contour for core frame and core FEA model.png)
Deflection contour for core frame and core FEA model
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/deflection_and_drift_comparison_between_2D_3D_results.png)
Deflection and drift comparison between 2D and 3D results
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/Design report final_06.png)
Design report final
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/FEA_Analysis.png)
FEA Analysis
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/FEA_Model_Level2.png)
FEA Model Level 2
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/HvAc energy comparison between double and single-layer glass curtains.png)
HvAc energy comparison between double and single-layer glass curtains
![overview](./pictures/pictures for projects/final_design_report/Final_Design_Report/Lighting comparison between flat slab and traditional beam-to-slab system.png)
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](./pictures/pictures for projects/steel structure design/Global Structural Model for Proposal 1 (SAP2000).png)
OverView
Global Structural Model for Proposal 1 (SAP2000)
![overview](./pictures/pictures for projects/steel structure design/Global Structural Model for Proposal 2 (Autodesk).png)
OverView
Global Structural Model for Proposal 2 (Autodesk)
![overview](./pictures/pictures for projects/steel structure design/Ground FloorArchitectural Layout.png)
OverView
Ground FloorArchitectural Layout
![overview](./pictures/pictures for projects/steel structure design/Composite Slab Design.png)
Composite Slabs Design
Design Criteria:Fire rating, deflection checks, and manufacturer’s data considered. | ULS and SLS Checks
![overview](./pictures/pictures for projects/steel structure design/3D View for Global Bracing System in Proposal 1 (Autodesk CAD).png)
Bracing Design
3D View for Global Bracing System in Proposal 1 (Autodesk CAD)
![overview](./pictures/pictures for projects/steel structure design/Global layout of the bracing system (in SAP2000).png)
Bracing Design
Global layout of the bracing system (in SAP2000)
![overview](./pictures/pictures for projects/steel structure design/Isolated cantilever region.png)
Isolated cantilever region
![overview](./pictures/pictures for projects/steel structure design/column-column connections (8 bolts per column).png)
Connection design
column-column connections (8 bolts per column)
![overview](./pictures/pictures for projects/steel structure design/Beam Section with Critical Section.png)
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.