Lurker > SamusGlory

Currently learning SQL and Python right now and they are kinda daunting tbh

https://gamefaqs.gamespot.com/a/user_image/9/6/1/AASCCgAADF_R.png

https://gamefaqs.gamespot.com/a/user_image/9/6/2/AASCCgAADF_S.png

Watching the first lecture of the python course right now and this kinda blew my mind. I didn't know that I could add commas into the big numbers like this.

bump

python course is starting today

bump

Prepping for the python course today. Hopefully I will get a better understanding about dictionaries

Assuming they have no thermal scope

bump

SomeLikeItHoth posted...

Learning more about objects and arrays in JavaScript :D

are u planning to get that certificate from that python course that u linked us? planning to get it but its like 200 bucks lol but i think it will look good on my resume

bumpp

bump

Yeah I have used SQL since last November and it's pretty fun and kinda complex to learn.

Trying to be a data analyst in the future as well. My goal is to create more projects with SQL and be more familiarized with it.

https://gamefaqs.gamespot.com/a/user_image/1/7/7/AASCCgAADCn5.png

https://gamefaqs.gamespot.com/a/user_image/1/7/8/AASCCgAADCn6.png

In one of my recent projects, I was able to find which Marvel movie made the 2nd highest revenue.

balloons?

SomeLikeItHoth posted...

Reminder y'all that in less than two weeks, the CS50 Python course begins, so make sure you guys mentally prepare to spend a good 10 hours each week working on it. @SpiritSephiroth

Cool. I was hoping y'all wouldn't mind me posting as well.

np man and thanks for the reminder as well.

gonna code tonight

Gonna use my time to focus on SQL instead of Python since I'm leaning towards being a data analyst. Of course, I will be learning Python in the future once I get the hang of SQL.

Anyways, I guess this is a General Computer Coding Topic now.

Here are the queries that I have been working on:

https://gamefaqs.gamespot.com/a/user_image/1/7/7/AASCCgAADCn5.png

https://gamefaqs.gamespot.com/a/user_image/1/7/8/AASCCgAADCn6.png

By executing this query, I was able to find which Marvel movie made the 2nd highest revenue (1st was Avengers Endgame obviously)

https://gamefaqs.gamespot.com/a/user_image/1/7/9/AASCCgAADCn7.png

https://gamefaqs.gamespot.com/a/user_image/1/8/0/AASCCgAADCn8.png

Here, I can determine which series between Spider Man and Avengers made more revenue than the other (This is including Amazing Spider Man series, Into the Spider-Verse, Tobey Maguire ones, etc)

In this case, this shows that the Spider-Man series made more revenue than all 3 Avengers movie combined.

AloneIBreak posted...

What background are you coming from, TC? Do you have prior programming experience?

sorry that i skipped this, but i used to work at a retail store for about 4 years, logistics for 4 months, and accounting for 1 year lol i dont havr any prior programming experiences

bump

SomeLikeItHoth posted...

Thanks! Now I'm working on Blackjack. I'll post it when I'm done. It's going to take a bit longer but hopefully I'll be done this week.

Which courses fam?

https://www.udemy.com/course/complete-python-bootcamp/
https://www.udemy.com/course/python-for-data-science-and-machine-learning-bootcamp/

scar the 1 posted...

Yeah, it's good to get a hang on data structures. They're a core component of programming in general, so learning how they work and how they differ from each other is one of the most important general skills as you advance.

Thanks for the tip! I will keep that in mind.

gonna use this day to relax since my head kinda hurts

SomeLikeItHoth posted...

My unit converter is done!

Took 15 lines of JavaScript and an hour but I made it.

nice bro!

i havent been doing python that much since I'm focusing more on SQL. I will be practicing python more tonight.

bought some udemy courses for python, SQL, and tableau when they were on sale this week.

https://gamefaqs.gamespot.com/a/user_image/8/2/5/AASCCgAADAVx.png

https://gamefaqs.gamespot.com/a/user_image/8/2/6/AASCCgAADAVy.png

still trying to get used to dictionaries. I learned how to do the loop for this one.

Raccoon City

Did a mini project on a python quiz today. It was pretty fun.

https://gamefaqs.gamespot.com/a/user_image/5/3/6/AASCCgAADABo.png

https://gamefaqs.gamespot.com/a/user_image/5/3/7/AASCCgAADABp.png

https://gamefaqs.gamespot.com/a/user_image/5/3/8/AASCCgAADABq.png

didnt code over the weekend cus i was out of town but i downloaded this app named Mimo to help me refresh my memory

Today I started learning about dictionaries. It seems kinda difficult at first but I'm sure that I will get it down. And thanks SpiritSephiroth!

https://gamefaqs.gamespot.com/a/user_image/4/5/6/AASCCgAAC_hI.png

https://gamefaqs.gamespot.com/a/user_image/4/5/7/AASCCgAAC_hJ.png

Today I learned that you can check if the list has the values the user needs are available or not.

https://gamefaqs.gamespot.com/a/user_image/2/0/5/AASCCgAAC_Nl.png

https://gamefaqs.gamespot.com/a/user_image/2/0/6/AASCCgAAC_Nm.png

warlock7735 posted...

