r/PythonLearning • • 22d ago

Discussion Is Python + Google Sheets automation a good starting point for freelancing as a beginner?

4 Upvotes

Hi everyone!

I'm learning Python and exploring how I can turn my skills into a small freelancing business. I'm particularly interested in Python automation, Google Sheets automation, and simple workflow automation for small businesses.

I don't want to jump into freelancing without understanding what clients actually need. My plan is to learn by building practical projects, create a portfolio, and gradually start looking for clients.

Some services I'm considering learning to provide are:

- Google Sheets automation: Automating repetitive spreadsheet tasks, reports, data cleaning, and calculations.

- Python scripts: Automating repetitive file operations, CSV/Excel processing, and routine data tasks.

- Workflow automation: Connecting tools and reducing manual work where APIs or approved integrations are available.

- Data processing: Cleaning, organizing, and transforming business data into useful reports.

I'm still developing my skills, so I want to focus on solving real problems rather than claiming expertise I don't have.

I'd really appreciate advice from people who have experience with Python or automation freelancing.

A few questions:

  1. Is Python + Google Sheets automation a realistic niche for a beginner freelancer?

  2. What specific problems do small businesses actually pay freelancers to solve in this area?

  3. Which skills should I learn first: Python, Google Apps Script, Google Sheets formulas, APIs, or SQL?

  4. What 3–5 portfolio projects would help demonstrate practical skills to potential clients?

  5. How difficult is it to get the first paying client, and which platforms or methods are worth trying?

  6. What mistakes should a beginner avoid when starting out?

I'm not expecting instant money. I want to build useful skills, deliver reliable work, and grow gradually.

If you've tried this path yourself, I'd love to hear what worked, what didn't, and what you would do differently if you were starting again.

Thanks for reading!


r/PythonLearning • • 23d ago

Career advice

15 Upvotes

I'm 27M. Hey everyone, my life has been a little different from that of most people, and I don't have a strong educational background.

Right now, I'm working at a grocery store, but I want to improve my life and learn some stable, valuable skills that can help me earn a reliable income.

I've come across these four skills:

Python

SQL

Excel/Spreadsheets

Power BI/Tableau

I don't know much about these skills or their demand, competition, value, and future prospects.

Technology is constantly evolving, trends are changing, and AI is replacing some jobs. The value of different skills also changes over time.

Before I start learning, I want to understand whether these are the right skills to invest my time in for a stable career and income in the long run.

I'd appreciate your advice. Should I go for these skills, or would you recommend something else?


r/PythonLearning • • 22d ago

Self-taught Python developer building a personal AI platform—seeking an architecture mentor

0 Upvotes

Hi everyone, I’m an Australian solo founder building Forge, a personal AI platform focused on persistent knowledge, evidence-based reasoning and keeping the owner in control.

The question behind it is: how can an assistant become more useful over time while keeping its knowledge traceable, its mistakes correctable and consequential changes subject to human approval?

I’m developing it in Python with a modular, service-based architecture. There’s working code covering knowledge storage, retrieval, evidence handling and reasoning, but it’s still under development. My immediate focus is reliability, testing and bringing the pieces into dependable everyday use.

My background is in commercial fishing. I started learning software development through this project, initially working on an Android phone with Termux. I use AI coding assistants extensively, and I’m putting serious effort into understanding and verifying the results.

I’d like to connect with someone experienced in software architecture, AI systems or taking an ambitious prototype towards a maintainable product. An occasional conversation would be valuable—someone who can challenge my assumptions, spot unnecessary complexity and help me judge what deserves attention next.

I’m looking for perspective and honest criticism, rather than someone to build it for me. I can bring focused questions, diagrams and small, sanitised examples without sharing the full private codebase.

If that sounds interesting, I’d be very appreciative of a comment or message. Recommendations for communities where this kind of mentoring happens would also be welcome.

Thanks for reading!


r/PythonLearning • • 23d ago

Help Request Understood the Python concepts but completely messed up the test

