RE: Python Practicing Again
You are viewing a single comment's thread:
Uppercase Letter and lower case letters could be their own functions, called in a loop to generate passwords of differing lengths based on user input.
You want to try and avoid writing the same line of code more than once, it makes it much cleaner :)
0
0
0.000
Yeah I know there's a lot of structural things that need to be refined over time but I think for me, I'm about getting something under my belt for now and I'll refine as I can. I appreciate the tip and feedback! It's a fun journey and one that may bear fruit in the future but when I started this a few years ago I wouldn't have guessed that AI could write code for us lol. It's wild to think of!
One thing for me that's cool after getting to these points is being able to read a bunch of lines of code and have a rough idea of what it's supposed to do!
I'm only about 8-9 months into writing Python, so I'm no expert by any stretch of the imagination. I mainly use it for data analysis and data cleaning.
Yeah that’s one of the other fun things about Python for me as well! I, for work, ended up getting pretty good at data analytics stuff having access to a data lake at work so I got pretty good at SQL queries to figure out what I could get but also excel and other things.
With Python I originally was getting into it for trying to code a game or something but then saw it was really helpful for analytics so I figured what the hell it can’t hurt to use it for a few things!
We mostly use Power Query at work, with a bunch of SQL to get things off the databases into Power BI reports. My work is mainly doing reporting now, I miss the analytical / business process improvement side of the work; as I see so many issues in the what we want in a report, compared to what the actual business problem is.
Yeah! I got pretty good at Power Query! I did a lot with turnaround times for things so I needed to duplicate and then split columns then change the timeframe from 12 hour times with AM/PM to military 24 hour time, adding in another step in the data transformation. You can only really do that (effectively) in Power Query with large datasets in Excel, I learned that pretty well! I'd be running it on sheets with 75k+ rows, some 200k+ so it was really fun. Bringing back some good memories for me! Lol. It's funny, now when I see someone at work that is presenting an Excel file if the background on the data is green I instantly know they likely used PQ to get it to display that way! Lol.
I hear you on the things we miss. I'm in a completely different role now where these things aren't really something I get to do, certainly not in the capacity I was doing it before and it makes me a little sad. I do consider trying to offer my consulting services to the group I used to work for hahaha they were always asking me to build them reports!
Our data sets are of similar sizes. There's a lot of joins done in the back end before they go to dataflows, and such.
It's been a good few weeks, no automated data refreshes have failed in that period. When I go back to work on Monday I hope it is the same story.