Want to become a Data Analyst like me? Check out my FULL ROADMAP to Data Analytics: kzread.info/dash/bejne/X3WWo89tpJesibQ.html

@ShahzadHassanBangash

Жыл бұрын

Hi Shashank please make more, its been a year now and we want more videos of data cleaning and transformation in this series

@somilgupta2408

Жыл бұрын

Please increase the font size in the videos you make from now on

@moonkhokhar471

Жыл бұрын

Can you please share the link of the excel file for this data if possible?

@businessfunda7504

Жыл бұрын

Bro do you have any course ?

@willy7968

11 ай бұрын

15:10 I dont understand what u did there

Finally, actual real work and not just "i go get food! now im drinking coffee."

@ShashankData

3 жыл бұрын

I’m glad you like it Yui! I hope you like my other videos too

@christopherlegarda5164

3 жыл бұрын

Lol!!

@shubhamekbote1628

3 жыл бұрын

Absolutely right... I was about to say that..

@glazed606

3 жыл бұрын

Hahahahaa

@onetime9012

3 жыл бұрын

Exactly!

Just stumbled upon your vid, and THIS is what I am looking for in a "Day in the Life of", not a food tour and fancy office spaces. Thank you very much, you've got yourself a sub. Please keep up content of this nature, it will be very well received!

@ShashankData

3 жыл бұрын

Of course laalaa! That’s exactly what I was going for . New video coming out at Sunday 12 MDT.

@laalaajonsen

3 жыл бұрын

@@ShashankData You're doing it real well my friend. Ill check it out asap!

@laalaajonsen

3 жыл бұрын

@Duncan Marshall Yeah man. A day in the life of a X should entail the actual work. Really bugs me that there is so scarce material on actual work tasks in the DA/DS fields. Of course I know it might be hard to share specific use cases. But come on, its like they only wanna flex their company perks... something real eager learners gives 0 shits about.

@laalaajonsen

3 жыл бұрын

@Duncan Marshall Yeah who knows why... but i appreciate people such as Shashank working against that!

@ShashankData

3 жыл бұрын

Thanks for the support guys! In addition to these videos I’m also putting out a series on my journey to learn machine learning along with snippets and code I make through the process. A true day in the life of a Data Analyst!

You have my respect, finally someone who showed the real thing. This helps people understand that a vlog with a cafe and a cute keyboard is something for those who are crazy to become a youtuber and can't stand all the good and bad of the profession. Go with everything, congratulations, hugs from Brazil!

@ryuzaki6977

Жыл бұрын

Wi

@Flylikea

8 ай бұрын

Or, 8 minute videos are just 8 minute videos showing a very tiny part of the process (and even the creators put a lot of real work behind cameras just for 8 mins).

Your the first person I’ve seen that actually shows the process of your day instead of your lunch breaks! We thank you!

I work as a Data Scientist at one of the big banks and this popped up in my feed and had some time to kill on a Friday and man this video is on point. Great work, we need more people like you!!

@ShashankData

3 жыл бұрын

Thanks Dave! Just checked out your KZread channel and subbed!

@DaveLotito

3 жыл бұрын

@@ShashankData mutual. Great stuff man, looking forward to more.

@matt3441

3 жыл бұрын

Maybe you guys should collab on a data engineering + data analysis tutorial :0

@dankrupt2937

3 жыл бұрын

lol same killing time on Friday

@jeevan999able

3 жыл бұрын

What does a data engineer do

im not even a data analyst but this video was insanely fascinating and informative. you're doing great work, excited for all the future data analysts you guide and inspire with such quality content

This is what I was looking for, end to end real live analysis. I really liked the way you explained each and every minute detail without any assumption. Looking forward to more such videos. Kudos to you Shashank!

That was a great tutorial, teaching seems to come naturally to you. Keep up the good work!

I never thought in my life that I would enjoy a video like this so much. You're great at explaining your process in a way that I can see and understand. Thank you!!!

