X.Y. Hu

Data Analysis

Cleaned, analyzed, and visualized student demographic and cohort data using Python and Tableau to support fundraising and program evaluation. Conducted content analysis on exit interview transcripts to extract insights on student experiences. Collaborated with program staff to design dashboards and reports highlighting student performance.

Core Team Member

Collaborated on a sustainability initiative for a major North American coffee brand, integrating geospatial and demographic data to select pilot locations for a plant-based menu rollout. Conducted competitor analysis and received climate change training, contributing to strategies for reducing carbon emissions.

Market Research Intern

Conducted quantitative and qualitative research on consumer behavior in the electric vehicle market across Europe and Asia. Synthesized findings into actionable reports with data visualizations, supporting strategic decision-making for clients.

Gap in Objective and Subjective Social Status Using China General Social Survey (CGSS)

Cleaned and analyzed China GSS survey data in Python and R to investigate mismatches between subjective social status and actual income. Applied latent class analysis (LCA) and hierarchical linear modeling (HLM) to identify demographic and socioeconomic drivers of the mismatch. Created visualizations and compiled findings into a research report on status perception and inequality in contemporary Chinese society.

Sentiment Analysis of Uber Driver Subreddit

• Preprocessed 800+ subreddit posts using NLTK for text cleaning and tokenization; employed various vectorization techniques for better interpretability.
• Performed sentiment analysis using Sentiment Intensity Analyzer (SIA) and implemented Latent Dirichlet Allocation (LDA) for topic modeling, identifying key themes and sentiment distribution across discussions.
• Visualized findings through heatmaps and grouped sentiment scores by topic to reveal nuanced insights on driver experiences, which were presented in a comprehensive project report.

Lab of Adult Development and Interpersonal Relationship (LADIR)

• Collected and synthesized literature on aging psychology; produced summary reports on social priming methods for current study planning.
• Translated and culturally adapted test materials for Chinese participants; programmed three E-Prime experimental conditions and implemented a screening survey using Qualtrics.
• Developed a standardized data collection protocol to ensure methodological consistency across lab members.

Interactive Art and Community Engagement Project

• Collaboratively conceptualized project themes and interactive design; created prompts and led feedback evaluation to ensure alignment with post-pandemic societal dialogue goals.
• Directed development of promotional materials and social media strategy, reaching thousands of viewers; managed logistics for the public opening ceremony.

Social Practice Project: A Study on Higher Education in China

• Literature review: Synthesized insights on the status quo of higher education in China through a review of over 50 scholarly sources.
• Quantitative analysis: Designed and implemented a structured questionnaire to collect quantitative data, employing data analyses to gain a comprehensive understanding of college students, leveraging a sizable sample size.
• Qualitative analysis: Orchestrated the development of an interview outline and facilitated in-depth interviews with more than 20 participants. Directed the qualitative coding process for over 1000 entries, utilizing Excel and Word for systematic data organization, and conducted theme analysis based on codes.
• Leadership and organization: Hosted methodology workshops for team members and led the team in conducting interviews, coding, and compiling reports, demonstrating strong leadership and organizational skills.

Columbia University

GPA: 4.03/4.33