@Codingdidi

Hi, all here's the pdf for those who were looking for roadmap to business analyst role. https://www.instagram.com/reel/C6xr1OxLF5P/?igsh=enUyZjVtNDdpb2Ns Don't forget to comment, like and share with your fellow friends. Follow @Codingdidi❤️

Here's the link to apply for this role. https://docs.google.com/forms/d/e/1FAIpQLSdkJbo7eQLV94K9vi8JhcOxDltmKvqsLBtL5fEC701vSHiOWg/viewform

Hello everyone 🤠! I have uploaded the data science project 📷 video. Here's the link https://youtu.be/bAqj1IzCtTo?si=qmw5l6FR6f_9uxHr Go and watch it out. Follow @codingdidi✅

Hi all, Here's the complete article mentioning how to create the resume, and some sample resumes for your reference. Article link:- https://www.linkedin.com/posts/akansha-yadav24_read-the-complete-article-follow-my-telegram-activity-7194206974949937154-ulJi?utm_source=share&utm_medium=member_android Reel https://www.instagram.com/reel/C6vIjLKrAOP/?igsh=eTI4MTdhaDUzZTZv Follow @codingdidi

Hi, all Can you guys try now to access the document?

✅Follow @codingdidi ✅ 🔔 Microsoft is hiring 🤩 * 💻 Role: | Data Analyst ------------------------------ * 💸 Salary: | Upto ₹20 LPA ------------------------------ * 📍Location: | Hyderabad ------------------------------ * 😌 Experience: | Freshers ------------------------------ * 👨‍🎓 Qualification: | Graduation ------------------------------ * Batch: | 2023-24 ------------------------------ - ✅ Apply here: https://jobs.careers.microsoft.com/global/en/job/1716104/Data-Analyst

Maths for data science!! https://www.instagram.com/reel/C6ttV23SWKp/?igsh=MWdwbW4ycm9md3NjcQ== Drive 🔗 Link:- https://docs.google.com/document/d/1dOK2Tj0yy3_NlMrbizbB2OP5UKEXCtAGP3ZNj4gwX1U/edit?usp=drivesdk ❤️Follow @codingdidi ✅

⚠️Hyderabad applicants!! S&P Global is hiring! Position: Data Analyst Qualification: Bachelor’s/ Master's/ MBA Salary: 6 - 9 LPA (Expected) Experience: Freshers/ Experienced Location: Hyderabad, India 📌Apply Now: https://careers.spglobal.com/jobs/300706?lang=en-us&utm_source=linkedin

5 Excel Portfolio Based project

https://www.instagram.com/reel/C6p-EwOLk_r/?igsh=MWpqd3N4N21ub3Q1Mw== 1. Excel Data Analytics project for Portfolio - Finance Domain Part 1: https://youtu.be/3Acmk-rqn6c?si=Nh4ahb5t5BxcvbZJ Part 2: https://youtu.be/yzaLl-BvHnc?si=N-7VDNuLxDjB-CUJ 2. Full Project in Excel https://www.youtube.com/watch?v=opJgMj1IUrc&t=1s 3. EXCEL PORTFOLIO PROJECT https://www.youtube.com/watch?v=m13o5aqeCbM 4. Full Project in Excel with Interactive Dashboard https://www.youtube.com/watch?v=gTK5rNhWJyA 5. Hotel Booking Cancellation Project Using Data Analytics & Excel https://www.youtube.com/watch?v=Cq-w8AGLLzc ✅ Follow @codingdidi

American Express is hiring for Data Analyst Role 👇👇 https://aexp.eightfold.ai/careers/job/21932982

💼 JP Morgan is Hiring for 2024   📊 Role:- Data Scientist 🏙️ Job Location:- Bangalore 🎓 Qualification:- Graduation 💰 Salary:- Upto ₹ 10 LPA 🔗 Link- https://jpmc.fa.oraclecloud.com/hcmUI/CandidateExperience/en/sites/CX_1001/job/210512985?utm_medium=symphonytalent-jobads&utm_campaign=Default%20Campaign&utm_content=Data%20Scientist-%20Analyst&utm_term=210512985&utm_source=Indeed

