Data Cleaning in MySQL | Full Project
51:11
Пікірлер
@ozgunc4735
@ozgunc4735 17 минут бұрын
Hi Alex, I watch your tutorials, it's really nice and understandable, thanks a lot. I have a problem. Despite it all makes sense when I watch videos, I have hard time to remember these things. So what's your suggestion for making all these knowledge memory, remind it all later as well. I plan to do w3school sql tutorial as well after finishing your tutorial. But if I can get advice from you I'd appreciate.
@Grumpy-J
@Grumpy-J 33 минут бұрын
Great series, thank you! (FWIW, Subbed and thumbs up to all the vids in this series)
@anchal_diary
@anchal_diary Сағат бұрын
video is little bit blur. is it only for my of is is like that ??
@theblackwoodworkerwilliams4370
@theblackwoodworkerwilliams4370 Сағат бұрын
Great video Alex! I especially liked the shout out to the BA with the good people skills 😎
@javiercarrion6843
@javiercarrion6843 2 сағат бұрын
This is an awesome video. I am trying to get my children into Databases which I work in the Oracle world and SQL also and it serves me well.
@Ajgabbana
@Ajgabbana 3 сағат бұрын
I'm at @9:41 but every time I right click and Click - Select Rows - Limit 1000 my SQL shuts down Does anyone know why this is happening and how I can fix this problem?
@user-kq3tc5tu1c
@user-kq3tc5tu1c 3 сағат бұрын
Can hardly wait for the 2024 update! Have been an "Alex The Analyst" fan for quite a while. VERY nice to have all of this valuable knowledge contained in a single playlist. Later 🙂
@user-kq3tc5tu1c
@user-kq3tc5tu1c 3 сағат бұрын
Wow... Too Cool! I don't know, the "Alex the Analyst Data Analysis Bootcamp" works for me 🙂 Thanks Alex. I'm in for the win. Cheers!
@_sweeteststarr
@_sweeteststarr 4 сағат бұрын
Legolas 😂😂
@XurshidbekQurbonboyev-xc3cn
@XurshidbekQurbonboyev-xc3cn 5 сағат бұрын
HI is there any PROMOCODE for courses on Analyst Builder ?
@user-kq3tc5tu1c
@user-kq3tc5tu1c 5 сағат бұрын
Great refresher on both LIMIT and ALIASING. For example, I don't think I've ever come across the whole "limit a certain number of rows" THEN "return the NEXT row" technique before. Wow, I knew I had a lot to learn and, in some cases, relearn... Good thing you have the Intermediate & Advanced lessons ready for me when I get there. Keep this up and you're going to get a Christmas card! Cheers
@rahulrajeev9763
@rahulrajeev9763 5 сағат бұрын
I'm getting exactly the double of the values as Alex gets. What will be the reason?
@user-kq3tc5tu1c
@user-kq3tc5tu1c 5 сағат бұрын
Short & concise. Just the relevant info. Thank you for working within my attention span!
@user-kq3tc5tu1c
@user-kq3tc5tu1c 5 сағат бұрын
Alex, this series on MySQL is really polished, no hiccups at all. Also appreciate your GitHub repository where I can also follow along with your SQL files. It's great to see SQL syntax that just works the way it is supposed to. I also appreciate the occasional "best practice" you share (i.e. Normally using proper column names in the GROUP BY clause vice column numbers, etc.) Working smart, not hard ALWAYS appeals to my brain. Thanks again for the awesome content! 😉
@user-kq3tc5tu1c
@user-kq3tc5tu1c 5 сағат бұрын
Alex, I appreciated the refresher regard the WHERE clause in MySQL. Good to be going over this info again. Getting the basics down solidly represents a firm foundation for future learning. Thanks again! 👍
@user-kq3tc5tu1c
@user-kq3tc5tu1c 5 сағат бұрын
Hello Alex, another excellent video in a VERY long line of fantastic content. Concise and focused content that worked on my laptop EXACTLY how it was depicted on the monitor. That's the way to teach effectively and you have discovered that "secret sauce" a long time ago. Thanks again! 😀
@user-kq3tc5tu1c
@user-kq3tc5tu1c 5 сағат бұрын
Greetings Alex! Been awhile since I last worked through some of your lessons. Discovered the "MySQL Basics Tutorial Series" about a month ago. Initially, while REALLY wanting to work through your training, I was having difficulty getting the most recent version of MySQL to operate at all on my macBook Pro. Ended up installing one version prior to the latest and greatest today and am looking forward to learning more about MySQL through your excellent KZbin content. As always, THANK-YOU for the work that you do. Cheers!😎
@preciouskadiri9506
@preciouskadiri9506 8 сағат бұрын
hello @alex please where can I download the data you using for each analysis? As I ought to practice alongside you
@adwaamohamed2674
@adwaamohamed2674 8 сағат бұрын
very useful
@bear76917
@bear76917 8 сағат бұрын
As a python beginner without any programming background, I watched a lot of videos on youtube and found them very hard to follow. This video is the best I've ever watched so far! Thanks!
@adwaamohamed2674
@adwaamohamed2674 11 сағат бұрын
thank you so much
@yanpaucon1043
@yanpaucon1043 12 сағат бұрын
Thank you so much, Alex. You are the Best
@truthgaming2296
@truthgaming2296 14 сағат бұрын
thank you alex, i love your explanation very much thank you XD
@mazharul661
@mazharul661 16 сағат бұрын
Done!
@user-zt9ki3nt8h
@user-zt9ki3nt8h 18 сағат бұрын
Please continue the series. its more helpful.
@ChristinePerez-ne6ew
@ChristinePerez-ne6ew 18 сағат бұрын
Starting today, May 12, 2024. I have an Accounting and Finance background but been wanting to shift careers. Today starts my journey to immerse myself in the Data Analytics field! Fingers crossed!
@lukanatsvlishvili7726
@lukanatsvlishvili7726 18 сағат бұрын
Alex, could u link another video for parsing of all items? Thank <3
@mayanktiwari6997
@mayanktiwari6997 20 сағат бұрын
How to add this project in Resume with bullet points? Kindly help
@universalashokcreations3910
@universalashokcreations3910 21 сағат бұрын
Please tell me anyone "deploy" Meaning in Telugu?
@TheStoicWay110
@TheStoicWay110 22 сағат бұрын
Amazing, Thank u so much Sir ALEX
@qurat_ul_ain495
@qurat_ul_ain495 23 сағат бұрын
i am getting error on "table.find_all('tr')"... error is AttributeError Traceback (most recent call last) <ipython-input-52-0649fb3740d8> in <cell line: 1>() ----> 1 table.find_all('tr') kindly suggest what to do... video 14:29
@samahmahdi5511
@samahmahdi5511 23 сағат бұрын
I like the video, thanks a lot, but I felt sad when you say that a 30-year-old is old😅
@zafar2073
@zafar2073 Күн бұрын
God bless you sir you are so generous to make this bootcamp free
@allah-swt
@allah-swt Күн бұрын
Is it possible to notify us via email whenever there is modification to this table?
@joysollars6976
@joysollars6976 Күн бұрын
another great sql walk through, thank you! btw if anyone was curious like me 361 rows had null percent and total laid off values🥲
@lillypop49
@lillypop49 Күн бұрын
New adhd hyper fixation 👍
@muhammadharis6229
@muhammadharis6229 Күн бұрын
The layoff dataset when downloaded only imports 564 records. This is an issue because it isn't showing any duplicates when I run the syntax, please help.
@Mimibabe43
@Mimibabe43 Күн бұрын
Please the link
@falahoudinesaid6973
@falahoudinesaid6973 Күн бұрын
hello Alex ? Thank you for the tutorial. One question please what about PDF file?
@makarsh29
@makarsh29 Күн бұрын
make VDOs on recursive query ...
@pip9601
@pip9601 Күн бұрын
at 15:19 i would like to say something. in the new version from jupyter, if u write the code from alex the data will be same. To fix this, u can input regex = True after the ''. CODE: df['Phone_Number'].str.replace('[^a-zA-Z0-9]', '', regex = True). But overall i can't say anything except thank u alex for this awesome tutorial !!!!
@redeemedforfire8510
@redeemedforfire8510 Күн бұрын
Hello, so at 28:28, I realized that it didn't actually mess with stuff, it just re-ordered it and a simple alphabetical reordering too the chat back to its former look. I checked the data and saw that there was no other change apart from the re-ordering.
@maxwelltsangya3810
@maxwelltsangya3810 Күн бұрын
Null Handling: 46:29 these are coming from the dates as it appears like on these dates, there were no layoffs, but same companies might have layed people off on other days.
@darshan2354
@darshan2354 Күн бұрын
Hey alex bro u r great
@deekshagautam5720
@deekshagautam5720 Күн бұрын
can i use another dataset