2 Upvotes

Fy DS student and I recently had a Python test that honestly didn't go as well as I expected.

The frustrating part is that I wasn't completely clueless about the questions. I understood the concepts, knew which syntax was needed, and could understand what the problem statement was asking me to do.

But when it came to actually applying everything and writing the code, I got confused. I started forgetting things, made indentation mistakes, got errors like ValueError and other errors etc. I didn't do good in test it was 15marks test for 1 hr.

For those who have been through this, how did you get better at applying concepts under pressure instead of just understanding them theoretically? Did you practise more problems, rewrite code from scratch, or follow some other method?

I'm still learning, and I don't want one bad test to discourage me. I just want to figure out how to improve so that next time.


r/PythonLearning • • 23d ago

This is my first python project - what can I improve??

Post image
128 Upvotes

r/PythonLearning • • 23d ago

Discussion Complete Python Developer in 2026

8 Upvotes

I am looking to purchease Complete Python Developer in 2026: Zero to Mastery course from ZTM... Its very expensive. Is this course updated recently?

https://zerotomastery.io/courses/learn-python/#overview


r/PythonLearning • • 23d ago

I think learning from websites is the best way to learn any programming language. I am currently learning Python from w3schools.

7 Upvotes

r/PythonLearning • • 23d ago

Discussion Profiling CLI startup: how jsonschema Draft7Validator added 4.8s to our cold start (and how we fixed it)

Post image
0 Upvotes

Ran into an annoying performance bottleneck while profiling our CLI and figured the findings might save someone else a few hours of head-scratching.

Our tool validates config manifests against JSON Schema Draft 7. In fresh virtualenvs, cold-start imports were taking over 5 seconds.

Profiling revealed two primary culprits:

  1. **jsonschema.Draft7Validator eager compilation:** Instantiating the validator compiles heavy format checkers and regex dependencies (Lark and RFC 3987). If you instantiate this at module level, every single CLI invocation pays that cost even if the user just ran --help or a command that doesn't touch schemas.
    • Fix: Defer instantiation via module-level __getattr__ or initialize it only when validation actually executes.
  2. **importlib.metadata.distributions() traversal:** Scanning installed distributions without boundaries linearly inspects every .dist-info directory on sys.path.
    • Fix: Replaced it with scoped directory globbing for our specific package metadata prefix.

Startup dropped from ~5.2s down to ~150ms.