It makes me incredibly happy to see what you ACTUALLY do in the job versus a "I'm a data analysis and this is everything that I do, except the actual data analysis" video. I have questioned myself over if I'm capable of joining this career field, but seeing what it really is gives me allot of reassurance that I'm not in way over my head. Sincerely, thank you

i like how you include your mistakes or told how some of the things you don't know. Loved how real the video was. Total worth watching this rather than just tutorials.

This is unreal that you presented everything in a tremendous way without fluff. I was totally expecting a cell phone alarm going off and you waking up and drinking coffee. Great video and your time to do this is much appreciated.

wait.. why did I just watched every minute of this instead of working on my school projects? Wow man you are so good! I didnt even blink.

Yes!! I love how i literally see how all I'm learning in my data analytics course is being applied. Thank you so much for this video. 🙏🙏🙏

As a DA myself, knowing most of it, I am 32 minutes in and still watching because you are so good at explaining. Fun to watch!

@raymueni5484

Жыл бұрын

💯 I like how he carries you along as he works... I'm getting to see DA in action. Pretty cool

@Quastillo

11 ай бұрын

i know nothing i watched 28min straight

@dontbotherme9009

9 ай бұрын

waste of time

@mr.bhewjew3212

5 ай бұрын

District attorney!

This is great! I actually spent my Saturday evening watching this. Thoroughly enjoyed the video.

@lil.hercules

3 жыл бұрын

same here, worth investing time on such videos

This is amazing content, Shashank! I love how practical and realistic it is. Really helps aspiring DAs understand what the work is truly like. Gonna be sharing this widely - tons of folks in my community are looking for this exact thing!

@ShashankData

3 жыл бұрын

Thanks so much Varun! Anything to help and inform people who might be looking!

There is positive light in see in your tutorials. Amazing Shashank, really want to see more videos like this. Thanks

This is real, easy to follow and such a gem amongst all other "9AM-its-coffee-time" video. Please continue making them you're such a great teacher too.

Out of the tons of tutorials I've watched, I'd say this is one of the most instructive. Great job! Thanks!!

@jonnathansanchez7004

2 жыл бұрын

Facts ,

@shichilaofa

2 жыл бұрын

Pup?

Hey Shashank, I just wanted to take the time to thank you for this amazing tutorial. I’m currently working on doing some analysis for a a Survey Monkey export myself and although I’m a pretty advanced Excel user and a beginner with Python and Pandas, I must appreciate the detail and explanation you provided with respect to transforming the data in Excel. Your tips and guidance towards a step-by-step methodical approach to prepare the data before importing it into pandas and taking the time how you show how to transpose the headers and merge them, how to preserve the source data by making copies before editing, pitfalls to avoid, and everything else you showed is priceless and truly appreciated by someone whose going through the same/similar process. Hats off to you, sir for putting this out there. This tutorial is just friggin’ awesome. Keep up the great work and I look forward to all your other tutorials.

I just randomly watching this video at 1 A.M eventhough having zero idea how I would use this skill, but stick till the end because I was fascinated with how detailed and easy to undertand your explanation was. Loved the video

This was super helpful and great to watch; an ACTUAL "Day in the life" video. Thanks man!

I loved the troubleshooting process through this. It's so refreshing seeing somebody who's talented actually work through issues that might arise like the n/a issue. Rather than seeing a scripted tutorial that just blasts through every problem that comes up.

@ShashankData

3 жыл бұрын

Thank you! I try my best to show you the real process I go through in solving these issues.

Thank you. I learned those codes with absolutely no clues on how it would be use in real life projects. Now it makes so much sense. Keep on great work!

@ShashankData

3 жыл бұрын

Thank you so much Thu! Feel free to check out my other videos too :)

Hey man, just wanted to say thank you for the great content! This is exactly what I needed to see, day to day work tasks and an honest picture of what the job could be like.

