Project 2 - EDA on Vehicle Insurance Customer Data
{
"cells": [
{
"cell_type": "markdown",
"id": "intro",
"metadata": {},
"source": [
"# EDA on Vehicle Insurance Customer Data"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "import_libraries",
"metadata": {},
"outputs": [],
"source": [
"# Import necessary libraries\n",
"import pandas as pd\n",
"import numpy as np\n",
"import seaborn as sns\n",
"import matplotlib.pyplot as plt"
]
},
{
"cell_type": "markdown",
"id": "load_data",
"metadata": {},
"source": [
"## Load the Datasets (Placeholder since dataset is not available)"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "read_data",
"metadata": {},
"outputs": [],
"source": [
"# Assuming dataset is named 'customer_data.csv' and 'customer_policy_data.csv'\n",
"# df_customer = pd.read_csv('customer_data.csv')\n",
"# df_policy = pd.read_csv('customer_policy_data.csv')\n",
"\n",
"# Display first few rows\n",
"# df_customer.head(), df_policy.head()"
]
},
{
"cell_type": "markdown",
"id": "data_cleaning",
"metadata": {},
"source": [
"## Data Cleaning and Processing (Details omitted due to missing dataset)"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "data_cleaning_steps",
"metadata": {},
"outputs": [],
"source": [
"# Steps like handling null values, removing duplicates, case correction, etc."
]
},
{
"cell_type": "markdown",
"id": "eda",
"metadata": {},
"source": [
"## Exploratory Data Analysis"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "eda_steps",
"metadata": {},
"outputs": [],
"source": [
"# Generate summary statistics\n",
"# df_customer.describe(), df_policy.describe()"
]
},
{
"cell_type": "markdown",
"id": "conclusion",
"metadata": {},
"source": [
"## Conclusion & Insights"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "final_notes",
"metadata": {},
"outputs": [],
"source": [
"# Final analysis and recommendations"
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.8.10"
}
},
"nbformat": 4,
"nbformat_minor": 4
}