One other trick you can do is something like..... (I don't use python and am on my phone so syntax might be funky)

colors= ['red', 'green', 'blue', 'yellow', 'purple', 'orange']
Liked_colors=['red', 'blue']

for color in colors:
If color in Liked_colors:
Print(f"I like {color}")

but you'll want to be aware that you're iterating over the second array for every time you step over the first. It's just a convenient way of not needing to make a case for every output.

Thanks man, I will keep that in mind.

I've also been practicing SQL too. Today has been a productive day since I've been practicing SQL and Python for many hours. I learned that in order to check if the list is empty or not, I should type out the code like this.

https://gamefaqs.gamespot.com/a/user_image/5/4/2/AASCCgAAC_DO.jpg

https://gamefaqs.gamespot.com/a/user_image/5/4/3/AASCCgAAC_DP.jpg

https://gamefaqs.gamespot.com/a/user_image/4/0/8/AASCCgAAC-xg.png

https://gamefaqs.gamespot.com/a/user_image/4/0/9/AASCCgAAC-xh.png

I learned that you don't have to do the loop for each of the values one by one. If I could only do one "if" and the rest on "else" then that would go through the list a lot easier.

i miss it so much

Blue_Thunder posted...

Please excuse my nitpicking but there's no 'Jessie' in the list :p

Anyways, wishing you the best!

damn u right lol thanks man

SomeLikeItHoth posted...

How far along are you in Python Crash Course?

Still learning about the if statements. I just learned that you don't really need to have the "else" at the end and you can just continue on with the "elif"

I just created this little code for the grocery list.

grocery_list = ['eggs', 'milk', 'bread', 'cheese']

if 'eggs' in grocery_list:
print("Adding eggs into the shopping cart.")
if 'milk' in grocery_list:
print("Adding milk into the shopping cart.")
if 'bacon' in grocery_list:
print("Adding bacon into the shopping cart.")
if 'bread' in grocery_list:
print("Adding bread into the shopping cart.")
if 'cheese' in grocery_list:
print("Adding cheese into the shopping cart.")
if 'apples' in grocery_list:
print("Adding apples into the shopping cart.")

print("\nFinished adding the items into the shopping cart. Are you ready to check out?")

This should exclude the bacon and apples from being in the shopping cart.

warlock7735 posted...

Python is fine if you want to learn to code, If you want to develop a deeper understanding I would recommend struggling through elementary c or c++, or for something higher level c#. Even though most modern programming languages don't use pointers, being able to implement data structures by hand and managing memory manually will give you a ridiculous level of understanding when you use GC languages that do the work for you

thanks I will keep that in mind. I was using C++ when I took a CS course back in college and it was pretty interesting and hard lol

Currently messing around with if/else statements at the moment.

print("Welcome to the liquor store. Are you old enough to buy alcohol here?")

raw_age = input("How old are you? ")

age = int(raw_age)

if age >= 21:
print("You are old enough to buy alcohol in the liquor here.")
else:
print("Sorry, you are not old enough to buy alcohol here.")

SomeLikeItHoth posted...

Sign up. I'll tag you when it starts.

https://www.edx.org/course/cs50s-introduction-to-programming-with-python

thanks ill sign up when I get home

SpiritSephiroth posted...

It was for an IT job and I'm still looking for now. Hopefully I'll get into IT while studying and make my way towards a programming job while becoming more proficient.

you got this bro

SomeLikeItHoth posted...

I recommend freeCodeCamp. It's a great resource. Same with The Odin Project, though The Odin Project is a lot more reading. If you decide to do either, I recommend taking notes and print them out and study them during down time.

very good tips. I'm also learning from youtube too

anyways, I just learned about the if statement for a bit:

people = ['Brian', 'James', 'Nikki', 'Christine']
for person in people:
if person == 'Jessie':
print(f"{person} is my girlfriend.")
else:
print(f"{person} is my friend.")

The output for this is:
Brian is my friend.
James is my friend.
Jessie is my girlfriend.
Christine is my friend.

Pretty useful to loop through everything in the list.

SpiritSephiroth posted...

Goodluck dude. I'll share some stuff here too as well if I get the time.

Those mad lib games were super fun when I started as well.

Thanks man, did you end up getting your coding job? I think you mentioned about it and I may be wrong.

VigorouslySwish posted...

Im going to start learning in a couple days myself

Nice, where are you gonna learn it from?

I recently got let go from my previous job and I'm tired of working for shitty pay and on-site so I'm gonna use the free time that I have to study coding. I don't really know what I want to do as my career yet, but my main goal is to get the foundation down for Python and go from there. I started coding last November for a little bit but I stopped because I had a full-time job, but now I'm gonna study as much as I can. I might possibly look for a part-time job though in the future, but I'm in no rush since I got some money saved up. Any tips for me would be wonderful.

Major props to @SpiritSephiroth for inspiring me to do this awhile ago when he made that Python topic.

I'm studying from this book at the moment:
https://www.barnesandnoble.com/w/python-crash-course-2nd-edition-eric-matthes/1137572066?ean=9781593279288

I did a mini project on Mad Libs last week:
https://i.imgur.com/VFXF442.png

Currently learning about tuples from the book right now and messing around with it. Hopefully I will get a coding job in a year or so.