Explore the List of 30 libraries used by data scientists.

https://www.linkedin.com/posts/akansha-yadav24_python-libraries-for-data-science-activity-7189858305530380289-x_2w?utm_source=share&utm_medium=member_android



Follow @Codingdidi✅

Here's the link of FREE DATA SCIENCE INTRODUCTORY COURSE.



LINK :- https://skillsforall.com/course/introduction-data-science?courseLang=en-US



https://www.instagram.com/reel/C6RE_pxSwrg/?igsh=MXB0bXBxYjF6M2ZxOQ==


✅Follow @codingdidi

Hi, All

Pandas day-3 video is live!!
Go check it out.

English video link:-

https://youtu.be/EbKzSqmS-Hg?si=qQhX8cFbrC-io7Wx


Hindi video link:-
https://youtu.be/F3niR44_L38?si=09M4Oc-iuFloexTy

Don't forget to like, share and comment on videos.


I'm waiting for your comments.



Follow @codingdidi

⭐️ The PyTorch team is developing a library for learning LLM called torch titan.

Today the library has become publicly available on GitHub, but it is still in a pre-release state and is actively being developed.

- Library link: https://github.com/pytorch/torchtitan

The library was created for preliminary training of models, and for fine tuning PyTorch has another library, torchtune:

https://github.com/pytorch/torchtune

✅ https://t.me/Codingdidi

TOP 10 SQL Concepts for Job Interview.

Don't forget to revise these concepts to clear the interview.

1. Aggregate Functions (SUM/AVG)
2. Group By and Order By
3. JOINs (Inner/Left/Right)
4. Union and Union All
5. Date and Time processing
6. String processing
7. Window Functions (Partition by)
8. Subquery
9. View and Index
10. Common Table Expression (CTE)



Like this post if you need more 👍❤️

Hope it helps :)

5 Unique Power BI projects for Resume✅

📌Website Traffic Analysis
🔗https://www.phdata.io/blog/web-traffic-power-bi-dashboard-example/

📌Weather Forecasting Analysis
🔗https://www.novypro.com/project/vstrix1303--github

📌Employee Performance Analysis
🔗https://github.com/Krishnkumar542/INX-Future-Inc-Employee-Performance-Analysis-using-Power-BI

📌Sales Data Visualization and Analysis
🔗https://github.com/yashsdoshi/Sales_report_using_PowerBi

📌 E-commerce website customer-purchasing Capability Analysis
🔗https://github.com/meysamraz/digikala-e-commerce-website-customer-purchase-dashboard

Follow @codingdidi –

Instagram https://www.instagram.com/codingdidi/
Youtube https://youtube.com/@codingdidi?si=TkcPMdGsgV8z61lh

Linkedin
www.linkedin.com/in/akansha-yadav24

Times Group is #hiring for a Data Analyst.

Experience: 1-2 yrs
Location: Noida office (Film city)
Skills: Data analysis, visualization skills (Tableau) and MS Excel

Interested candidates can send their resume at :
c-dwitika.gambhir@timesgroup.com , madhavi.dhumal@timesgroup.com

Also, please mention current CTC and notice period in the email.

Follow @Codingdidi✅

Hi All, here is the template for the cover letter.

Make sure to update it as per the job description.

https://www.instagram.com/reel/C6VXPGVrDU3/?igsh=amlrbzRwbWV4aGEw


✅Follow @codingdidi

Citi hiring for Fresher Data Scientist

https://jobs.citi.com/job/-/-/287/63060553280?

Amazon Hiring Fresher For Data Analyst
Location: Bangalore, Hyderabad, Gurugram
Qualification: Bachelor/Master Degree
Work Experience: Fresher
Salary: 5 - 8 LPA

👍✅Apply Link: https://www.amazon.jobs/en/jobs/2616762/data-analyst-abcs-analytics


Amazon Hiring Fresher For Data Analyst
Location: Bangalore
Qualification: Bachelor/Master Degree
Work Experience: 1+ years
Salary: 8 - 12 LPA

✅👍Apply Link: https://www.amazon.jobs/en/jobs/2613934/data-analyst

✅For Daily job Updates join here: https://t.me/Codingdidi

If you are trying to transition into the data analytics domain and getting started with SQL, focus on the most useful concept that will help you solve the majority of the problems, and then try to learn the rest of the topics:

👉🏻 Basic Aggregation function:
1️⃣ AVG
2️⃣ COUNT
3️⃣ SUM
4️⃣ MIN
5️⃣ MAX

👉🏻 JOINS
1️⃣ Left
2️⃣ Inner
3️⃣ Self (Important, Practice questions on self join)

👉🏻 Windows Function (Important)
1️⃣ Learn how partitioning works
2️⃣ Learn the different use cases where Ranking/Numbering Functions are used? ( ROW_NUMBER,RANK, DENSE_RANK, NTILE)
3️⃣ Use Cases of LEAD & LAG functions
4️⃣ Use cases of Aggregate window functions

👉🏻 GROUP BY
👉🏻 WHERE vs HAVING
👉🏻 CASE STATEMENT
👉🏻 UNION vs Union ALL
👉🏻 LOGICAL OPERATORS

Other Commonly used functions:
👉🏻 IFNULL
👉🏻 COALESCE
👉🏻 ROUND
👉🏻 Working with Date Functions
1️⃣ EXTRACTING YEAR/MONTH/WEEK/DAY
2️⃣ Calculating date differences

👉🏻CTE
👉🏻Views & Triggers (optional)


✅Share with credits: https://t.me/codingdidi

❤️Hope it helps :) 😃

Hi all,

Here's the link for pandas day-4 video.


English :- https://youtu.be/UaoseR5HnUY?si=7jz5SRkaoNzrIb1U


Hindi:-
https://youtu.be/jQTKaqRjVos?si=9k9XGnv7nobEDQZT


I'm waiting for you all in the comment section.


✅Share it with your fellow learners.


Follow @codingdidi

American Express is hiring for a Data Analyst!

https://aexp.eightfold.ai/careers?pid=21324925

Paytm is hiring for a Data Scientist (Product Analytics)!

https://jobs.lever.co/paytm/4850b2c2-0045-458b-9c43-3b50cc4bb4cc

Like for more ❤️

All the best 👍👍

Hi, all
here's the roadmap for learning EXCEL with free resources.


INSTAGRAM:- https://www.instagram.com/reel/C6X8J-yLNSW/?igsh=MWwxZHI1Z3pzbWJvZw==



✅FOLLOW @CODINGDIDI

👉Freshers jobs opportunity:

https://www.linkedin.com/feed/update/urn:li:share:7190925456852815872/

✅Follow @codingdidi

HI, all


Pandas day-5 video is live..!



👉Looking for your love and comments on videos...!


Go check out the video 📸



Hindi:- https://youtu.be/4NTWYUeuSWM?si=M6WYYY5K_azhjYk2


English :-

https://youtu.be/CrvY0QIURyg?si=TQDzMXCl8QLnANWY




✅Follow @Codingdidi

NTT DATA is hiring!
Position: Data Analyst
Experience: Entry Level
Location: Hyderabad, India

https://nttdata.eightfold.ai/careers?pid=563327918064034&domain=nttdata.com


✅Follow @Codingdidi