concat & concatinate are the same when they update the version they introduced concate and left concatinate for old version users so the can use it, in older versions of excel you won't find concat.

Taught really well . Thank you so much . Are these notes available ?

do you know deep learning as well? can you make videos on it.

Amazing.

great , I'm learning machine learning from you for my university exam , and my semester for machine learning just ended , thankyou so much , you saved me . i watched your videos a day before my exams and i got fairly decent marks in this subject . 😂😂😂😂 . again thanks alot

I'm learning Python but for now I would use Excel Power Query. It seems that it would be faster. What am I missing?

really helpful . thank you! keep making these videos , helped me in doing my assignment

thanks for this. where can I find chapter 11?

Excellent. Thank you for sharing. I would recommend adding few minutes on the Last section of chapter 2: Launch, monitor, and maintain.

Man, your videos are really helpful. Thank you very much, I am so lucky that I found your channel. Cheers

in short, ur God send I the Data Science, Data Analysis, Data Engineering & Big data World

This is an amazing, thought-provoking video. Thank you @Shashank Kalanithi

Thanks for sharing.

thanks For your Present

Providence is basically the only city in RI…lol. Lots of small cities and towns. And then there is Block Island, which is the best kept secret on the east coast.

Im very new to python and this has been very enlightning! I have a question though. what is the difference between pop and drop?

Is Shashank available? Hey man, we miss your content, are you okay? Come back, give us more.

This is indeed an amazing job brother. I have learnt solidly. Thanks a lot.

2:44 😂😂😂

this is awesome!! subscribed!!!

Great presentation ❤ Just a friendly suggestions...can you please zoom at bit so that we can see more clearly

Why are you making predictions on train_data? Isn’t that should be on test_data??

I just got hired as a trainee data analyst and was looking for information on where I could go moving forwards but everyone else just felt “I’m selling you a course” type vibes. You however were very honest and helpful. Hopefully when I’m more skilled I’ll be able to capitalise on this. Thanks for the video.

mutha fucking g move

Lovely video man! As a financial analyst i always had a problem with melting down data and its good to know i can do this if i just learn python.

Great work, very detailed for a 50 minute tutorial

Assalam O Alikuim . i want to do my university paper exam , but i don't understand that which things are coming in paper. sir told us he never ask to write the codes in paper . can you help me ?

Hi, Could you rewrite the function of this section 9:23 ? Because I couldn't see clear :D

19:05 pd.read_csv

i have been using the internet for 9 years, but this is the first time I have seen someone demonstrate how data analysis works.

your data manipulation skills are top notch 🔥

This just seems like boring grunt work. I'd rather use command line and powershell as a sys admin.

Are these considered entry level questions?

1:11:11

Wow, glad I found these videos on Hands on Machine Learning! Thanks for this great content!

Man, i just loved the entire video. I'm currently in middle of a career dilemma and don't know what to do with my life and the clock is ticking. Thinking about start my life with something into Electronics and coding or Data Analyst. But I have no skills at all be it anything. Getting a job is the one big step that can change my life. So I leaned towards Data Analyst hence I wanted to see what actual data analyst do irl. Couldn't find any useful until I found this video. Now I know that this career ain't boring for me and I will definitely prepare for it from now on. I wish I could contribute in your patreon page because of the effort you put and made everything simple in this real-life project, but I am broke right now. I will definitely come back in future (I hope and I wish) and pay my regards. Thanks Man.

Straight and realistic. That's what data analyst or data scientist actually do.

I don’t think power query was available when you created this. Power query will transpose the complete data set. It will simplify cleaning g and refining the data

Taking up with your nose during lessons is disgusting and unprofessional. Btw good lesson

I'm not heavily into Data Analytics, but this was super informative. Thanks for the brain candy man!

A very crisp and helpful video . Thank you Shashank!

This was a very interesting video to watch. I am not new to data, I finished the Google data analytics programme some months ago. However, I don't know how to use Python to resolve data problems yet. I would have loved if a tutorial like this solely done in Excel was available. Overall this is very good stuff. I don't think you need to do any fancy editing just natural like this is okay, is all we really need. We want to see you stutter and hear your thoughts process as you work. I made sure to support by watching all the ads. Many thanks Sir.

I dont understand your raw data. Whats the questions and responses ? Are responses the answers to questions ? Confused

I recommend using Power Query to do this instead. Power Query used to be called Get and Transform, and it's made for transforming data. Once you finish, you will have a query that you can reuse with no manual work whatsoever required.

good job bro

You can install the TABNINE extension to code faster. It helps a lot.

1:18:53 maybe because you tested on the train dataset

I would love to go into data science, but it looks like something AI could do in a snap. I'm worried about spending so much time learning it.

gender you identify as .. this is where i turned the video off

please make more of this.