Please upload complete playlist of python ( Numpy ,pandas , matplatlib),,,as we are eagerly waiting for it...your teaching is so heart touching that we feel like our brother is teaching to us.....please we need this complete playlist...
Thanks for such kind words. Unfortunately, I don't use a lot of Python in my day-to-day life. So, creating a playlist or series is not possible at this time. But I will certainly keep this request in mind and as I learn and expand my knowledge, I will add such videos.
watching Chandoo's you realize that it's not a matter of easy or difficult programming languages but good or bad video tutorials, thank you sir for making things easier for the lot of us
Hi Chandoo! I was following the video along the way and I notices that when we drop NaN at the end of our code we also do drop some records that we not necessarily want to drop. Some records lack company and when using the df.dropna() without specifying the method parameter we get 'any'. Getting any means also such records get dropped - not only those we wanted to get rid of. Nevertheless, THANK YOU so much for all you've been doing. I finally sat down to learn Python properly. You are one of my first go-to sources for data analysis work!
There is no place for even the minutest amount of dirt in our hearts. Alexandre Dumas once said that it is difficult to understand others, but the most difficult thing is to understand yourself. Never allow yourself to fall into any trap. Never allow the least karmic obstacle to take form, nor harbour any unwholesome thoughts in your mind.
Thanks for the suggestion Haresh. I spend less than 5% of time doing coding work. As of now, I plan to add 1-2 videos on coding / automation every 2 months. If I end up doing more coding work, I will certainly share more topics.
I'm still starting with Python, so this was a bit confusing for me. But I decided to replicate what you did using Power Query and I am so proud of myself 😁because it was my first time using a conditional column. After transforming the data on Power Query, I created a dashboard. Thank you Chandoo you have been so much help in my journey to data and analytics🤗.
Hello sir, thanks for this powerful video. I have been following you since past 2 years and your videos helped me alot in this.. I'm want to trasition my career into data analyst. Can yoh please give me some information about the career opportunity for data analyst or business analyst in new zealand or any other foreign countries
Thank you for this video. Looking at data I first thought that data below headers that had NAs next to it in other columns, is below so you'd have do use fill down. I think it makes sense to understand the structure first and then make structural changes. Also want to commend your fast learning in this area. Did you also try using M code to come up to desired solution? Thank you for posting
I read a few chapters of it on eBook version a while ago. But doing a real-world problem solving (as shown in this video) is what helped me really appreciate and understand Pandas better.
Chandoo, I think Power Query is powerful and easy in many aspects of our common tasks in Python data analysis. What do you think? Without Python, data analysis would be no problem.
Totally agree. Power Query is my goto for tasks like this (followed by formulas in Excel). But if I am building a learning model or application where everything happens in code, then Pandas becomes essential.
I had a similar problem at work the other day. Are you seeing any specific errors? I suggest either using pip or anaconda to get all packages in one go.
Hi.. excellent video as always.. anyway, i remember at one point u mentioned that u were involved in HRM data analytics for the NZ Govt.. coincidentally, im applying for data analytics position which will look into HRDM data for our state.. any videos on that particular case? What would be your advice for someone applying for this job?
I do have courses for that. It is tricky to maintain series thru YT. If you want to learn Excel step-by-step in one place, do check out chandoo.org/wp/excel-school-program/
Please upload complete playlist of python ( Numpy ,pandas , matplatlib),,,as we are eagerly waiting for it...your teaching is so heart touching that we feel like our brother is teaching to us.....please we need this complete playlist...
True.
Thanks for such kind words. Unfortunately, I don't use a lot of Python in my day-to-day life. So, creating a playlist or series is not possible at this time. But I will certainly keep this request in mind and as I learn and expand my knowledge, I will add such videos.
Yes exactly ..It's need of the hour for BI analysts.
Please make a complete data analysis python video as it is the most extensively used tool.
Yes sir we need it desperately..
watching Chandoo's you realize that it's not a matter of easy or difficult programming languages but good or bad video tutorials, thank you sir for making things easier for the lot of us
This guy is one of the best on youtube for educating. 'Champion Chandoo' I call him. This is helping my life move forward with a better job (I hope?)
Python is executed line by line and you're explaining line by line very clearly... Love from Texas.
Awesome, thank you!
Seriously, Leila and Chandoo, these 2 legends changed the way I think and use data in excel. You helped me crack a new job even. Thank you so much!
Thanks Soumadip for such lovely words. Leila is an inspirational teacher.
Hi Chandoo! I was following the video along the way and I notices that when we drop NaN at the end of our code we also do drop some records that we not necessarily want to drop. Some records lack company and when using the df.dropna() without specifying the method parameter we get 'any'. Getting any means also such records get dropped - not only those we wanted to get rid of.
Nevertheless, THANK YOU so much for all you've been doing. I finally sat down to learn Python properly. You are one of my first go-to sources for data analysis work!
Hi Chandoo, I'd just want to say that you're doing a great job sir! Keep going!
Who are you?!?!....Probably mind reader. Was about get started with pandas and you upload this. Real saviour...cannot thank you enough
df.readmind()
Lol 😂 manchi reply@@chandoo_
This tutorial is a masterpiece. Thank you Chandoo!
You're very welcome!
This is cool and awesome !! Please share more videos on pandas like joins and automations !!
There is no place for even the minutest
amount of dirt in our hearts.
Alexandre Dumas once said that it is
difficult to understand others, but the most
difficult thing is to understand yourself.
Never allow yourself to fall into any trap.
Never allow the least karmic obstacle
to take form, nor harbour any unwholesome
thoughts in your mind.
Chandoo plz make a complete video list for data analysis using python especially libraries
Thanks for the suggestion Haresh. I spend less than 5% of time doing coding work. As of now, I plan to add 1-2 videos on coding / automation every 2 months. If I end up doing more coding work, I will certainly share more topics.
Good video working with weird data and dates! Real-life issues.
Looking forward to taking notes from this video. Thank you Chandoo.
Awesome to hear that Nomahlubi.
I'm still starting with Python, so this was a bit confusing for me. But I decided to replicate what you did using Power Query and I am so proud of myself 😁because it was my first time using a conditional column. After transforming the data on Power Query, I created a dashboard. Thank you Chandoo you have been so much help in my journey to data and analytics🤗.
😂😂😂 The part of the video for one moment I thought I was at a wrong place
Thank you so much for starting videos on Pandas😀
My pleasure Sagar.
Actually looking to solve this same scenario. Good stuff
Glad to hear that.
Hello sir, thanks for this powerful video. I have been following you since past 2 years and your videos helped me alot in this.. I'm want to trasition my career into data analyst. Can yoh please give me some information about the career opportunity for data analyst or business analyst in new zealand or any other foreign countries
You are welcome, Nafish. I am not an expert in job hunting or anything. So can't really talk about this.
Great intro, thanks
It took me 15 weeks to finally complete this 15 minute video. I'm crying
Congratulations. The first few steps are always hard. It took me almost 40 years to write my first lines of Python code.
Thank you for this video. Looking at data I first thought that data below headers that had NAs next to it in other columns, is below so you'd have do use fill down. I think it makes sense to understand the structure first and then make structural changes. Also want to commend your fast learning in this area. Did you also try using M code to come up to desired solution? Thank you for posting
Nice Job ! Keep it up
Please upload video for all the mathematical concepts which is necessary for data analytics and science
Thank you, Chandoo
Please make a full course on data analysis
I started to read the book of data analysis for python from Wes McKinney, is really good and covers a lot of basic python stuff.
I read a few chapters of it on eBook version a while ago. But doing a real-world problem solving (as shown in this video) is what helped me really appreciate and understand Pandas better.
Please post a complete or detailed tutorial on data analysis with python...
Very helpful
Why we don't use power bi or excel in this situation kindly tell me please 😢😢😢
Chandoo, I think Power Query is powerful and easy in many aspects of our common tasks in Python data analysis. What do you think? Without Python, data analysis would be no problem.
Totally agree. Power Query is my goto for tasks like this (followed by formulas in Excel). But if I am building a learning model or application where everything happens in code, then Pandas becomes essential.
sir plz bring more videos on tips & trick in numpy and pandas ......
Thanks Gaurav.
Is panda better than Excel? Or can panda replace excel?
please give me a training session on the numpy ?
Nice video sir🙌🏻
By the way, will Machine learning also be used in future from Data analysts or not sir??
You are welcome, Suhail. ML and AI are already widely used in data analysis.
I've ben trying ro go through this tutorial using PyCharm and somehow Pandas won't install at all like it used to in the past.
I had a similar problem at work the other day. Are you seeing any specific errors?
I suggest either using pip or anaconda to get all packages in one go.
@@chandoo_ Just failure to install errors; I ended up using pip instead
Awesome
😎😎😎
why you so funny sir? i cant stop laughing at your first scene in every videos
Hi.. excellent video as always.. anyway, i remember at one point u mentioned that u were involved in HRM data analytics for the NZ Govt.. coincidentally, im applying for data analytics position which will look into HRDM data for our state.. any videos on that particular case? What would be your advice for someone applying for this job?
I do have a playlist of HR data analysis. Check it out - ruclips.net/video/nqYUmGZMnU0/видео.html
@@chandoo_ please take data analyst test of relevel and put a feedback if it's tough or not.i couldn't crack that.its employment test by unacademy
The only favourite if I have to learn something new my youtube land me here always ........
😊😊😊
Let me see all about it.
Is there any reason for a Power BI user to learn Pandas?
Depends. You can use Python from Power BI to do both ETL and visuals. Plus learning new things is fun and exciting for our minds.
Nice chadooo. Great effort please do video on seaborne @ matplotlib
Sir, Can you do videos for data science students?
As I solve such problems, I will share my knowledge with all. So far, I do very little DS work.
Share dataset also for practice purpose
Refer to the video description for the link to dataset
wanna learn complete series like trumpexcel
I do have courses for that. It is tricky to maintain series thru YT. If you want to learn Excel step-by-step in one place, do check out chandoo.org/wp/excel-school-program/
😍