Thus was so awesome

Shout out to Transpose now a days

Thank you so much, I've watched countless videos. This is the first showing the actual work.

00:00 Learn how to transform SurveyMonkey data from wide to long format for better visualization. 05:55 Concatenate and collapse rows to simplify data in Excel 18:16 Naming files is important for data organization 23:44 Data columns are being dropped to improve performance 35:21 Python can clean and unpivot data easily 41:01 Manipulating data using Python and Pandas 52:24 Learn how to join data using left-hand, inner, and right-hand joins in SQL and R. 58:02 Aggregate data by counting unique respondent IDs. 1:11:34 Learned how to import, rename, unpivot, join, and aggregate data in pandas 1:17:09 Closing remarks

he is the reality in expectation vs reality

This was fantastic, thank you! A video of how to navigate with the ambiguity of stakeholders would be super helpful!!

This is hilarious 😂. You know panda so well and can't remember if it's a colon. That is why I want to be a data analyst.

hey, let me know one important thing... is it true that DA mostly work with Excel rather than Python? so if I learn Excel, Power BI, then am closer to a DA profile? and is Python optional? am talking based on statement of CodeBasics platform(founder & Co-Founder is >12Y experienced in US).

Dude…no… go back to school .. stop baiting jr devs … Da is not this, not DA that actually adds value

dataset_merged = pd.merge(left=dataset_melted, right=questions, how="left", left_on="Question + Subquestion", right_on="Question + Subquestion") print("Original Data", len(dataset_melted)) print("Merged Data", len(dataset_merged)) dataset_merged KeyError: 'Question + Subquestion' why am i getting key error here?

"Skillfully Underbid" is such valuble info for a beginner in any industry

Practical Statistics for Data Scientists, Do you prepare only chapter one or there's other chapters that you prepare? Continue the good work.

pwd actually means "print working directory" and it's a linux command. It would be redundant to have a present working directory and a current working directory. Also it's better practice to have all bare imports above your import as'.

Its Thursday !!

Доброе утро 🎉🎉 Вас смотреть и слушать очень интересно и приятно. Я ✍️ Ся, вы?

As a data analyst, all I do is CODE. But I love it! Interesting to see how my job functions align more with your description of Data Engineer.

Its crazy he was in excel but didnt use powerquery to transpose and unpivot

Taking notes 📝

one tip if you want to apply quotes on multiple phrases (on visual studio, not sure if code works too): - put each phrase into a line - hold alt and move mouse in vertical on the beginning of selection, you'll select multiple lines - press quote to quote the before the first letter, press end to move to end of all lines and quote again to quote past the last letter.

Honestly the work seems super boring to me 😭😂 But thanks for the realistic video

Thank you for this vidoe man!

Been going through a lot of data analyst videos and channels for over a year now. And I saw this video TODAY, why KZbin was hiding it from me. This is exactly the type of content I want on my feed.

This is the best video Ive ever come up with so far. No faking ❤

Dope video. Learned a lot about your method to problem solving.

I'm deeply grateful for this. Let me get a db to follow along with step by step, hands-on. Can I do it on Rstudio or I will miss out at some point?

What laptop specifications do you recommend for Windows and/or Mac for working with data analysis?

Thank you man, Keep it up.

Where's chapter 1? Or don't I have to go over chapter 1?

This was really helpful, thanks.

why do you use excel instead of SQL ?

You are good but very fast explaination

pure Gold. Keep going sir

hay guys .. i want some suggesion ...i have no clue to data analysis... but i'm good in basic python and i know excel as well... still i understool what he is doing... is it a good sign for me to choose data analysis over app development... because i'm equally interested in both feild....

great work!! I want to do freelance work and tasks like these. How can I get clients??

Hey I am watching this the next day I watched 'Ricky Stinicky' movie and when you explained 'join' with your two hands as circles, it reminded me of the scene from the movie about their boss doing 'the' imitation. Also covering essentials under 1 hr is hard while providing everything is so cool!

what a waste of 45 minutes

you know kanban in japanese is board so you are saying board board right

PLEASE, here is the link for the CHAPITRE 1 ?? Thank you

I’m sorry but i swear you could have done this pretty easily in excel, minus the melt

thank you!

thank you!

Amazing , very useful , i am learning alot from your videos.❤

Are you allowed to reference? I just learned this today and knew the answer that I have to sort and set ascending to false but the syntax was not in my head staright away

Finally a fucking real video !!!!!! Thank you !

🎯 Key Takeaways for quick navigation: 00:00 *Data Transformation Basics* 05:42 *Excel Preprocessing Tips* 17:09 *Importance of Organization* Easy directory management Importing and handling data Dropping unnecessary columns 45:58 *File Not Found* 46:13 *Drop Unneeded Columns* 49:02 *Remove NaN Values* 51:47 *Data Set Merge* 54:01 *Check Data Integrity* 55:42 *Aggregate Data by Question* 57:31 *Group Data for Aggregation* 01:06:20 *Count Same Answers* 01:10:16 *Fill NaN with Zero* 01:10:47 *Rename Columns* 01:12:09 *Assign Output Names* 01:13:05 *Coding Style Choices* 01:13:49 *Export to Excel* 01:15:06 *Recap of Techniques* Made with HARPA AI

“SQL it up for me” 😂😂

Excellent video, just one suggestion don’t keep repeating yourself. Also don’t explain preliminary things and spend so much time on it.

OMG! What amazing content! Please, we need more of this real work content!

This was an excellent day in the life of 10/10

Please re upload for High quality video