Tianqi Xu

• Project Overview: Worked as the key member in the course project, contributed to the data collection and analysis part
• Data Collection: Leveraged Reddit's API using Python to extract 2,000 posts from two opposite abortion groups and their associated comments;Executed data cleaning and preprocessing to ensure dataset accuracy and readiness for analysis.
• Content Analysis: Employed computer-assisted content analysis techniques to conduct topic classification across the dataset, identifying key themes and trends; Analyzed sentiment using a fine-tuned BERT model called PySentimiento to perform classification tasks on sentiment.
• Results Interpretation: Integrated results from qualitative and quantitative methods to gain deeper insights into the ideological split across different groups

Volunteered in the Climate Assembly, Faculty of Social Science:

• Engaged in discussions and debates, contributing to the drafting of sustainability recommendations.
• Participated in voting to prioritize impactful initiatives, leading to the adoption of energy-saving measures that advanced the university’s sustainability goals.

• Project Overview: Contributed to the questionnaire design and data analysis process for the 2021 Undergraduate Teaching Satisfaction Survey in the Department of Planning and Development
• Questionnaire Design: Conducted literature review and facilitated seminars to define key indicators and design robust models for the questionnaire
• Data Analysis: Led data preprocessing and further analysis using SPSS, synthesized findings into strategic reports that informed decision-making at the departmental level