By far the best tutorial for data analysts. I now work as a data analyst and this framework is essentially what I do everyday for cleaning datasets, just with some minor tweaks. Honestly props to Shashank for creating such a great tutorial that encapsulates what a Data Analyst does.

Learning the transpose paste option in the first 15 minutes of the video has already blown my mind. Thank you so much for doing this.

@ammridda

2 жыл бұрын

right? like that part alone just changed my life lol

Hi Shashank, I really appreciate you for creating something so meaningful! I have searched for a lot of day in the Life of a Data Analyst videos but have never got a chance to find something like yours. It really gave me a lot of insights. I'm looking forward to much more of different kinds of analysis and viz tips from you!

@ShashankData

3 жыл бұрын

Thank you Chandhana! Comments like this inspire me to keep posting

@nidhi12mishra

3 жыл бұрын

@@ShashankData Thanks lot for the video! Can you do the analysis part of this data set as well. this is more of data cleaning I believe..!

@archies23

2 жыл бұрын

@@ShashankData Hi Shashank, its great to see videos like this where a beginner like me knows how to approach work and be skilled rather than entering with no clue. Thank you. Please post more videos like this. Now I have the confidence that I can do something well though its a long way! Eagerly waiting for your next video

this is amazing bro, I've learned more from here about actually working with data than all the fancy tutorials i've been watching. Thanks man.

I love this! I'm a post-doc researcher and have been looking at data science/data analyst jobs, this is such a good insight 😀

This is exactly what I want to see. I'm changing career into D.A and videos like this helps a bunch. Thank you!

@ShashankData

3 жыл бұрын

Glad it was helpful! I'll continue to make videos like this!

@109968shadowboy

3 жыл бұрын

I agree, this allows me to see how to get or manage data in tables. I’ve waited a ton of videos on feature engineering but I’m still unsure how to even do it in real life.

@mahirrain466

3 жыл бұрын

What was your before carreer..?

@manojkumar-jt3fw

3 жыл бұрын

@@ShashankData sir,I am from arts background.I want to become a data analyst.Can u plese tel me from where should I begin with

@marcfiliuta

3 жыл бұрын

Hello there! I am changing career path too; started Google Data Analysis certificate three weeks ago! I still feel so unprepared though... keep it up! Good luck

Great video, I enjoyed how you took a moment to describe literally everything you did. As miniscule as telling the viewer how can they understand different columns from the python output. Most developers, programmers and data analyst would perhaps forget to mention it, but you are pretty resiliant at making sure the viewing experience is easily digestible, no matter what background the viewer might belong to. Great job, can't wait to watch more of your videos 👍👍👍

This was amazing, keep on uploading in this format. Comes across very easy to follow and natural. Thank you.

Love this!! Exactly what i was looking for - please go over more of your projects!!

This video is amazing. I hope you can post more. It's very practical and I picked up a lot just by watching a snapshot of what you do in real life. Thank you for sharing.

@ShashankData

3 жыл бұрын

Thanks T Socks that means a lot. I'm trying to get another one out on a geospatial analysis that I did.

Im in the middle of my "mid-life crisis" and thinking of switching to data analyst career. you have made it so much easier to understand the job and what you are doing on a daily basis! Please continue making more of such series so we can learn more from you!

@carlosmspk

2 жыл бұрын

