Project description
This is an python package which helps us to read the data of google spread sheets from your google drive and then you can manipulate the data using pandas and plot graph using matplotlib
Features
- Easy to use
- Easy to understand
- Very helpful for reading the data from Google Sheets
Before installing this package there is one important thing which you have to do first. You have to enable your Google Drive API and Google Sheets API from Google APIs Console.
- Go to the Google APIs Console.
- Create a new project.
- Click Enable API. Search for and enable the Google Drive API.
- Create credentials for a Web Server to access Application Data.
- Name the service account and grant it a Project Role of Editor.
- Download the JSON file.
- Give any specfic name of your JSON file
- Open your JSON file and copy the e-mail.
- Open your GOODLE SPREADSHEETS and click on share open on the right top.
- Paste your e-mail and then click on send button.
Library Used
I have used the gspread and oauth2client service to authorize and make API calls to Google Cloud Services.
Importing Library
pip install gspread oauth2client
Features of gspread
library
- Google Sheets API v4.
- Open a spreadsheet by title, key or url.
- Read, write, and format cell ranges.
- Sharing and access control.
- Batching updates.
About oauth2client
This library will help us to get the client credientials a to read the data of specific Spread Sheet.
pip install gsspread10
The name of this package is “gspread10” and you can use this package to read the data from GOODLE SPREADSHEETS in JSON format and then using pandas you can manipulate the data in table using DataFrames and for Data Visualization you can use Matplotlib.
Function to read the data
To read the data from c you have to use getjsonGspreadData(json_file, gspread_file)
function and inside the function you have to give the path of your JSON file and the name of your GOODLE SPREADSHEETS.
For example:- I want to read the data from Greendeck Assignment file. So Here How it should be written.
getjsonGspreadData("your_JSON_Path", "Greendeck Assignment")
# Google Sheets Features. # Open a spreadsheet by title, key or url. # Read, write, and format cell ranges. # Sharing and access control. # Batching updates. # oauth2client library will help us to get the client credientials a to read the data of specific Spread Sheet. import gspread from oauth2client.service_account import ServiceAccountCredentials import pandas as pd def getjsonGspreadData(json_file, gspread_file): # use creds to create a client to interact with the Google Drive API scope = ["https://spreadsheets.google.com/feeds","https://www.googleapis.com/auth/drive.file","https://www.googleapis.com/auth/drive"] creds = ServiceAccountCredentials.from_json_keyfile_name(json_file, scope) client = gspread.authorize(creds) # Find a workbook by name and open the first sheet # Make sure you use the right name here. sheet = client.open(gspread_file).sheet1 # Extract and print all of the values list_of_gspread = sheet.get_all_records() # return list_of_gspread data = pd.DataFrame.from_dict(list_of_gspread) return data # print(getjsonGspreadData("D:project videosGoogle sheetsclient_secret.json", "Greendeck Assignment"))
I went throung several websites to get the idea of ‘How to read data from Goofle Spread Sheet’. So finally I got this website –> mediam.com. You can go through this website.
This package is distributed under the MIT license.
Download files
Download the file for your platform. If you’re not sure which to choose, learn more about installing packages.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size
gsspread10-0.0.2-py3-none-any.whl (4.7 kB) |
File type Wheel |
Python version
py3 |
Upload date
Oct 7, 2020 |
Hashes
View |
Filename, size
gsspread10-0.0.2.tar.gz (3.7 kB) |
File type Source |
Python version
None |
Upload date
Oct 7, 2020 |
Hashes
View |