- Видео 117
- Просмотров 116 692
Karina Data Scientist
Австралия
Добавлен 6 май 2024
Hi, I'm Karina! A decade ago, I transitioned from finance to the world of data analytics and data science. It is all started with simple VBA code, and I knew my life will never be the same. After that it was SQL, R, Python, PowerBI, Tableau, hours spent with Stackoverflow and RUclips tutorials.
⚡️Want to learn Python or start coding, but it feels overwhelming - start with my "Data Analysis with Python" beginner-friendly masterclass: karinadatascientist.com/
⚡️
Through my channel, I want to demystify data analysis and share my knowledge - from statistics and Excel to Python and ChatGPT.
Want to learn something new? Subscribe and hit the bell to get notified when I upload new videos!
⚡️Want to learn Python or start coding, but it feels overwhelming - start with my "Data Analysis with Python" beginner-friendly masterclass: karinadatascientist.com/
⚡️
Through my channel, I want to demystify data analysis and share my knowledge - from statistics and Excel to Python and ChatGPT.
Want to learn something new? Subscribe and hit the bell to get notified when I upload new videos!
Advanced Pandas Tutorial: 7 Data Analysis Techniques You Need to Know
Master Advanced Pandas Techniques for Data Analysis | Python Tutorial
In this hands-on tutorial, we'll cover essential advanced Pandas techniques including rolling averages, pivot tables, lambda functions, percent change, .query and cross-tabulation.
----------------------
Dataset used in this video - www.kaggle.com/datasets/yusufdelikkaya/online-sales-dataset
----------------------
🐼 Pandas Cheat Sheet - stan.store/KarinaDataScientist/p/complete-pandas-cheat-sheet
💻 Data Analysis with Python Masterclass - stan.store/KarinaDataScientist/p/start-programming-with-python
💌 Join my newsletter and get access to various freebies - stan.store/KarinaDataScientist
🧠 AI to help you analyse your data - po...
In this hands-on tutorial, we'll cover essential advanced Pandas techniques including rolling averages, pivot tables, lambda functions, percent change, .query and cross-tabulation.
----------------------
Dataset used in this video - www.kaggle.com/datasets/yusufdelikkaya/online-sales-dataset
----------------------
🐼 Pandas Cheat Sheet - stan.store/KarinaDataScientist/p/complete-pandas-cheat-sheet
💻 Data Analysis with Python Masterclass - stan.store/KarinaDataScientist/p/start-programming-with-python
💌 Join my newsletter and get access to various freebies - stan.store/KarinaDataScientist
🧠 AI to help you analyse your data - po...
Просмотров: 975
Видео
How I'd Learn Python for Data Analysis in 2025
Просмотров 1,5 тыс.Месяц назад
Why Python is so popular among data analysts and data scientists. What modules / libraries you should learn 🐼 Pandas Cheat Sheet - stan.store/KarinaDataScientist/p/complete-pandas-cheat-sheet 💻 Data Analysis with Python Masterclass - stan.store/KarinaDataScientist/p/start-programming-with-python 💌 Join my newsletter and get access to various freebies - stan.store/KarinaDataScientist 🧠 AI to hel...
How To Write a Data Analyst / Data Scientist Resume
Просмотров 1,1 тыс.Месяц назад
Are you struggling to land your dream job in data analytics or data science? In this video, I review real CVs and provide tips to help you create a standout resume that grabs recruiters' attention. Whether you're a beginner or an experienced professional, these insights will help you craft a resume tailored for top analytics roles. What You'll Learn: Common mistakes in data science CVs and how ...
Basic Guide to Pandas in 20 min. Python for Beginners
Просмотров 1,2 тыс.Месяц назад
Basic Guide to Pandas in 20 min. Python for Beginners
Credit Card Fraud Detection using ML (Python) | Random Forest
Просмотров 1,8 тыс.Месяц назад
Credit Card Fraud Detection using ML (Python) | Random Forest
Master SQL Window Functions in 15 Minutes | ROW_NUMBER, LAG/LEAD, RANK, FIRST_VALUE
Просмотров 4422 месяца назад
Master SQL Window Functions in 15 Minutes | ROW_NUMBER, LAG/LEAD, RANK, FIRST_VALUE
Time series forecasting in ML (ARIMA, Holt-Winters)
Просмотров 1,7 тыс.2 месяца назад
Time series forecasting in ML (ARIMA, Holt-Winters)
SQL Tutorial (JOIN, GROUP BY, SUBQUERY, HAVING, IN)
Просмотров 5332 месяца назад
SQL Tutorial (JOIN, GROUP BY, SUBQUERY, HAVING, IN)
SQL Tutorial (SELECT, WHERE, AND, OR, COUNT, SUM, AVG, ROUND)
Просмотров 7602 месяца назад
SQL Tutorial (SELECT, WHERE, AND, OR, COUNT, SUM, AVG, ROUND)
Learn SQL for free with ChatGPT #chatgpt #sql #ai #dataanalytics #chatgpt4
Просмотров 4833 месяца назад
Learn SQL for free with ChatGPT #chatgpt #sql #ai #dataanalytics #chatgpt4
Exploratory Data Analysis in 20 Minutes
Просмотров 1,6 тыс.3 месяца назад
Exploratory Data Analysis in 20 Minutes
Excel Lookups Made EASY! Master VLOOKUP, HLOOKUP, and XLOOKUP in 10 MIN
Просмотров 1 тыс.3 месяца назад
Excel Lookups Made EASY! Master VLOOKUP, HLOOKUP, and XLOOKUP in 10 MIN
Build Image Recognition Model In Python in 20 min
Просмотров 1,6 тыс.3 месяца назад
Build Image Recognition Model In Python in 20 min
Data Cleaning in Pandas in 20 minutes
Просмотров 4,2 тыс.3 месяца назад
Data Cleaning in Pandas in 20 minutes
Surprising Ways to Build a PERFECT DATA Portfolio
Просмотров 2,3 тыс.4 месяца назад
Surprising Ways to Build a PERFECT DATA Portfolio
Hugging Face Tutorial (2024) - Sentiment Analysis, Text Generation, LLM
Просмотров 1,9 тыс.4 месяца назад
Hugging Face Tutorial (2024) - Sentiment Analysis, Text Generation, LLM
Data Analytics Portfolio Project - Netflix customer base (Python)
Просмотров 2,8 тыс.5 месяцев назад
Data Analytics Portfolio Project - Netflix customer base (Python)
Excel Functions EVERYONE needs (FILTER, SORT, DATEDIF, TEXTSPLIT, TEXJOIN, CHOOSECOLS)
Просмотров 2,5 тыс.5 месяцев назад
Excel Functions EVERYONE needs (FILTER, SORT, DATEDIF, TEXTSPLIT, TEXJOIN, CHOOSECOLS)
Data Science Portfolio Project - Churn prediction model
Просмотров 4,4 тыс.5 месяцев назад
Data Science Portfolio Project - Churn prediction model
How To Make Beautiful Line Charts Using Matplotlib in Python
Просмотров 7165 месяцев назад
How To Make Beautiful Line Charts Using Matplotlib in Python
How I'd become a Data Analyst if I had to start today
Просмотров 2,4 тыс.5 месяцев назад
How I'd become a Data Analyst if I had to start today
Data Analysis Project in Excel (Beginner to Intermediate)
Просмотров 3,6 тыс.6 месяцев назад
Data Analysis Project in Excel (Beginner to Intermediate)
Data Analytics Portfolio Project - Coffee Sales
Просмотров 6 тыс.6 месяцев назад
Data Analytics Portfolio Project - Coffee Sales
Data Science Portfolio Project - K-means
Просмотров 2,5 тыс.6 месяцев назад
Data Science Portfolio Project - K-means
short and perfect explanation
After which step we create profile report??
You can do after you read the file to look at the data, or you can create it after you cleaned the data. It is up to you
would you tell me how to find outliers from describe ''outputs"??
Check the spread between quartiles: 25% (Q1), 50% (median), 75% (Q3) If a value is much higher than Q3 or much lower than Q1, it's likely an outlier. Also, if min or max values are very far from Q1 or Q3 respectively, they might be outliers To detect outliers you can use either Z-score method or IRQ method. You can find it in my Pandas Cheat Sheet stan.store/KarinaDataScientist/p/complete-pandas-cheat-sheet
@karinadatascientist someone says we can't use IQR on Skewed data, It's really true ???
Cool😊😊😊😊😊
thank you
Thank youuu❤
Welcome!!
Accent and content at the top of it 😊
Thank you
I find python although easy for its syntax but still hard really overwhelming.
Useful tips! Thanks for sharing, Karina! Could you also post videos for Numpy focused on Data Analysis! I'm a beginner to Data Analytics, and Numpy and Pandas have so many methods, which I literally I do not know which one to learn and focus on?
Sure, I will make videos for numpy too
Thanks a lot 👍
welcome!
Cool 🔥
thank you
I feel very comfortable with NumPy. Do you know if it's easily achievable with NumPy, or should I invest time in learning and becoming an expert in Pandas?
Numpy and pandas go hand-in-hand. Knowing NumPy helps you understand the inner workings of pandas. Pandas is enough for data cleaning and manipulation, however numpy is required for high-performance numerical operations (because it works way faster). Pandas works with 2D data, whereas when you work with higher-dimensional data like images and tensors, you need numpy. You are already comfortable with numpy, so why not to learn pandas/polars :) ?
Thank you
Thank you
Great sharing Karina. Karina can I add these in my portfolio as I am on the job hunt.
of course!
Make video on how mba finance guy became data analyst
Amazing video, video and your look is awesome , love from Lahore Pakistan
Thank you!
Hello Karina, Have a good day, My name is Ahmed Hassan, I'm an ex-finance and now I am trying to get my way through the data field, I found your fascinating RUclips channel while I was trying to learn from experts in this field and I found your videos so helpful, so I'm sending to you firstly to thank you very much for your wonderful efforts, secondly to ask you if you don't mind if I tagged you and insert the link of your RUclips videos on my posts on linked in that explain the projects I made and who help me to learn me the essential skills to achieve it. once again thank you for your help to teach others. Have a good time.
Hi Ahmed. Of course tag me on Linkedin, that's very kind of you. Thank you
@karinadatascientist Hi Karina, Thank you, I'm very happy by your response.
Hello sister , feature selection of three columns in 3D if more than three??❤
Merci beaucoup madame. C'est vraiment utile
welcome!
Thank god there are subtitles Because i am definitely hearing that wrong 😅 Shame there are no other comments I wanted to know if other people heard it too
😂
yes, other people heard it too! On TikTok they didn't hold it back, which made this video go sort of viral, getting nearly 23,000 views 😂.
@@karinadatascientist don't worry about it. I really love your accent personally ❤️❤️
I need help here on how you came up with the offset arrangement and criteria. I ask this because I am working on a different data set and I really need to include the legend/label correctly. thanks
It is a manual process, I had to just try different options till it was placed where I wanted it to be. For example, with line labels, this is a code I used: labels = df_transformed.columns offsets = [0, 0, 0, 5, 0, 2] # Adjust positions to avoid overlap for i, (label, offset) in enumerate(zip(labels, offsets)): y_pos = df_transformed[label].dropna().iloc[-1] + offset ax.text(df_transformed.index[-1] + 2, y_pos, label, color=COLOR_SCALE[i], fontsize=10, va='center') I started with offset all zeroes, didn't like it, started adjusting one by one to see what works best. Same with x, y here: fig.text( 0.015, 0.90, # (x,y) coordinates "Share of boys or girls within the relevant age group who are enrolled in primary, secondary, and tertiary education.", color=GREY30, fontsize=12, )
I'm happy you learnt python, I am learning a lot from you already. Will you consider creating a Web app using Taipy(maybe to track vehicles), I have already seen some good videos on YT but I also know I will grasp it better from you. Thank You for the great effort.
Hi can u suggest good courses on data analyst 🎉
edX courses are good and free. You have to try various one to see which resonates. With some you will not like instructor, with others - boring tasks. You need a combination of courses to find what you like :)
hi can u suggest any good course on generative ai
hi is coursera a good choice
To add on, a decent course I find helpful was Jose Portilla's Machine learning course. It has a decent data section for pandas, numpy, and matplotlib
Bravo 👏 Maestro 👏 Lit 🌠 Impressive 😍 Big respect and gratitude for your satisfactory Work 🚀🌱🌟
Thank you 🙌
Please Same videos on SQl, Excel and PowerBi.
Oh, can do. Thank you for an idea
Are you Reading?
Subscribed! Can you give recommendations on what you think would be great end to end (python, sql, tableau) resume ready projects for aspiring data analysts?
Thank you. Any business related projects - customer related, product related, expenses. Marketing campaign analytics (google, facebook, tiktok), user customer analysis (to help create a customer avatar), sales analysis. That's why I believe that sports or health projects are great, especially for practicing, but shouldn't be included in the portfolio, if you want to work for e-commerce, for example.
@karinadatascientist Thanks! An e-commerce sales dashboard was on my list, but I wanted to do a Covid-19 Vaccination Analysis and a healthcare readmission prediction using logistic regression. Should I drop these in favor of more business oriented projects? I know I'm asking a lot of questions haha, but any help would be greatly appreciated!
@@nindogaming4132 I would avoid COVID19 data. It was very popular in 2019 and 2020 :) Choose more business oriented
@@karinadatascientist Thank you!
thanks for this great tutorial!
welcome!
Thank you! I'm a very new programmer and learning Python - haven't heard of Jupyter before so this turned me on to that. Cheers!
You're very welcome!
Great tutorial, but just to mention that I generally use the MATCH function inside of the CHOOSECOLS; it will avoid me counting the number of columns that I want to return in my new table.
Fair enough. If you know how to use index+match, you can achieve a lot in Excel!
🎉
thank you
can u suggest good books on python
hi karina can u suggests some books on datascience
@@karthiksundaram544 o'reilly books are pretty good
is data scientist salaries good in US
Hey Karina 😁 guess who's here haha.
How AI is impacting data science roles Karina? People are recommending to transition into mlops or data engineering
I think transitioning into data engineering can be a good choice, if you are interested in that field. AI will not replace data science or data analytics, but it is another tool that will be a part of our daily workflow
Thank you for making this video. The tips are very helpful. 😊
Glad to hear that! thank you for the feedback
I have really learnt a lot following you especially with thst your python tips you drop occasionally.
Great to hear! Will make more of them!
I just found out this is what i have been looking for 🎉
Thanks ❤
You're welcome 😊
Useful recommendations and tips! Thank You, Karina! 😀
You're so welcome! Thank you for watching
Yes interested in part 2, if possible
I will work on it!
Hwyyyy was hoping if you added a template for us to download and tweak
The CV template I show is available as a part of my freebies package, that you get once you sign up to my newsletter stan.store/KarinaDataScientist/
Thank you for all the content you have provided on your channel! As an aspiring data analyst your channel has been a great resource. I also just purchased your Python for data analysis course!
Thank you. I hope you would enjoy the course!
superb teaching
thank you!!!!
Thank for sharing! hugs from Brasil
Thank you! Hello, Brazil!