Just an heads up, this is far from being the bulk of what data analysts do. There are, imo, 5 main things data analysts need to do: 1 - identify data they need to study for a given problem 2 - collect this data, through polls, for instance 3 - clean the data 4 - analyze it (i.e. take the "raw" results and produce statistics) 5 - interpret it to get to any useful conclusion (or else they're just numbers) In this video he pretty much focused on point 2 (excluding the actual form) and 3, while barely scratching point 4, and did nothing for points 1 and 5. Most data analysts spend their fair share of time in points 4 and 5, perhaps point 1. I think this "job" was more of a side hustle than an actual job at a company or something.

@vonnpowell3844

2 жыл бұрын

@@carlosmspk thanks for the breakdown. I was thinking of switching my career as well. Any suggestions. I’m also watching Cisco and Simplilearn vid and free courses.

@carlosmspk

2 жыл бұрын

@@vonnpowell3844 I'll watch these and come back to you!

@MissTopDJ007

2 жыл бұрын

@@carlosmspk What's your recommendation? I'm thinking about switching my career as well to Data Analyst to a company. Which industry do you recommend?

@EatMyShortsAU

2 жыл бұрын

Nice I had a mini one in my mid 30's now I am Research Analyst but I work with Data Analyst and this is what they do.

Starting out my data science journey and this is the content I need! This is so good. Keep reppin' the community!

Found you on tiktok and your day in the life is actually amazing, I feel like tech jobs and their companies are over glamorized and there’s a lot of content that shows someone living in luxury, grabbing a cup of of coffee casually and then going home, when in reality that’s not at all the truth. The fancy offices and stuff comes with it but they never really show their actual job and what they actually get done and this is refreshing, so thank you! - a future data analyst

In the early transformation of your raw data in excel around the 11min mark, you could select the range holding blank cells you want to do the filling, use the “go to special” and select blanks, excel will highlight all the blanks cell, while it’s being selected you just have to type in “=“ then choose the cell above and press “ctrl + enter”, excel will auto fill the column. The steps above can be done with excel power query as well

@filda2005

3 жыл бұрын

power query can aplly fill-down!

every tech career should make “one day of...” like him.

@mxbx307

2 жыл бұрын

I'll give you "Day in the life of cybersecurity", which is me trying desperately not to kill myself before the clock hits 5pm or so.

@AcidLightning

2 жыл бұрын

@@mxbx307 Would you mind going into a little more detail? I was thinking of getting into cybersecurity, but I've heard others echo your same sentiment. What's so bad about it? I thought it would be fun to learn tech and help catch bad guys.

What a wonderful presentation. Very methodical and real. Extremely helpful! Hope you continue to produce content like this in the furture.

It is really good learning to watch you do project like this. I really like that you show when you do something wrong, you think and try out things. And best of all , you explain everything in a very good way! Thanks for helping me learn from you

This is perfect, make more tutorials like this on different projects really helpful

@ShashankData

3 жыл бұрын

Will do!

This is one of the greatest tutorial videos I've ever seen. It was awesome watching another data analyst work, as I don't really see myself as a data analyst despite doing very similar things as this on the daily (sans python). I've been kind of siloed in my current position and haven't really had a barometer to compare my work to. I learned so much watching this video and now I want to dive into coding.

REALLY solid explanations. The way you "think out loud" and explain things is really helpful. Keep up the good work.

Great video. As someone starting out in Data analysis it’s cool to see someone work through a problem. Keep it up man.

You sir are a fine human being. This perspective is great for someone who is learning individual tools but doesn't have experience using them collectively. Thank you for this channel.

@ShashankData

3 жыл бұрын

Thank you Luis! I'm glad you liked it

@maybenew7293

2 жыл бұрын

sir

You'd make a great mentor dawg. Thorough explanation without sounding condescending or overly technical. More likes deserved for this video.

@fb079

Жыл бұрын

I watch his video and I feel like I'm getting a apprenticeship and being mentored.

Amazing video! This makes it so much easier to picture what DA tools are actually used to in a real world scenario. Thank you

Thanks for the video, you do an excellent job explaining your thought process through out it, can't wait to see more.

fantastic video Everybody wants to be financially independent and live a better life. With savvy investing, an inexpensive lifestyle, and diligent budgeting, this is not difficult to do. I'm glad I realised early on that achieving financial freedom requires hard work.

@charlotteflair1043

Жыл бұрын

@@marcelrobert9569 Would you mind recommending a specialist with a variety of investment options? This is extremely rare, and I eagerly await your response.

@sagram0re814

4 ай бұрын

Reporting all of y'all

This is genuinely some quality content. As a data analyst myself, who is just starting out in the industry, it's really helpful to learn the best practices and tips that you shared as a part of this video. Looking forward to more of this. Cheers!!

@ShashankData

3 жыл бұрын

Thank you Ankit! You should share some of your insights as well. We're all learning here :)

@danielgarrison7463

2 жыл бұрын

Do you have any tips for getting into data analyst industry? I'm looking for data analyst internships :)

@tusharsharma8952

11 ай бұрын

@@danielgarrison7463 learn python and start with basic projects that you can find online. Pyhton is a must, sql in later stages is an add on.

Good content. You are excellent at explaining not only what you are doing in the moment, but how and why. Subbed

Great video, this is what exactly I was looking for! Please do more like this. Thank you.

Fantastic video sir! I am just starting out in the field of data analysis, still working primarily in spreadsheets. It was enlightening to sit over your shoulder, watch how you manipulate data, while listening to you explain what you are doing and why. I'm at least 100 steps away from being at this level, but this really helped open my eyes to what a future job in the industry could look like. Thank you for taking the time to create helpful content.

@maybenew7293

2 жыл бұрын

sir

That was a good watch, I didn't even realise it was an hour long clip!

Really appreciated this video; thanks for taking the time to share this.

Hope to see more of this kind of video. I really enjoy the video and buddy, great work!!!

This is really awesome! The algorithm suggested a video on the google data analysis course to me a few weeks ago so I be been researching whether for not I should take it and I’ve been confused as to what the job actually entails but watching your video gives me clarity and honestly this is really satisfying work and I’m very motivated to start the course and start doing projects!!!

Hey guys. If you're looking for an Excel version of this tutorial then check out Василь Салик's channel here: kzread.info/dash/bejne/jGd9yMNsZ9e-kc4.html He does this entire transformation using PowerQuery. Thank you so much Василь! This is the type of supportive analytics community we want to build!

@aadarshbhalerao8507

3 жыл бұрын

Hey Shashank if you could start a series of Pandas tutorials, that would be very helpful. Considering all the tutorials out on KZread they just happen to each the basic steps. I know it's a big ask, but it would certainly be very helpful.

@numidian5406

3 жыл бұрын

I was going to say the same thing, not real much coding is needed for power query and you can do what you did even quicker.

@MrEldanielo

2 жыл бұрын

good job bro!

@SuperBliip

2 жыл бұрын

For the transpose formula thing around 15 minutes in, just go into the paste special dialogue, tick values and transpose :)