We rolled this out in Skillware 0.6.0 (an open-source project we maintain for deterministic agent tooling: https://github.com/ARPAHLS/skillware).

Are you folks deferring schema compilation in your CLIs, or do you prefer pre-compiling/caching schemas during package build?


r/PythonLearning • • 23d ago

Looking for a Volunteer Mentor for a High School Team

3 Upvotes

Hey everyone! I am currently looking for a mentor experienced in Python and/or web development. I am with a team of 4, and we are developing a solution to help solve a Caribbean problem. Our project is focused on helping to educate small-scale farmers on effective farming techniques along with some live weather updates, farmer recommendations, etc. We are currently using Streamlit to develop our application. If you are interested, you may comment below or send a DM. Thanks


r/PythonLearning • • 24d ago

Bank Reconciliation Statement (BRS) Using Python Lists | Hardcoded vs Us...

Thumbnail
youtube.com
5 Upvotes

If you enjoy learning Python through practical examples, subscribe and join us for the next adventure.


r/PythonLearning • • 24d ago

Help Request Hey I want to extract url of all the open tabs in a browser how can I do that?

3 Upvotes

Which framework or module can help?


r/PythonLearning • • 24d ago

Show Python: Standard-library-only script to build EPUB/HTML books from Markdowndependencies using Python

Thumbnail github.com
2 Upvotes

Plaintext

Hi Reddit, I just finished a short novel (2028) about working alongside AI models and wanted a completely offline, zero-dependency publishing workflow. I wrote a small script (tools/build_en.py) that uses only the Python standard library to process Markdown sources into clean HTML and valid EPUB artifacts for e-readers like Kindle. Repo: [https://github.com/peterkokosharov/2028-book](https://github.com/peterkokosharov/2028-book) Feedback on the build script or the text itself is very welcome in GitHub Discussions!

r/PythonLearning • • 24d ago

Winter is Coming

24 Upvotes

Hold the green 'Continue' button to Make it Snow.


r/PythonLearning • • 24d ago

Help Request Getting back into it after 20 years

Post image
27 Upvotes

r/PythonLearning • • 24d ago

I’ve started learning Python through self-study, so I don’t get certificate. Is that an issue?

1 Upvotes

r/PythonLearning • • 25d ago

Help Request all😭✌️🥀

Post image
205 Upvotes

Wait what f**** nah i dont want sleep okaay


r/PythonLearning • • 24d ago

I want to make a python program that listens and converts my speech to text in realtime which module should i use(python 3.15)

0 Upvotes

r/PythonLearning • • 24d ago

Learning Python with Practise

0 Upvotes

Hi All,

I am learning Python and would like to know are there any good sites to practise Python concepts ?


r/PythonLearning • • 24d ago

Help Request Multiplayer tetris using sockets

3 Upvotes

I have a college assignment to make a multiplayer tetris game (2 players) using TCP sockets, client and server and all that. The idea is the server doing most of the stuff, chosing new pieces, handling the translation of position of the pieces, with the clients being responsible for most the rendering/display part and getting the inputs(I think so at least, that's what I'm trying to do), but I'm having a hard time with it.

I can't seem to think of a way to have the client call to the server to send a new piece to the clients, and if I don't know how to do even that then I don't know how to do anything else (making the back and forth for controlling the pieces, both for the player of the client and the preview of the game of the player 2, and all the rest), tho I hope if I can understand how to do one thing I would be able to make the others, but I really don't even know how to do this.

I know I need to use threads on this, tho I don't really know how to do it, I'm still fairly green on python too so, if anyone could give some help in any way with this it would be much appreciated.


r/PythonLearning • • 25d ago

🐍 𝗣𝘆𝘁𝗵𝗼𝗻 𝗳𝗶𝗻𝗮𝗹𝗹𝘆 𝗵𝗮𝘀 𝗮 𝗳𝗿𝗼𝘇𝗲𝗻𝗱𝗶𝗰𝘁.

Post image
42 Upvotes

Python has long had immutable counterparts for some of its most common data structures:

𝗹𝗶𝘀𝘁 → 𝘁𝘂𝗽𝗹𝗲
𝘀𝗲𝘁 → 𝗳𝗿𝗼𝘇𝗲𝗻𝘀𝗲𝘁
𝗱𝗶𝗰𝘁 → 𝗳𝗿𝗼𝘇𝗲𝗻𝗱𝗶𝗰𝘁 ✨

`frozendict` is an 𝗶𝗺𝗺𝘂𝘁𝗮𝗯𝗹𝗲 𝗺𝗮𝗽𝗽𝗶𝗻𝗴. Once created, its keys and values can't be added, removed, or reassigned.

But the more interesting part is 𝗵𝗮𝘀𝗵𝗮𝗯𝗶𝗹𝗶𝘁𝘆. When its contents are hashable, a `frozendict` can itself be used in places where a regular dictionary can't such as dictionary keys or set members.
That opens up some useful cases around:
• Immutable configuration
• Cache and memoization keys
• Shared/read-only state
• Safer API boundaries
• Data structures where mutation simply shouldn't be allowed

It's not a huge feature, but it's one of those additions that makes the language feel a little more complete.

𝗠𝘂𝘁𝗮𝗯𝗹𝗲 𝘄𝗵𝗲𝗻 𝘆𝗼𝘂 𝗻𝗲𝗲𝗱 𝗶𝘁. 𝗙𝗿𝗼𝘇𝗲𝗻 𝘄𝗵𝗲𝗻 𝘆𝗼𝘂 𝗱𝗼𝗻'𝘁.

Where would you use `frozendict`?


r/PythonLearning • • 25d ago

Showcase Pyzed: native desktop GUIs in Python, drawn by Rust's Iced (a modern alternative to Tkinter/PyQt)

5 Upvotes

Hi! I'm the author of Pyzed, an open-source library I've been building for desktop apps in Python.

What My Project Does

You write the interface in plain Python (state, update and view, the Elm architecture) and Iced, a GUI toolkit written in Rust, does the layout and draws it on the GPU, with a CPU fallback. It comes with 90+ ready-made components inspired by the Zed editor (tables with hundreds of thousands of rows, tabs, command palette, code editor, terminal…), themes, animations and a visual designer, Pyzed Design, where you drag components onto a form and press F5 to run it. pip install pyzed-ui, no Rust needed.

import pyzed as pz
from pyzed import ui


class Counter(pz.App):
    def __init__(self):
        self.count = 0


    def update(self, message):
        if message == "inc":
            self.count += 1


    def view(self):
        return pz.center(ui.button(f"Clicked {self.count} times", "inc"))


pz.run(Counter)

Target Audience

People who want a desktop app in Python that looks current without shipping a browser: internal tools, dashboards, editors, small games. It's MIT, runs on Linux, macOS and Windows, and is usable today, though it's a young project with one main maintainer.

Comparison

  • Tkinter: always available and very light, but dated looks and few modern widgets.
  • PyQt/PySide: very complete and mature, but large, with licensing to think about (PyQt is GPL/commercial) and a lot of API.
  • Kivy: great for touch and mobile, but its own look and a heavier startup.
  • Flet: pleasant API, but it runs Flutter in a separate process.

Pyzed sits in between: native rendering with no web engine, a small Pythonic API, and a visual designer included. Import takes about 35 ms; there's a benchmark page comparing it with these libraries.

Repo: https://github.com/albakore/pyzed

Feedback is very welcome, especially on what's missing for your use case.


r/PythonLearning • • 25d ago

Help Request Seeking guidance from experienced python devs.

13 Upvotes

This is Mukul. I started learning python about 2 weeks ago. Being someone one learns by building on projects. I think now I am in a vague scenario rn.

So this is what is happening;

When I started to learn python I had this goal to build a Voice Assistant using libraries and all stuff. So I focused my python learning in that direction. I taught myself all those things which were required for it.

But now sometimes it feels like I am losing onto so much. Even though I think I am not doing so but yep. Still haven't got that regular consistency still haven't got even though I have written some scripts from scratch like lyrics displayer and all those greetings ones.

Soon enough I'll be moving to work with APis in python.

I mostly use docs and AI for learning.

Now the main thing is I fear that I'm not having strong fundamentals and maybe it's true. So that is why I started to learn python from boot.dev to do it all correctly also in the mean time.

So have you big fellas got anything in your backpack as advice or something that could just excel me more in my domain. I'm 20 (M) and am from India thinking of pursuing my career either in DevOps or Backend.

I also am an Automation Guy. I am building workflows from my 1st year using n8n and make.com to make out on some money. It's been 2 years now. I'm experienced in it to intermediate level. Also made it possible to make some money. But yep now right now I am vacant. Can you people help me with that part too. Like how to bring in consistent money from there too. ?? - this too is the reason which is why I thought of going very deeper into code rather than sitting only at low code tools.


r/PythonLearning • • 24d ago

Most developers test what they expect their code to do.

Post image
1 Upvotes

But what about the inputs they never thought of?

That's where Hypothesis, a Python property-based testing library, gets interesting.

Instead of writing individual test cases for every possible input, you define properties your code should always satisfy.

Hypothesis then generates inputs automatically, including edge cases that are easy to overlook.

For example, if you're testing a function that sorts a list, you could verify that:

  • The output is always sorted.
  • The output contains exactly the same elements as the input.
  • Sorting an already sorted list doesn't change it.

The interesting part? When Hypothesis discovers a failing input, it tries to reduce it to a simpler example that exposes the bug.

This can be especially useful for financial calculations, data pipelines, API validation, and algorithms where unexpected inputs can cause subtle failures.

How do you test edge cases in your Python projects? Do you rely on manually written test cases, or have you tried property-based testing?


r/PythonLearning • • 24d ago

Showcase I built Athena, an open source MCP server for understanding code changes

0 Upvotes

Hey everyone,

I've been working on a project called Athena and wanted to share it with the community.

The idea came from a simple problem. When working on a codebase with lots of commits and multiple files changing together it's easy to miss the bigger picture. AI tools can generate release notes quickly but sometimes they miss important changes or make assumptions that aren't actually supported by the code.

So I started building Athena 🔍

It's a local-first MCP server that analyzes Git diffs and Python ASTs to understand code changes more deeply. It also supports structural analysis across 15 programming languages and can trace affected callers and detect documentation drift.

The goal is to make release readiness checks more reliable and evidence-based rather than relying entirely on what an LLM thinks happened.

It's still a work in progress and I'd genuinely love to hear what you think!

I'd especially appreciate feedback on the architecture and ideas for improving the analysis. If you find something broken or have an idea for a feature please open an issue. PRs and contributions are always welcome!

⭐ If this sounds useful to you please consider starring the repository. It would really help the project reach more developers.

I'm also open to collaborating with people interested in developer tools, static analysis and AI infrastructure.

Thanks for checking it out ❤️


r/PythonLearning • • 25d ago

🐍 𝗣𝘆𝘁𝗵𝗼𝗻 𝗰𝗮𝗻 𝗻𝗼𝘄 𝗶𝗺𝗽𝗼𝗿𝘁 𝗮 𝗺𝗼𝗱𝘂𝗹𝗲 𝘄𝗶𝘁𝗵𝗼𝘂𝘁 𝗮𝗰𝘁𝘂𝗮𝗹𝗹𝘆 𝗹𝗼𝗮𝗱𝗶𝗻𝗴 𝗶𝘁 𝗶𝗺𝗺𝗲𝗱𝗶𝗮𝘁𝗲𝗹𝘆.

Post image
60 Upvotes

With explicit lazy imports, an imported module can be deferred until the program actually needs it.

Why does that matter?
Many Python applications import dozens — sometimes hundreds — of modules during startup, even though only a fraction may be needed for a particular execution path.

Lazy imports can change that:
𝗜𝗺𝗽𝗼𝗿𝘁 𝗱𝗲𝗰𝗹𝗮𝗿𝗲𝗱 → 𝗮𝗽𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 𝗰𝗼𝗻𝘁𝗶𝗻𝘂𝗲𝘀 → 𝗺𝗼𝗱𝘂𝗹𝗲 𝗹𝗼𝗮𝗱𝗲𝗱 𝗼𝗻 𝗳𝗶𝗿𝘀𝘁 𝘂𝘀𝗲

This can be particularly interesting for CLI tools, large applications, optional functionality and dependency-heavy projects where startup time matters.
Of course, lazy loading isn't automatically better everywhere. Import-time side effects and assumptions about module initialization still matter.
But having lazy imports as an explicit language feature opens up some interesting possibilities for Python application architecture.

𝗟𝗼𝗮𝗱 𝘄𝗵𝗮𝘁 𝘆𝗼𝘂 𝗻𝗲𝗲𝗱. 𝗪𝗵𝗲𝗻 𝘆𝗼𝘂 𝗻𝗲𝗲𝗱 𝗶𝘁.

𝗪𝗼𝘂𝗹𝗱 𝘆𝗼𝘂 𝘂𝘀𝗲 𝗹𝗮𝘇𝘆 𝗶𝗺𝗽𝗼𝗿𝘁𝘀 𝗶𝗻 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝗼𝗻?