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

⚠️Hiring ⚠️

Rocket Learning is #hiring for Data Analytics Intern (paid).

Skills: SQL, Excel, etc.

Send your resume at
eklavya.s@rocketlearning.org

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

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/

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 ✅

💼 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

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

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

⚠️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

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 ✅

✅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

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

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

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✅

Here's the link to apply for this role.


https://docs.google.com/forms/d/e/1FAIpQLSdkJbo7eQLV94K9vi8JhcOxDltmKvqsLBtL5fEC701vSHiOWg/viewform

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❤️

Hi, All

Complete data manipulation video....! 📸

https://www.instagram.com/reel/C60PRyPLMmO/?igsh=MXQ3dmdjZ3pteThsdw==




English:-

https://youtu.be/Fxok0Xaqm0s?si=HpkmdNLis2qe3Sbm

Hindi:-

https://youtu.be/9rLDQx23nQA?si=Tj1PaHFvlsGOMncv


Don't forget to comment and share with your fellow learners.


Follow @codingdidi ✅

Boo is hiring!
Position: Data Scientist Remote
Qualification: Bachelor’s/ Master's/ MBA
Salary: 6 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Hyderabad, India

Apply: https://boo012.snaphunt.com/job/24HQOO8LRY-IN-91

Follow @codingdidi