DataDriver

Authors

Olivia Cornejo `25, DePauw University

Document Type

Abstract

Publication Date

Fall 12-1-2024

Abstract

Analyzing data from clients is a time consuming, challenging, and skill intensive task. DataDriver, a web application, easily allows users to take their downloaded Excel files from SalesForce Lightning to be uploaded and reviewed, resolving those issues. DataDriver uses the capabilities of the Python library Pandas to read the Excel files, clean the data by removing duplicates, sort by user entered dates, return a fresh Excel file, produce pivot tables, and plot the data in a bar chart. Users can also decide to compare data from two distinct timeframes. If they choose to do so, the data in the bar graphs will be displayed side by side. The website contains a “Help and How to Use” tab for new users or users who are having difficulty navigating the site.

Comments

Completed as part of the Computer Science Senior Capstone Project.

Recommended Citation

Cornejo, Olivia `25, "DataDriver" (2024). Student Research. 196, Scholarly and Creative Work from DePauw University.
https://scholarship.depauw.edu/studentresearchother/196