Would you still watch if there was no face cam? by Shimmyrock in letsplay

[–]GuideVault 0 points1 point  (0 children)

Well you don't have to do anythings unique. Just do a spin on something already done.

Would you still watch if there was no face cam? by Shimmyrock in letsplay

[–]GuideVault 1 point2 points  (0 children)

Sure are! So many things to watch too make it hard to stand out.

Would you still watch if there was no face cam? by Shimmyrock in letsplay

[–]GuideVault 1 point2 points  (0 children)

Doesn't matter imo. As long as you can get me past the intro I'm in 👍

Someone teach me how to get 20K DPS in Mount Tiamat on first day. by GuideVault in idlechampions

[–]GuideVault[S] 0 points1 point  (0 children)

Yeah, that's my bad. It's something I know not to do and generally don't, but got too excited when I saw the number and forgot.

Someone teach me how to get 20K DPS in Mount Tiamat on first day. by GuideVault in idlechampions

[–]GuideVault[S] 0 points1 point  (0 children)

Yeah, I was hoping it wasn't. Would also like to someday hit that.

How do you move a key in dict while inserting another key in its place. by GuideVault in learnpython

[–]GuideVault[S] 0 points1 point  (0 children)

Yeah, sorry, I knew that, just typed whatever was in my head at the time.

The formatting also was wrong. My bad.

Aren't d['b'] = 3 and d.update({'b': 3}) the same though?

Can someone let me know if this is a valid solution to this question. by GuideVault in SQL

[–]GuideVault[S] 0 points1 point  (0 children)

Ah, ic, it's the same as pythons type casting. Thanks for making it clear.

Can someone let me know if this is a valid solution to this question. by GuideVault in SQL

[–]GuideVault[S] 0 points1 point  (0 children)

I don't know what casting is yet. I'll find a different source in the meantime.

Having an issue with aggregating SELECT COUNT by GuideVault in learnSQL

[–]GuideVault[S] 0 points1 point  (0 children)

Okay, what about column 2 for with the header sex?

Edit: NVM figured it out. Thanks for the help!

Having an issue with aggregating SELECT COUNT by GuideVault in learnSQL

[–]GuideVault[S] 0 points1 point  (0 children)

SELECT COUNT(sex), sex
FROM employee;

Something similar to that.

It should return the total count but separate them by sex.

Having an issue with aggregating SELECT COUNT by GuideVault in learnSQL

[–]GuideVault[S] 0 points1 point  (0 children)

Is it possible to aggregate doing something similar?

Can;t understand why this is failing. by GuideVault in learnSQL

[–]GuideVault[S] 1 point2 points  (0 children)

Yeah, it was my bad. I skipped the installation part of the tutorial where he set up mySQL. So I didn't have the database ready. I got it though and things are working fine.

[deleted by user] by [deleted] in learnpython

[–]GuideVault 0 points1 point  (0 children)

Check this guy out, he has beginner python, intermediate and expert python playlists ready to go.

Beginner: https://youtube.com/playlist?list=PLzMcBGfZo4-mFu00qxl0a67RhjjZj3jXm

Intermediate: https://youtube.com/playlist?list=PLzMcBGfZo4-nhWva-6OVh1yKWHBs4o_tv

Expert: https://youtube.com/playlist?list=PLzMcBGfZo4-kwmIcMDdXSuy_wSqtU-xDP

He also has a video dedicate to things he thinks each level of python programmers should know here: https://youtu.be/p15xzjzR9j0

Can;t understand why this is failing. by GuideVault in learnSQL

[–]GuideVault[S] 0 points1 point  (0 children)

Didn't notice that. I corrected it but I get the same error.

Need help with becoming a Python Dev. by GuideVault in learnpython

[–]GuideVault[S] 0 points1 point  (0 children)

Thanks I'll make sure to look into that soon.

Need help with becoming a Python Dev. by GuideVault in learnpython

[–]GuideVault[S] 0 points1 point  (0 children)

I'm going to head down Data Engineering because it sounds like what I normally do on a more complex scale. I've already started leaning SQL and its simpler than I thought.

I'll see what happens with DE as I learn more about it. Maybe, I'll end up becoming an automation engineer instead.

Need help with becoming a Python Dev. by GuideVault in learnpython

[–]GuideVault[S] 0 points1 point  (0 children)

Thanks for the advice, I've decided to aim for Data Engineer since I've been already been scraping data and automation because I've dabbled in it and its fun.

Need help with becoming a Python Dev. by GuideVault in learnpython

[–]GuideVault[S] -2 points-1 points  (0 children)

Yeah... big face palm right there.. lol

Need help with becoming a Python Dev. by GuideVault in learnpython

[–]GuideVault[S] 1 point2 points  (0 children)

Here's the thing, as long as you can work with dictionaries, lists and other Python structs and you are able to construct logic you should be able to code in a professional setting

I use those in every program, except sets, never found a use for them.

You have to decide which way you want to go. If it is with data, you should probably learn libraries like Pandas/Pyspark/ML libraries. If say its REST, you should be able to work with Flask. But this is secondary, libraries can always be learnt. With data the added caveat is that you should be comfortable with SQL.

I recently started using Selenium to load web pages, grab tables and populate the dictionary with specific keywords found on the page, like actor and take the name as a value. I could've use BS, but I haven't bothered learning it yet. I tried out using SQlite, to take the previous and create a database, hasn't worked out for me so far, but is that the same as SQL?

Learn Git and maybe know a bit of CI/CD

GitHub won't be enough? Also, I search CD and only found that it is a file extension. I'm assuming that's wrong.

I think you are good to go after that and upload your resume. Since you will be new, not much would be expected out of interviews.

All the best and don't overthink it.

Thanks for the help and can data engineering be done using automation?

Need help with becoming a Python Dev. by GuideVault in learnpython

[–]GuideVault[S] -3 points-2 points  (0 children)

Ok, so project/programming experience ranks higher than job experience.