Files
fenago f3b24b4b7f added
2021-02-07 15:16:01 +05:00

145 lines
3.1 KiB
Plaintext

{
"cells": [
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {},
"colab_type": "code",
"id": "7CD6xDJ4kFuF"
},
"outputs": [],
"source": [
"import pandas as pd"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {},
"colab_type": "code",
"id": "hoX4rAJSkQkB"
},
"outputs": [],
"source": [
"file_url = '../bank-full.csv'"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 204
},
"colab_type": "code",
"executionInfo": {
"elapsed": 4255,
"status": "ok",
"timestamp": 1572996656060,
"user": {
"displayName": "Anthony So",
"photoUrl": "https://lh3.googleusercontent.com/a-/AAuE7mCYY-iGjUIqBSnlLoszfZTN7rU7FRNg05Rdt9Ii3A=s64",
"userId": "11809607246124237079"
},
"user_tz": -660
},
"id": "Qmb16Sd2kZHW",
"outputId": "c8693d09-89e2-44c0-b4f1-50474321a05f"
},
"outputs": [],
"source": [
"# Loading the data using pandas\n",
"bankData = pd.read_csv(file_url, sep=\";\")\n",
"bankData.head()"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 34
},
"colab_type": "code",
"executionInfo": {
"elapsed": 4249,
"status": "ok",
"timestamp": 1572996656061,
"user": {
"displayName": "Anthony So",
"photoUrl": "https://lh3.googleusercontent.com/a-/AAuE7mCYY-iGjUIqBSnlLoszfZTN7rU7FRNg05Rdt9Ii3A=s64",
"userId": "11809607246124237079"
},
"user_tz": -660
},
"id": "g_NKbtDNlBXx",
"outputId": "74687944-da06-4198-f043-14ee00b8a611"
},
"outputs": [],
"source": [
"# Printing the shape of the data \n",
"print(bankData.shape)"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 297
},
"colab_type": "code",
"executionInfo": {
"elapsed": 4240,
"status": "ok",
"timestamp": 1572996656062,
"user": {
"displayName": "Anthony So",
"photoUrl": "https://lh3.googleusercontent.com/a-/AAuE7mCYY-iGjUIqBSnlLoszfZTN7rU7FRNg05Rdt9Ii3A=s64",
"userId": "11809607246124237079"
},
"user_tz": -660
},
"id": "oFkJiAxElUtL",
"outputId": "0950072e-5c7d-408e-a9ca-0c0dd8cda4aa"
},
"outputs": [],
"source": [
"# Summarizing the statistics of the numerical raw data\n",
"bankData.describe()"
]
}
],
"metadata": {
"colab": {
"collapsed_sections": [],
"name": "Exercise3.01_updated.ipynb",
"provenance": []
},
"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.6"
}
},
"nbformat": 4,
"nbformat_minor": 1
}