Data Analyst Interview Question 6 - Python #shorts

Subscribe to my channel for more Data Analyst and Data Scientist content!

[xINuke]

Hey Shashank, I like your stuff!
Just wanted to give you a quick tip: when creating the dataframe, instead of passing a list of all the column names, just say (in this case) "columns=raw_data.keys()". Saves you from having to type the same information twice!

[ameyabadve]

If I was solving this question, after filling the NaN values, I would then filter out the redundant employees based on identical employee_ID as the question says there are redundant entries.

[ni]

Hi Shashank, I really like your way of teaching. Please do more of these where you teach Data Science thanks

[saptakmukherjee]

Can you please give us the link. I just stumbled upon your videos. And I'm preparing for data analyst role. It'd be really helpful if we can practice on interview questions.

[CountLife]

Looks good. This is the first time I understood everything. In pandas I keep getting a pseudo error that says try using .loc even when I use.loc. have you run into this as well

[vuhai]

Hey Shashank, thanks very much for these uploads. May I ask how much time do you have for each of these questions? And were they take-home questions or did you do it live? Thanks!

[emmanuelameyaw]

But you can use excel for this...may I ask why you need python code?

[prajwal.agarwal]

Can we just load this data in Excel and perform actions and then load that back again in Python to play with