Another pandas video is live, do check it out !! 📸 English:- https://youtu.be/i7fxyW9613E?si=vkbkyT2lRmHpyxBB Hindi:- https://youtu.be/o0k8htG3wss?si=NqJ7XpxFTgIbXwM_ Don't forget to comment. I'm waiting for you all in comments! 🙏. ✅Follow Codingdidi ✅

Seagate Technology Hiring Fresher For Intern - Data Science Follow @codingdidi Location: Pune, IN Qualification: Bachelor/Master Degree Work Experience: Freshers https://www.linkedin.com/feed/update/urn:li:share:7193249948732125184/

Pandas and Numpy Interview Questions for Data/ Business Analysts Question 1: You have a NumPy array representing student grades. How would you filter the array to extract only the grades above a certain threshold? Question 2: Explain the difference between 'drop_duplicates()' and 'duplicated()' methods in Pandas. Provide a code example demonstrating their usage. Question 3: Describe the usage of 'at' and 'iat[]' in Pandas for accessing DataFrame elements. How do they differ from 'loc[]' and 'iloc[]'? Question 4: You have a DataFrame containing sales data with columns 'ProductID', 'Category', and 'Sales'. How would you use the 'groupby()' method to calculate total sales for each category? Question 5: Discuss the benefits of using list comprehensions over traditional for loops in Python. Can you provide an example where list comprehensions improve code readability and efficiency? Question 6: What is the purpose of the 'apply()' function in Pandas? Can you provide a scenario where it's advantageous over other methods? Question 7: You are provided with a Pandas DataFrame that contains a column with date strings. How would you convert this column to a datetime format? Additionally, how would you extract the month and year from these datetime objects? Question 8: Describe how to perform array indexing and slicing in NumPy. Provide examples demonstrating different indexing and slicing techniques. Question 9: You have a DataFrame containing columns 'Name', 'Age', and 'Gender'. How would you filter the DataFrame to extract only the rows where Age is greater than 30 and Gender is 'Female'? Question 10: Describe the benefits of using the 'pd.merge()' function over other methods like 'DataFrame.join()' for merging DataFrames in Pandas. Can you provide a scenario where 'pd.merge()' is advantageous? Follow @codingdidi

⚠️Hiring ⚠️ Rocket Learning is #hiring for Data Analytics Intern (paid). Skills: SQL, Excel, etc. Send your resume at eklavya.s@rocketlearning.org