@fattyboyblue

2 жыл бұрын

Very cool to see this done with code! I was thinking most of this could be taken care of in excel, but the melt method you used in Pandas came in clutch.

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

This is so brilliantly helpful. Thank you! You have a great voice too, very clear! 😀

THANK YOU! I’ve been self learning data analysis skills such as Python, but I felt like I was lacking an understanding of real world implementation; how real data analysts apply these skills in the real world. This video has reignited my motivation to continue pursuing this career. You explain things the same way I think, so you held my interest throughout the video. I will subscribe and watch all of your other data analysis videos.

@ShashankData

2 жыл бұрын

Thank you so much Samantha! I have a ton of free tutorials in everything from Python to SQL to my newest one in Excel. I hope you find them useful!

@debanjandutta2235

Жыл бұрын

I'm on the same journey as yours 🙏 keep learning

@Pale4u

Жыл бұрын

@@debanjandutta2235 thanks, you too! I actually did it! I’m 3 weeks into a data analyst job and I love it!

@aruljoseph5162

Жыл бұрын

Hey samanth, im into journey of pursuing a data analayst job. Currently working as a data associate in amazon. Can u share what sort of certification or projects helped u to get into ur job?

@Pale4u

Жыл бұрын

@@aruljoseph5162 I really started simple and got lucky with a company that saw my potential in place of a lot of established experience. I studied CS in college 10 years ago so I have programming knowledge, but in terms of other certifications I’ve only done the advanced Excel certification on LinkedIn. On my resume and cover letter I emphasized my skills in SQL and my thought process. They gave me a company-specific project to do and present to them a week later. At my job I use SQL and Tableau the most. I’m new to Tableau but picking it up really fast and I like it. I’ll probably get a Tableau certification next. I’d advise you to decide which tools and types of analytics you like to do most, get really good at them, and look for jobs that specifically need those skills.

Currently in a Masters program for Marketing Analytics and it helps SO much to see what I've learned being applied in a real world setting. It gets difficult to understand the purpose and what things do when it's all in a textbook setting. Thank you for sharing!! This excites me even more to become a Data Analyst!

Great video! Thoroughly explaining everything and showing some of the real work that data science entails, thank you.

Its super helpful just to hear the thought process behind your work, thanks for making this!

Hi Shashank, I'm almost a fresh graduate in Data Analysis, so great to see someone who can really show what it is actually like to be one! I really appreciate this and also I've subscribed. Can't wait for more videos. :)

As someone who is considering going back to school for an MBA in Data Analytics, this is super super super super super helpful to see what the day to day could look like and to learn a bit more. Thank you so much for going through everything, showing some common mistakes, working through it, and highlighting your reasoning for doing certain things. Thank you for doing this!

I absolutely loved your video! This is exactly what I was looking for. Actual work as an analyst. Will be looking for more of your vids.

Wow, thank you soo much for walking through this. You showed me how it is done and your commentarty was fantastic.

Currently in a DA bootcamp and it's dope seeing this from a real life perspective. Awesome content with great play by play explanations.

@ShashankData

3 жыл бұрын

Thank you Josafath!

Thank you sir. I am an aspiring DA. And wanted to get started. Been looking and training for a lot time and have almost lost hope. But you have made me realize it is really fun and interesting to deal with data ❤️

This was extremely useful ... It felt simple and structured... Not overwhelming at all... Glad you tool the time to share this on KZread ✌🏼✌🏼

A cool way to do paste special values is to add Paste Values to your Quick Access Toolbar at the very top. The commands there can be accessed via ALT + {position of the command in the QAT}. So, if your paste special values is in the second position, you'd copy the data with the formulas, then press ALT+2 and your data is now pasted as values.

As someone who already took a data analytics boot camp and is now a learning assistant, and who is already familiar with most of what was shown in this video, this was a great tutorial and showcase of what an actual data analysis job would look like. Thank you.

@tech_solutionn

4 ай бұрын

Yes i was searching from a month , today i got to know how this works

Thank you Shashank for such a video tutorial. Learned a lot from this video.

one of the best tutorial on data analysis I have come across. Amazing work man! THUMBS UP:)

I'm a medicine student and I love this things. I like to get along with numbers, statistics and Phyton and I think my future would be in epidemiology or some kind of specialization with a data analysis. Thanks for keeping alive that dream for sharing your day!

Very informative and fruitful project video

Hey man! Thanks so much for the video. I love the way you explain what you're doing at each step to make sure that we're following along. I'm a Computer Science graduate and I'm trying to teach myself Data Engineering and your video just gave me a window into what an actual job might look like. Thank you again and please continue to make videos like these.

The video is amazing. Exactly what I was searching for. Absolutely worth it. Make more videos like this one.

Your video just popped up today, 11 months after you released it. Great video where you explained a few things I wasn't aware of in Python. I am a data analyst and spend my days manipulating all sorts of data sets so it was good to see you working in the trenches. I have seen many people say Excel is irrelevant for data analytics but I am not sure what world they live in. In your video I thought you made things a bit hard for yourself by not eliminating the columns you didn't need in Excel before calling the file into Python. Even creating a third sheet and trimming the columns in there so you didn't have to code them out in Python later. Another thing I would have done (I know there are many ways to approach these projects) is to shorten the column titles and especially order the Question numbers so that there were in numerical order - eg: Q01, Q02... Q17 etc. This could easily been done in Excel as prep work. The Questions appeared as text in Python so Question 2 appeared after Question 19. Good video though, will check out the other you have made.

