Xiao Xu

Results-driven data analyst with experience at Zhengzhou Danyuange Technology Co., Ltd., proficient in Python and PowerBI. Successfully conducted in-depth data analysis and created impactful visualizations, enhancing decision-making processes. Strong collaborator, adept at responding to data inquiries, ensuring timely and accurate information delivery to stakeholders.

pandaspro - Enhanced Data Processing Python Package, Co-developed 

• pandaspro, an extended version of Pandas designed for efficient data handling and preprocessing.
• Implemented customized functions for streamlined data transformation and exploratory data analysis (EDA).
• Designed and structured documentation and usage guides, making the package accessible for both novice and advanced users.
• Conducted unit testing and continuous integration to ensure code stability and maintainability.

The Effect of Post-COVID-19 Layoff Announcements on Stock Performance 

• Designed and implemented Python-based data pipelines to analyze layoff data and stock performance trends, leveraging libraries such as yfinance, Matplotlib, and Seaborn.
• Led data extraction and cleaning processes, including manual data retrieval, text recognition, and dataset integration to enable regression analysis.
• Conducted comprehensive statistical modeling (OLS regressions) to assess the impact of layoffs on stock price volatility, with a focus on layoff magnitude and historical performance.
• Created detailed data visualizations, including heatmaps and time-series plots, to illustrate geographic and sectoral patterns of layoffs.

Construction of the Chinese Image of Kung Fu Films in the English-Speaking World 

• Sent HTTP requests to movie review websites using the Requests library to retrieve webpage content containing user reviews.
• Parsed HTML content with Beautiful Soup to locate elements containing reviews and extracted text and user details. Iterated through all reviews to collect detailed information, including review content and user data.
• Organized extracted data into suitable data structures (e.g., lists, dictionaries) for further processing. Converted review data into a Pandas DataFrame and exported it to an Excel file for analysis.