Skip to content

Instantly share code, notes, and snippets.

@jaiswalakshay508-maker

jaiswalakshay508-maker/summarize.ipynb

Created May 3, 2026 13:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jaiswalakshay508-maker/53ea57b8951b96e4f280ea3896aec793 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jaiswalakshay508-maker/53ea57b8951b96e4f280ea3896aec793 to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
summarize.ipynb
{
"cells": [
{
"cell_type": "code",
"id": "initial_id",
"metadata": {
"collapsed": true,
"ExecuteTime": {
"end_time": "2025-11-17T14:34:35.487687Z",
"start_time": "2025-11-17T14:34:28.975782Z"
}
},
"source": "import pandas as pd",
"outputs": [],
"execution_count": 1
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T14:35:44.747763Z",
"start_time": "2025-11-17T14:35:44.682330Z"
}
},
"cell_type": "code",
"source": [
"df=pd.read_csv('bmw.csv')\n",
"df"
],
"id": "e08aab0c3a4408f2",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 3
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T14:39:10.024464Z",
"start_time": "2025-11-17T14:39:09.996405Z"
}
},
"cell_type": "code",
"source": [
"df['transmission'].value_counts()\n",
"df"
],
"id": "d524516b6cbfc768",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 4
},
{
"metadata": {},
"cell_type": "markdown",
"source": "How many types of transmission did BMW introduce ?",
"id": "bbb9a2bbe3ce8c0a"
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T14:44:44.355263Z",
"start_time": "2025-11-17T14:44:44.323238Z"
}
},
"cell_type": "code",
"source": [
"df['fuelType'].value_counts()\n",
"df"
],
"id": "3ae5e3fc5a642cf4",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 7
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T14:48:51.105472Z",
"start_time": "2025-11-17T14:48:51.073014Z"
}
},
"cell_type": "code",
"source": [
"df['transmission'].value_counts(normalize=True)\n",
"df"
],
"id": "1f06cd5096404c46",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 8
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T14:57:21.981960Z",
"start_time": "2025-11-17T14:57:21.949188Z"
}
},
"cell_type": "code",
"source": [
"df['transmission'].value_counts(normalize=True)*100\n",
"df"
],
"id": "3f123d05e932fd1d",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 9
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:00:26.720863Z",
"start_time": "2025-11-17T15:00:26.688428Z"
}
},
"cell_type": "code",
"source": [
"\n",
"df"
],
"id": "e311f78859e7caae",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 10
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:01:43.759819Z",
"start_time": "2025-11-17T15:01:43.725846Z"
}
},
"cell_type": "code",
"source": [
"df['fuelType'].value_counts()\n",
"df"
],
"id": "162c5e73f33d315f",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 11
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:03:20.600941Z",
"start_time": "2025-11-17T15:03:20.574345Z"
}
},
"cell_type": "code",
"source": "df\n",
"id": "10414522a0790e64",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 12
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:04:06.488136Z",
"start_time": "2025-11-17T15:04:06.462464Z"
}
},
"cell_type": "code",
"source": [
"df['transmission'].value_counts()\n",
"df"
],
"id": "139dfb63b3ddf407",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 13
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:06:56.097949Z",
"start_time": "2025-11-17T15:06:56.069418Z"
}
},
"cell_type": "code",
"source": "df\n",
"id": "99e81259eea47b8c",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 14,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 14
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:07:52.895002Z",
"start_time": "2025-11-17T15:07:52.865257Z"
}
},
"cell_type": "code",
"source": [
"df['transmission'].value_counts(sort=False)\n",
"df"
],
"id": "41d86bc108682060",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 15,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 15
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:11:58.472273Z",
"start_time": "2025-11-17T15:11:58.435343Z"
}
},
"cell_type": "code",
"source": [
"df['transmission'].value_counts().sort_index()\n",
"df"
],
"id": "f0b41c2a95f77af9",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 17,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 17
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:15:22.235865Z",
"start_time": "2025-11-17T15:15:22.197421Z"
}
},
"cell_type": "code",
"source": [
"df['transmission'].value_counts().reset_index()\n",
"df"
],
"id": "93cec2726dd25750",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 20,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 20
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:16:41.857454Z",
"start_time": "2025-11-17T15:16:41.830255Z"
}
},
"cell_type": "code",
"source": "df\n",
"id": "85ea125981356fea",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 21,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 21
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:17:34.127034Z",
"start_time": "2025-11-17T15:17:34.098886Z"
}
},
"cell_type": "code",
"source": [
"df['model'].value_counts()\n",
"df"
],
"id": "67eb55a73568ffc6",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 22
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:20:06.666409Z",
"start_time": "2025-11-17T15:20:06.641734Z"
}
},
"cell_type": "code",
"source": [
"mdf=df['model'].value_counts(normalize=True)*100\n",
"mdf=mdf.reset_index()\n",
"mdf"
],
"id": "a0d57b0064aa57e0",
"outputs": [
{
"data": {
"text/plain": [
" model proportion\n",
"0 3 Series 22.660236\n",
"1 1 Series 18.263612\n",
"2 2 Series 11.390409\n",
"3 5 Series 9.785734\n",
"4 4 Series 9.229200\n",
"5 X1 7.457564\n",
"6 X3 5.110843\n",
"7 X5 4.340970\n",
"8 X2 2.671366\n",
"9 X4 1.660328\n",
"10 M4 1.159447\n",
"11 Z4 1.001762\n",
"12 6 Series 0.992487\n",
"13 X6 0.983211\n",
"14 7 Series 0.983211\n",
"15 X7 0.510157\n",
"16 i3 0.398850\n",
"17 8 Series 0.361748\n",
"18 M5 0.268992\n",
"19 M3 0.250441\n",
"20 M2 0.194787\n",
"21 i8 0.157685\n",
"22 M6 0.074205\n",
"23 Z3 0.064929\n",
"24 5 Series 0.009276\n",
"25 6 Series 0.009276\n",
"26 2 Series 0.009276"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>proportion</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>3 Series</td>\n",
" <td>22.660236</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>1 Series</td>\n",
" <td>18.263612</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>2 Series</td>\n",
" <td>11.390409</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>9.785734</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>4 Series</td>\n",
" <td>9.229200</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>X1</td>\n",
" <td>7.457564</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>X3</td>\n",
" <td>5.110843</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>X5</td>\n",
" <td>4.340970</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>X2</td>\n",
" <td>2.671366</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>X4</td>\n",
" <td>1.660328</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>M4</td>\n",
" <td>1.159447</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Z4</td>\n",
" <td>1.001762</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>6 Series</td>\n",
" <td>0.992487</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>X6</td>\n",
" <td>0.983211</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>7 Series</td>\n",
" <td>0.983211</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>X7</td>\n",
" <td>0.510157</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>i3</td>\n",
" <td>0.398850</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>8 Series</td>\n",
" <td>0.361748</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>M5</td>\n",
" <td>0.268992</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>M3</td>\n",
" <td>0.250441</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>M2</td>\n",
" <td>0.194787</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>i8</td>\n",
" <td>0.157685</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>M6</td>\n",
" <td>0.074205</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Z3</td>\n",
" <td>0.064929</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>5 Series</td>\n",
" <td>0.009276</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>6 Series</td>\n",
" <td>0.009276</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>2 Series</td>\n",
" <td>0.009276</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 24
},
{
"metadata": {
"ExecuteTime": {
"end_time": "2025-11-17T15:21:37.696723Z",
"start_time": "2025-11-17T15:21:37.652462Z"
}
},
"cell_type": "code",
"source": [
"df[['year','transmission']].value_counts()\n",
"df"
],
"id": "8c9264e31c85bbee",
"outputs": [
{
"data": {
"text/plain": [
" model year price transmission mileage fuelType tax mpg \\\n",
"0 2 Series 2018 16250 Manual 10401 Petrol 145 52.3 \n",
"1 5 Series 2014 11200 Automatic 67068 Diesel 125 57.6 \n",
"2 6 Series 2018 27000 Automatic 14827 Petrol 145 42.8 \n",
"3 5 Series 2016 16000 Automatic 62794 Diesel 160 51.4 \n",
"4 1 Series 2017 12750 Automatic 26676 Diesel 145 72.4 \n",
"... ... ... ... ... ... ... ... ... \n",
"10776 X3 2016 19000 Automatic 40818 Diesel 150 54.3 \n",
"10777 5 Series 2016 14600 Automatic 42947 Diesel 125 60.1 \n",
"10778 3 Series 2017 13100 Manual 25468 Petrol 200 42.8 \n",
"10779 1 Series 2014 9930 Automatic 45000 Diesel 30 64.2 \n",
"10780 X1 2017 15981 Automatic 59432 Diesel 125 57.6 \n",
"\n",
" engineSize \n",
"0 1.5 \n",
"1 2.0 \n",
"2 2.0 \n",
"3 3.0 \n",
"4 1.5 \n",
"... ... \n",
"10776 2.0 \n",
"10777 2.0 \n",
"10778 2.0 \n",
"10779 2.0 \n",
"10780 2.0 \n",
"\n",
"[10781 rows x 9 columns]"
],
"text/html": [
"<div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>model</th>\n",
" <th>year</th>\n",
" <th>price</th>\n",
" <th>transmission</th>\n",
" <th>mileage</th>\n",
" <th>fuelType</th>\n",
" <th>tax</th>\n",
" <th>mpg</th>\n",
" <th>engineSize</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>2 Series</td>\n",
" <td>2018</td>\n",
" <td>16250</td>\n",
" <td>Manual</td>\n",
" <td>10401</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>52.3</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>5 Series</td>\n",
" <td>2014</td>\n",
" <td>11200</td>\n",
" <td>Automatic</td>\n",
" <td>67068</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>6 Series</td>\n",
" <td>2018</td>\n",
" <td>27000</td>\n",
" <td>Automatic</td>\n",
" <td>14827</td>\n",
" <td>Petrol</td>\n",
" <td>145</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>16000</td>\n",
" <td>Automatic</td>\n",
" <td>62794</td>\n",
" <td>Diesel</td>\n",
" <td>160</td>\n",
" <td>51.4</td>\n",
" <td>3.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>1 Series</td>\n",
" <td>2017</td>\n",
" <td>12750</td>\n",
" <td>Automatic</td>\n",
" <td>26676</td>\n",
" <td>Diesel</td>\n",
" <td>145</td>\n",
" <td>72.4</td>\n",
" <td>1.5</td>\n",
" </tr>\n",
" <tr>\n",
" <th>...</th>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" <td>...</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10776</th>\n",
" <td>X3</td>\n",
" <td>2016</td>\n",
" <td>19000</td>\n",
" <td>Automatic</td>\n",
" <td>40818</td>\n",
" <td>Diesel</td>\n",
" <td>150</td>\n",
" <td>54.3</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10777</th>\n",
" <td>5 Series</td>\n",
" <td>2016</td>\n",
" <td>14600</td>\n",
" <td>Automatic</td>\n",
" <td>42947</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>60.1</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10778</th>\n",
" <td>3 Series</td>\n",
" <td>2017</td>\n",
" <td>13100</td>\n",
" <td>Manual</td>\n",
" <td>25468</td>\n",
" <td>Petrol</td>\n",
" <td>200</td>\n",
" <td>42.8</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10779</th>\n",
" <td>1 Series</td>\n",
" <td>2014</td>\n",
" <td>9930</td>\n",
" <td>Automatic</td>\n",
" <td>45000</td>\n",
" <td>Diesel</td>\n",
" <td>30</td>\n",
" <td>64.2</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10780</th>\n",
" <td>X1</td>\n",
" <td>2017</td>\n",
" <td>15981</td>\n",
" <td>Automatic</td>\n",
" <td>59432</td>\n",
" <td>Diesel</td>\n",
" <td>125</td>\n",
" <td>57.6</td>\n",
" <td>2.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>10781 rows × 9 columns</p>\n",
"</div>"
]
},
"execution_count": 25,
"metadata": {},
"output_type": "execute_result"
}
],
"execution_count": 25
},
{
"metadata": {},
"cell_type": "code",
"outputs": [],
"execution_count": null,
"source": "",
"id": "b671a4f73c2ce1bc"
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 2
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython2",
"version": "2.7.6"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment