{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"provenance": [],
"authorship_tag": "ABX9TyPt0aGBNMNstiyhiiECjaSV",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
""
]
},
{
"cell_type": "markdown",
"source": [
"# **Exploring the Regina Gas Stations Dataset**\n",
"\n",
"\n",
"\n",
"---\n",
"\n",
"# **Table of contents**\n",
"1. [Purpose](#purpose)\n",
"2. [Loading the Dataset](#loading)\n",
" 1. [Printing the entire dataset](#print)\n",
"3. [Removing the empty row](#remove)\n",
"4. [Information about the database](#info)\n",
"5. [Key Error](#Key)\n",
"6. [Counting occurrences of a specific value](#count)\n",
"7. [Grouping Specific Column Data](#group)\n",
"8. [Plotting the Data](#plot)\n",
"9. [Conclusion](#conclusion)\n",
"---\n",
"\n",
"## **Purpose** \n",
"I created this dataset to do some experiments and tell stories. I scraped every single data from the Google Maps manually. Although, this is a open source dataset, feel free to edit and update if you have any great suggestions. All the EDA tools and techniques will be applied on this data-set. Get exicited.\n",
"\n",
"\n",
"## **Loading the Dataset** \n",
"\n",
"First you need to upload the dataset to your Google Colab. Then you need to `read` it to your notebook as shown below. Since this is not a big dataset interms of having many rows. I stored them in a Excel Sheet. A simple way to store big data sets is to use CSV files (comma separated files).\n",
"\n",
"CSV files contains plain text and is a well know format that can be read by everyone including Pandas. To read a CSV file you might want to use `pd.read_csv('data.csv')`. instead of `pd.read_excel` which is used for excel stored datasets. "
],
"metadata": {
"id": "2MHmdhnGi_if"
}
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 423
},
"id": "r4bV4p10iHOm",
"outputId": "ca82b69a-e7d1-491d-d27a-fec55cf106eb"
},
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Name Location Phone Number\n",
"0 NaN NaN NaN\n",
"1 Mobil Albert Street 306-790-1228\n",
"2 Esso Albert Street 306-584-7185\n",
"3 Canadian Tire - Gas Plus Albert Street 306-585-3319\n",
"4 Co-op Gas Bar Albert Street 306-791-8890\n",
".. ... ... ...\n",
"64 Cowessess Gas SK-33 Highway 306-359-6777\n",
"65 Petro Canada Gravel Pit Road 306-525-6033\n",
"66 Petro Pass Regina 529 1 Ave E 306-721-6667\n",
"67 Co-op Gas Bar Great Plains Road 306-791-5707\n",
"68 Esso Great Plains Road 306-781-2580\n",
"\n",
"[69 rows x 3 columns]"
],
"text/html": [
"\n",
"
| \n", " | Name | \n", "Location | \n", "Phone Number | \n", "
|---|---|---|---|
| 0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 1 | \n", "Mobil | \n", "Albert Street | \n", "306-790-1228 | \n", "
| 2 | \n", "Esso | \n", "Albert Street | \n", "306-584-7185 | \n", "
| 3 | \n", "Canadian Tire - Gas Plus | \n", "Albert Street | \n", "306-585-3319 | \n", "
| 4 | \n", "Co-op Gas Bar | \n", "Albert Street | \n", "306-791-8890 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 64 | \n", "Cowessess Gas | \n", "SK-33 Highway | \n", "306-359-6777 | \n", "
| 65 | \n", "Petro Canada | \n", "Gravel Pit Road | \n", "306-525-6033 | \n", "
| 66 | \n", "Petro Pass Regina | \n", "529 1 Ave E | \n", "306-721-6667 | \n", "
| 67 | \n", "Co-op Gas Bar | \n", "Great Plains Road | \n", "306-791-5707 | \n", "
| 68 | \n", "Esso | \n", "Great Plains Road | \n", "306-781-2580 | \n", "
69 rows × 3 columns
\n", "| \n", " | Name | \n", "Location | \n", "Phone Number | \n", "
|---|---|---|---|
| 1 | \n", "Mobil | \n", "Albert Street | \n", "306-790-1228 | \n", "
| 2 | \n", "Esso | \n", "Albert Street | \n", "306-584-7185 | \n", "
| 3 | \n", "Canadian Tire - Gas Plus | \n", "Albert Street | \n", "306-585-3319 | \n", "
| 4 | \n", "Co-op Gas Bar | \n", "Albert Street | \n", "306-791-8890 | \n", "
| 5 | \n", "Shell | \n", "Albert Street | \n", "306-586-4333 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 64 | \n", "Cowessess Gas | \n", "SK-33 Highway | \n", "306-359-6777 | \n", "
| 65 | \n", "Petro Canada | \n", "Gravel Pit Road | \n", "306-525-6033 | \n", "
| 66 | \n", "Petro Pass Regina | \n", "529 1 Ave E | \n", "306-721-6667 | \n", "
| 67 | \n", "Co-op Gas Bar | \n", "Great Plains Road | \n", "306-791-5707 | \n", "
| 68 | \n", "Esso | \n", "Great Plains Road | \n", "306-781-2580 | \n", "
68 rows × 3 columns
\n", "