{ "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", "![Image](https://economicdevelopmentregina.com/wp-content/uploads/2022/05/City-Skyline-Compressed-Keithe-Hershmiller-cropped-1.jpg)\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", "