DB Lab 1
Note: This can be a pair programming activity or done independently.
In this lab we will explore a small subset of the database of the Enron email corpus
This dataset was collected and prepared by the CALO Project (A Cognitive Assistant that Learns and Organizes). The original dataset contains data from about 150 users, mostly senior management of Enron and about 0.5M messages. This data was originally made public, and posted to the web, by the Federal Energy Regulatory Commission during its investigation. The subset we use here is much smaller than the total dataset.
- Load the data from the enron.db file into Pandas
- Perform exploratory data analysis
- Use the merge function from pandas to combine data from different tables
- Answer few more questions using the merge function from pandas
The starter code folder contains a Jupyter notebook with a series of questions. Most questions can be solved in more than one way and using different tools. Feel free to use both SQL and Pandas to tackle them.