google-sheet-to-pandas-notebook.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Untitled0.ipynb","provenance":[],"authorship_tag":"ABX9TyPmtUCwu3MBHN+IILEQAT7g"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"code","metadata":{"id":"YDH0oK87-6e5","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1594658563427,"user_tz":-330,"elapsed":927,"user":{"displayName":"Bhavesh Bhatt","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ggn1iyaPhugkkpQYFRw42nt9ToNB-Rit7YeWtI4Zw=s64","userId":"01561702845917398436"}}},"source":["import pandas as pd"],"execution_count":17,"outputs":[]},{"cell_type":"code","metadata":{"id":"Kwb15_DV_OKk","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1594658597569,"user_tz":-330,"elapsed":959,"user":{"displayName":"Bhavesh Bhatt","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ggn1iyaPhugkkpQYFRw42nt9ToNB-Rit7YeWtI4Zw=s64","userId":"01561702845917398436"}}},"source":["gsheetid = \"1PwzQ6ZuoQaaNjPJ0yHiTIeFUKX1n1LN7gg5k9auNFXU\"\n","sheet_name = \"Data\""],"execution_count":18,"outputs":[]},{"cell_type":"code","metadata":{"id":"JPCgDRhp_f3O","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1594658716616,"user_tz":-330,"elapsed":1054,"user":{"displayName":"Bhavesh Bhatt","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ggn1iyaPhugkkpQYFRw42nt9ToNB-Rit7YeWtI4Zw=s64","userId":"01561702845917398436"}}},"source":["gsheet_url = \"https://docs.google.com/spreadsheets/d/{}/gviz/tq?tqx=out:csv&sheet={}\".format(gsheetid, sheet_name)"],"execution_count":19,"outputs":[]},{"cell_type":"code","metadata":{"id":"f3nmMmyF_94h","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":52},"executionInfo":{"status":"ok","timestamp":1594658723692,"user_tz":-330,"elapsed":882,"user":{"displayName":"Bhavesh Bhatt","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ggn1iyaPhugkkpQYFRw42nt9ToNB-Rit7YeWtI4Zw=s64","userId":"01561702845917398436"}},"outputId":"2fafe0fb-5ab1-4399-fafd-2d76d0d0c1ef"},"source":["gsheet_url"],"execution_count":20,"outputs":[{"output_type":"execute_result","data":{"application/vnd.google.colaboratory.intrinsic":{"type":"string"},"text/plain":["'https://docs.google.com/spreadsheets/d/1PwzQ6ZuoQaaNjPJ0yHiTIeFUKX1n1LN7gg5k9auNFXU/gviz/tq?tqx=out:csv&sheet=Data'"]},"metadata":{"tags":[]},"execution_count":20}]},{"cell_type":"code","metadata":{"id":"UM_pSqguAOsE","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1594658759622,"user_tz":-330,"elapsed":893,"user":{"displayName":"Bhavesh Bhatt","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ggn1iyaPhugkkpQYFRw42nt9ToNB-Rit7YeWtI4Zw=s64","userId":"01561702845917398436"}}},"source":["df = pd.read_csv(gsheet_url)"],"execution_count":21,"outputs":[]},{"cell_type":"code","metadata":{"id":"0wERlVZwAh1u","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":140},"executionInfo":{"status":"ok","timestamp":1594658778804,"user_tz":-330,"elapsed":943,"user":{"displayName":"Bhavesh Bhatt","photoUrl":"https://lh3.googleusercontent.com/a-/AOh14Ggn1iyaPhugkkpQYFRw42nt9ToNB-Rit7YeWtI4Zw=s64","userId":"01561702845917398436"}},"outputId":"246856da-919a-45a3-da7e-e2cdef600a73"},"source":["df"],"execution_count":22,"outputs":[{"output_type":"execute_result","data":{"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>col1</th>\n","      <th>col2</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>a</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>b</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3</td>\n","      <td>c</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   col1 col2\n","0     1    a\n","1     2    b\n","2     3    c"]},"metadata":{"tags":[]},"execution_count":22}]},{"cell_type":"code","metadata":{"id":"cSZDsM-8AisF","colab_type":"code","colab":{}},"source":[""],"execution_count":null,"outputs":[]}]}