50 𝐨𝐟 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐢𝐦𝐩𝐨𝐫𝐭𝐚𝐧𝐭 𝐄𝐱𝐜𝐞𝐥 𝐟𝐨𝐫𝐦𝐮𝐥𝐚𝐬 𝐭𝐡𝐚𝐭 𝐜𝐚𝐧 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐩𝐞𝐫𝐟𝐨𝐫𝐦 𝐯𝐚𝐫𝐢𝐨𝐮𝐬 𝐭𝐚𝐬𝐤𝐬 𝐞𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐭𝐥𝐲. S𝐔𝐌: Adds up numbers in a range. 𝐀𝐕𝐄𝐑𝐀𝐆𝐄: Calculates the average of numbers in a range. 𝐌𝐀𝐗: Returns the largest number in a range. 𝐌𝐈𝐍: Returns the smallest number in a range. 𝐂𝐎𝐔𝐍𝐓: Counts the number of cells that contain numbers in a range. 𝐂𝐎𝐔𝐍𝐓𝐀: Counts the number of non-empty cells in a range. 𝐈𝐅: Checks if a condition is met and returns one value if true and another value if false. 𝐕𝐋𝐎𝐎𝐊𝐔𝐏: Searches for a value in the first column of a table and returns a value in the same row from another column. 𝐇𝐋𝐎𝐎𝐊𝐔𝐏: Similar to VLOOKUP, but searches for a value in the first row of a table. 𝐈𝐍𝐃𝐄𝐗: Returns the value of a cell in a specific row and column of a range. 𝐌𝐀𝐓𝐂𝐇: Returns the relative position of an item in a range. 𝐂𝐎𝐍𝐂𝐀𝐓𝐄𝐍𝐀𝐓𝐄: Joins two or more text strings into one string. 𝐋𝐄𝐅𝐓: Returns the leftmost characters from a text string. 𝐑𝐈𝐆𝐇𝐓: Returns the rightmost characters from a text string. 𝐋𝐄𝐍: Returns the number of characters in a text string. 𝐓𝐑𝐈𝐌: Removes leading and trailing spaces from a text string. 𝐔𝐏𝐏𝐄𝐑: Converts text to uppercase. 𝐋𝐎𝐖𝐄𝐑: Converts text to lowercase. 𝐏𝐑𝐎𝐏𝐄𝐑: Capitalizes the first letter of each word in a text string. 𝐓𝐄𝐗𝐓: Formats a number or date value as text using a specified format. 𝐃𝐀𝐓𝐄: Returns the serial number of a particular date. 𝐓𝐎𝐃𝐀𝐘: Returns the current date. 𝐍𝐎𝐖: Returns the current date and time. 𝐃𝐀𝐓𝐄𝐃𝐈𝐅: Calculates the difference between two dates in years, months, or days. 𝐄𝐎𝐌𝐎𝐍𝐓𝐇: Returns the last day of the month, n months before or after a given date. 𝐑𝐎𝐔𝐍𝐃: Rounds a number to a specified number of digits. 𝐑𝐎𝐔𝐍𝐃𝐔𝐏: Rounds a number up, away from zero, to the nearest multiple of significance. 𝐑𝐎𝐔𝐍𝐃𝐃𝐎𝐖𝐍: Rounds a number down, toward zero, to the nearest multiple of significance. 𝐈𝐅𝐄𝐑𝐑𝐎𝐑: Returns a value you specify if a formula evaluates to an error, otherwise returns the result of the formula. 𝐒𝐔𝐌𝐈𝐅: Adds the cells specified by a given condition or criteria. 𝐒𝐔𝐌𝐈𝐅𝐒: Adds the cells in a range that meet multiple criteria. 𝐀𝐕𝐄𝐑𝐀𝐆𝐄𝐈𝐅: Calculates the average of cells specified by a given condition or criteria. 𝐀𝐕𝐄𝐑𝐀𝐆𝐄𝐈𝐅𝐒: Calculates the average of cells that meet multiple criteria. 𝐂𝐎𝐔𝐍𝐓𝐈𝐅: Counts the number of cells specified by a given condition or criteria. COUNTIFS: Counts the number of cells that meet multiple criteria. RAND: Returns a random number between 0 and 1. RANDBETWEEN: Returns a random number between the numbers you specify. PI: Returns the value of pi (3.14159265358979). POWER: Raises a number to a power. SQRT: Returns the square root of a number. LOG: Returns the logarithm of a number to the base you specify. EXP: Returns e raised to the power of a given number. MOD: Returns the remainder of a division operation. INT: Rounds a number down to the nearest integer. ABS: Returns the absolute value of a number. AND: Returns TRUE if all its arguments are TRUE, and FALSE otherwise. OR: Returns TRUE if any argument is TRUE, and FALSE otherwise. NOT: Returns the opposite of a logical value. SUMPRODUCT: Multiplies corresponding components in the given arrays, and returns the sum of those products. TRANSPOSE: Transposes rows and columns in a range of cells. ❤️More likes more posts..! 🫶 Follow @codingdidi

Microsoft is hiring Data Analyst 👇👇 https://jobs.careers.microsoft.com/us/en/job/1716412/Data-Analyst?jobsource=linkedin

Coming live in 20 min for your queries.! Link is here https://youtube.com/@codingdidi-hindi?si=5w6wfM2i_mel2cfp Let's chat at 9:00pm

FRND is hiring for a Business and Strategy Analyst! 👇👇 https://www.linkedin.com/jobs/view/3913130927