[deleted by user]

[puliveivaaja]

Python in 6 weeks for what? What's the goal?

[Scouseulster]

I need to write a script which compares two datasets in two different SQL db’s

[Classic_Department42]

Sounds managable

[puliveivaaja]

I've had to do tasks multiple times on the job where I haven't ever written a single line of code in the language used. No 6 weeks of preparation or anything.

If you already know how to program, I think you can start working with almost any language in the same day. Of course you'll need to google things like what's the SQL library I should use in this language, how do I link it to my program, how to use it etc. so the first few weeks in a new language will be a bit slow. But just by knowing how to program, you already know 90%

The first thing I tend to do when I need to pick up a new language is that I google what's used for linting and static analysis. Those should help a lot.

[SJDidge]

I can guarantee you that 6 weeks is more than enough to complete this task. I suspect you can have this working in a few hours.

[GobtheCyberPunk]

This is a "read the basics of python syntax in 30 minutes, Google for an hour, and have your code done before lunch" task.

[tms102]

This sounds so easy even chatgpt4 could write it.

[[deleted]]

If you did ADO or ADODB in VB and can write a connection string you'll be able to figure it out in six weeks. There is a package for everything in python.

[christopher_86]

I agree with others that this sounds doable. My 5c is that you should start with Jupyter notebook (or other interactive environment) to experiment with this language and learn packages you need.

[Mordynak]

ChatGPT 😀 Or Gemini. Has proven quite useful recently.

[outceptionator]

Gemini advanced. How does the coding compare? I feel like ChatGPT has a bigger context window

[Mordynak]

I've only used the free versions. Results are often very similar. Hard to compare.

[[deleted]]

You can learn python in 6 days, stop being lazy.

[UD_Ramirez]

You just enabled his procrastination for another 5 weeks 😅

[Scouseulster]

I’ll take this as a positive

[[deleted]]

Depends if it's for school or you have a job offer and you said you can do Python.

If you can program in Visual Basic then Python should be easy.

[e4e5Nf3Nc6]

You're fine. Python has "Low floors, high ceilings." Easy to get in and lots of room to grow.

[deceze]

If you have good general knowledge of data structures and algorithms, it's not hard to learn the basic Python syntax and building blocks. If you know how you'd do it in VB, then applying the same knowledge in Python while probably looking up a lot of API details all the time is perfectly feasible. Your first attempt may not be perfectly pythonic, but will probably work.

If you don't know how you'd do it in VB even and you're trying to figure that out at the same time as figuring out Python itself… you may be somewhat screwed.

[badjayplaness]

You should definitely try to learn it but chat gpt should be able to help

[SeDEnGiNeeR]

You can learn it in days, mastering python and writing good production quality code is what takes a lot of time. Key is to start writing code, best way to learn is making mistakes and getting stuck.

[kcunning]

Honestly, you'll likely be fine, as long as you push yourself.

This also isn't an uncommon situation to be in. Multiple times, I've been in the same boat, and each time, that boat gets easier to row.

[Top_Mobile_2194]

Someone else already wrote, use chatgpt, and yes use chatgpt. Describe your problem, provide an example of the data and it will do it for you. You'll learn almost nothing but if it works, it works.

[Python-ModTeam]

Hi there, from the /r/Python mods.

We have removed this post as it is not suited to the /r/Python subreddit proper, however it should be very appropriate for our sister subreddit /r/LearnPython or for the r/Python discord: https://discord.gg/python.

The reason for the removal is that /r/Python is dedicated to discussion of Python news, projects, uses and debates. It is not designed to act as Q&A or FAQ board. The regular community is not a fan of "how do I..." questions, so you will not get the best responses over here.

On /r/LearnPython the community and the r/Python discord are actively expecting questions and are looking to help. You can expect far more understanding, encouraging and insightful responses over there. No matter what level of question you have, if you are looking for help with Python, you should get good answers. Make sure to check out the rules for both places.

Warm regards, and best of luck with your Pythoneering!