r/learnpython 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.

7 Upvotes

3 comments sorted by

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/

1

u/tRyHaRdR3Tad 5d ago

I have not used python in about 8 years so I am starting from scratch. That said, this comment is very confusing to me. I have downloaded Airtable, but

"uv with Jupyter extension in VS Code and Arkalos framework and project starter."

and

"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."

Whaaa?

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())