FINALLY! someone who showed the "ACTUAL" work🥰

absolutely loved this. This really gave me a good grasp on what I would be asked to do and my options of going about it.

Thanks for putting together such a great tutorial. I am an entry-level data analyst looking to broaden my skill set and I found your video to be very insightful. In addition, your screen presence is awesome. Keep up the great work! 🔔

searching what are two vertical dots called would be the most programmer thing ever, liked.

Easily one of the best if not the best video on the topic, real professional real work, none of that coffe and break bullshit. Congrats man!

Two years later and this is the best video about data analysis that I have come across. Shout out to you stranger for inspiring me!

I kinda don't want this to blow up so the competition doesn't see it. Good job dude.

@ShashankData

3 жыл бұрын

Hahahaha thanks Flexporter. I’ll keep pumping out the content.

@Starrthekid

3 жыл бұрын

@@ShashankData I think a video on general organization and other ideas you mentioned in the video would be great. I'm just starting out on this, so I don't knkw much and your info helps a lot. Thanks :)

@WilliamEllison

3 жыл бұрын

He showed nothing special here. Just basic stuff

@ShashankData

3 жыл бұрын

@@WilliamEllison You got it! I'm trying to show people how easy it can be to break into the world of analytics. Although not sexy, Data Cleansing is the most time intensive and arguably most important part of the modeling process. If you have a more advanced topic you'd like to cover please let me know! :)

@WilliamEllison

3 жыл бұрын

@@ShashankData ill let you know. thank you

I started a Google Analaytics Ceritifiate and this video give a persperctive of what I'll work on. Keep doing videos you explain ery good. Thanks

@JCgarciagarcia

3 жыл бұрын

Hey I’m taking the google analytics also, came here looking what im i getting into.

@sekmetb

3 жыл бұрын

Same!

@JesusPonce

3 жыл бұрын

Same, and watching this videos honestly makes me more excited about it!!

@vemmannar7043

3 жыл бұрын

Awesome guys. Did you all completed foundations data?

@JCgarciagarcia

3 жыл бұрын

@@vemmannar7043 I’m starting the 2nd course today, finished the foundations last Saturday.

Well stumbled upon this video out of nowhere and to say it’s a blessing for an aspiring analyst to know what I am getting into . Keep up the good work buddy subbed.

Dude - I am 27 minutes into this vid and it's absolutely great, the way you explain every single line, is like the best way to learn this stuff, instead of like a broad explanation, you go into basic details! keep it up

the other way to achieve what he was trying to do at 9:07 is to highlight Column A then do ctrl+g -> click special -> click blanks -> click ok -> without moving click = then move the cursor upwards (press up arrow key) -> ctrl +enter and voila, you have filled the blank cells with values above it

@seunjonathan

2 жыл бұрын

Wow! Just did it! Thanks

54:53 to get number of columns in Data set, can be achieved by using df.shape[1] and to get number of rows can also be achieved by df.shape[0].

Please keep making more videos like this. Really helpful for someone like me who is trying to get into this field of work.

You're a great teacher and communicator. I really learned a lot from watching your thought process.

Woww I'm an asian DA learner. It's absolutely helpful for me. Really appreciate this. Thank you, Shashank Kalanithi.

@ShashankData

3 жыл бұрын

Thanks for watching Cao!

@Jack-rr9nh

2 жыл бұрын

You are from Vietnam. Aren't you

@hemalathasc3958

2 жыл бұрын

@@Jack-rr9nh His last name sounds like Tamil

Very well explained, please do more of these😅