- Performed time series analysis and visualizations using Python on over 35,000 rows of National Renewable Energy Laboratory's End-Use Load Profiles to evaluate county-level energy consumption.- Analyzed over 1,000 rows of Vehicle Miles Traveled (VMT) data by census tract in Chicago using Replica's activity-based model; examined national OD travel behavior data from the National Household Travel Survey using Python; contributed to the Climate Action Plan for urban densification.-… Show more - Performed time series analysis and visualizations using Python on over 35,000 rows of National Renewable Energy Laboratory's End-Use Load Profiles to evaluate county-level energy consumption.- Analyzed over 1,000 rows of Vehicle Miles Traveled (VMT) data by census tract in Chicago using Replica's activity-based model; examined national OD travel behavior data from the National Household Travel Survey using Python; contributed to the Climate Action Plan for urban densification.- Authored a memo detailing data generation processes in R for the Motor Vehicle Emission Simulator (MOVES) model, for vehicle classification and assessing the impact of electric vehicles on transportation emissions; developed the suggestions for regional transit strategies. Show less

- Helped organize several international planning lectures and alumni meetups to help students discuss and network about international planning practices and job opportunities for international students. - Conducted feedback for the department from international students to address their challenges. - Organized multicultural potluck events, promoting diversity and cultural exchange within the university community.

- Conducted geospatial data analysis by Python and ArcGIS Pro about transportation carbon emissions.- Developed algorithms for merging road network and POI data from multiple sources, including OpenStreetMap (OSM), Overture map, TIGER/Line shapefiles, and Google API data.- Developed and implemented distinct methods for merging different data categories by symmetry and geometry, used space indexing and spatial interpolation to optimize data accuracy and integrity by 17%.

- Classified and visualized urban density data of the 200 global major cities by R by Atlas of Urban Expansion, compared and classified the factors of density growth or shrinkage by a report.- Conducted a literature review about the transportation pattern of waste in the Global South.- Digitalized the spatiotemporal trajectory of Chinese enterprises’ workers in Ethiopia by ArcGIS, analyzed the spatial pattern of over 1,000 infrastructure investment POIs in African countries by Python.

- Compared the transportation and infrastructure planning regulations of 10 cities in Guangdong; participated in the formulation of the urban and rural planning technical regulations of Qingyuan.- Wrote strategic planning reports on the transportation patterns and logistics planning for integrated rail, airport, and port systems in the development of Guangzhou’s northern airport economic corridor, with a focus on Transit-Oriented Development (TOD) for the 2049 planning vision. -… Show more - Compared the transportation and infrastructure planning regulations of 10 cities in Guangdong; participated in the formulation of the urban and rural planning technical regulations of Qingyuan.- Wrote strategic planning reports on the transportation patterns and logistics planning for integrated rail, airport, and port systems in the development of Guangzhou’s northern airport economic corridor, with a focus on Transit-Oriented Development (TOD) for the 2049 planning vision. - Utilized a gravity-based method in ArcGIS to analyze walkability for over 20 metro stations in Suzhou's historical area; conducted stakeholder interviews on transit accessibility. Show less

Natural Science Foundation of China Project - Disaster Resilience: Identification of Key Factors for Multi-dimensional Disaster Resilience: A Case Study of Suzhou City. - Led and managed a team of 15 members to conduct a 300-person survey on residents' subjective attitudes towards community resilience in various communities in Suzhou.- Managed, cleaned, and analyzed the survey data using R and Excel.- Reviewed literature on community resilience, extracted six community… Show more Natural Science Foundation of China Project - Disaster Resilience: Identification of Key Factors for Multi-dimensional Disaster Resilience: A Case Study of Suzhou City. - Led and managed a team of 15 members to conduct a 300-person survey on residents' subjective attitudes towards community resilience in various communities in Suzhou.- Managed, cleaned, and analyzed the survey data using R and Excel.- Reviewed literature on community resilience, extracted six community resilience-related factors using R, established and visualized generalized linear mixed models; discovered community resilience has a correlation with collective efficacy and pre-disaster preparedness. Show less

Summer Undergraduate Research Fellowship: Game Design that can Support Rural Revitalization - Reviewed the history of development and human-environment relationship of rural settlements in southern Jiangsu; classified more than 40 villages according to landscape- Conducted semi-structured interviews with residents of Donglindu Village; analyzed the relationships among stakeholders.- Conceptualized a game platform for rural revitalization education, and evaluated the results of… Show more Summer Undergraduate Research Fellowship: Game Design that can Support Rural Revitalization - Reviewed the history of development and human-environment relationship of rural settlements in southern Jiangsu; classified more than 40 villages according to landscape- Conducted semi-structured interviews with residents of Donglindu Village; analyzed the relationships among stakeholders.- Conceptualized a game platform for rural revitalization education, and evaluated the results of collaborative design through online voting and simulation. Show less

Lecturer of 2020/21 Semester 2 Optional Course -Digital Painting at XJTLU- Developed plan and curriculum syllabus of 10 lectures; tutored 30 undergraduate students on painting.- Maintained a group of 50+ students to support the study and for queries about digital painting.- Organized recruitment of members and off-campus tutors; invited and communicated with local artists.- Operated influencer accounts with 1000+ followers and 20000 page views; published artworks and articles.

Collecting and Managing Data from China Real Estate Index System - Collected and managed millions of real estate transaction data in eight Chinese cities from 2015 to 2021; filled the data by category using Python and Excel.