Package Health Score

81 / 100

security
No known security issues
popularity
Small
maintenance
Sustainable
community
Active

Popularity

Small

GitHub Stars: 7.07K
Forks: 945
Contributors: 170

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package sheetconnect, we found that it has been starred 7,071 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Jul 13, 2024
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
0
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

MIT

Security Policy

We found a way for you to contribute to the project! Looks like sheetconnect is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Sustainable

Commit Frequency

Open Issues: 41
Open PR: 8
Last Release: 4 months ago
Last Commit: 2 months ago

Further analysis of the maintenance status of sheetconnect based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Sustainable.

We found that sheetconnect demonstrates a positive version release cadence with at least one new version released in the past 12 months.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Active

Readme: Yes
Contributing.md: Yes
Code of Conduct: Yes
Contributors: 170
Funding: No

A good and healthy external contribution signal for sheetconnect project, which invites more than one hundred open source maintainers to collaborate on the repository.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: >=3.6

Age: 4 months
Latest Release: 4 months ago
Dependencies: N/A
Versions: 5
Maintainers: 1
Wheels: OS Independent

Readme

Google Sheets to DataFrame

This Python module provides a simple interface to connect to Google Sheets and retrieve data as a pandas DataFrame. It uses the gspread library to handle Google Sheets API interactions and pandas for data manipulation.

Prerequisites

Ensure you have the following Python libraries installed:

gspread
pandas
oauth2client

You can install them using pip:

pip install gspread pandas oauth2client

Google Sheets API Setup

Go to the Google Cloud Console.
Create a new project (or select an existing one).
Enable the Google Sheets API and Google Drive API for the project.
Create credentials for a Service Account and download the JSON key file.
Share your Google Sheet with the email address in the JSON key file.

Usage

Save your Service Account credential JSON file in your project directory.
Use the Connect class to fetch data from your Google Sheet:

from sheetconnect import Connect

credential = 'path/to/your/credential.json'
sheet = 'Your Google Sheet Name'
sheet_name = 'Sheet1'

dataframe = Connect.GetDF_Sheet(credential, sheet, sheet_name)
print(dataframe)

Replace 'path/to/your/credential.json', 'Your Google Sheet Name', and 'Sheet1' with your actual file path, Google Sheet name, and worksheet name.

Acknowledgements

gspread - Google Sheets Python API
pandas - Data analysis and manipulation library
oauth2client - OAuth 2.0 client library

FAQs

What is sheetconnect?

Simple get data from Google sheet in form of Pandas dataframe. Visit Snyk Advisor to see a full health score report for sheetconnect, including popularity, security, maintenance & community analysis.

Is sheetconnect popular?

We’re still processing downloads data for the python package sheetconnect. Visit the popularity section on Snyk Advisor to see the full popularity analysis.

Is sheetconnect well maintained?

We found indications that sheetconnect maintenance is sustainable demonstrating some project activity. We saw a total of 170 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is sheetconnect safe to use?

The python package sheetconnect was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 23 November-2024, at 00:29 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

sheetconnect

Simple get data from Google sheet in form of Pandas dataframe For more information about how to use this package see README

Ensure you're using the healthiest python packages

Package Health Score

Popularity

Direct Usage Popularity

Security

Security and license risk for latest version

Maintenance

Commit Frequency

Community

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Package

Readme

Google Sheets to DataFrame

Prerequisites

Google Sheets API Setup

Usage

Acknowledgements

FAQs

What is sheetconnect?

Is sheetconnect popular?

Is sheetconnect well maintained?

Is sheetconnect safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Fix identified vulnerabilities

Monitor for new issues

Package Health Score

Direct Usage Popularity

Security and license risk for latest version

Commit Frequency

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Snyk Vulnerability Scanner

Readme

Google Sheets to DataFrame

Prerequisites

Google Sheets API Setup

Usage

Acknowledgements

FAQs

What is sheetconnect?

Is sheetconnect popular?

Is sheetconnect well maintained?

Is sheetconnect safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues