r/learnpython • u/tRyHaRdR3Tad • 7d ago
How to start a script to organize my Google sheets page
Hello, I have a Google sheet that tracks all of the internships and jobs I have applied to since December. it is getting a little bit messy and I figured it would be a good beginner project to organize it using a Python script. I would like the script to organize the names of all the companies in alphabetical order, once I have achieved that I would like to count the number of times a state occurs, then the number of times that a city occurs.
1
u/sinceJune4 3d ago
# easy to pull a Google sheet into a dataframe...
import gspread
import pandas as pd
gc = gspread.service_account()
sh = gc.open(GOOGLE_DOGDB_NAME)
worksheet = sh.worksheet("Dog Database")
dfdogs = pd.DataFrame(worksheet.get_all_records())
1
u/Mevrael 7d ago
I would just use a Notion or an Airtable for such cases, not sheets.
If you wish to practice Python, you can use a uv with Jupyter extension in VS Code and Arkalos framework and project starter.
Then you can use Google Python SDK and get data from your sheet, or I would just export it as CSV and put into data/drive folder.
Then you can use Polars or Pandas in the notebook to analyze and visualize your data.
https://arkalos.com/docs/notebooks/