- 89
- 60 170
Karina Data Scientist
Australia
Приєднався 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 UA-cam 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!
Excel Lookups Made EASY! Master VLOOKUP, HLOOKUP, and XLOOKUP in 10 MIN
This video is an Excel tutorial. I’ll break down three of the most essential lookup functions in Excel: VLOOKUP, HLOOKUP, and XLOOKUP.
What you’ll learn:
- How to use VLOOKUP to find data vertically in large spreadsheets.
- How to apply HLOOKUP for horizontal data lookups.
- Why XLOOKUP is the ultimate replacement for VLOOKUP and HLOOKUP, offering more flexibility and efficiency.
Perfect for data analysts, business professionals, and anyone looking to save time in Excel.
💌 Join my newsletter and get access to various freebies - stan.store/KarinaDataScientist
🧠 AI to help you analyse your data - powerdrill.ai/?via=karina-sam...
----------------------
Timestamps:
----------------------
00:00 Intro
00:34 VLOOKUP()
04:03 XLOOKUP()
08:07 HLOOKUP()
----------------------
Social Media:
----------------------
TikTok: www.tiktok.com/@karinadatascientist
Instagram: karinadatascientist
Linkedin: www.linkedin.com/in/karina-samsonova/
What you’ll learn:
- How to use VLOOKUP to find data vertically in large spreadsheets.
- How to apply HLOOKUP for horizontal data lookups.
- Why XLOOKUP is the ultimate replacement for VLOOKUP and HLOOKUP, offering more flexibility and efficiency.
Perfect for data analysts, business professionals, and anyone looking to save time in Excel.
💌 Join my newsletter and get access to various freebies - stan.store/KarinaDataScientist
🧠 AI to help you analyse your data - powerdrill.ai/?via=karina-sam...
----------------------
Timestamps:
----------------------
00:00 Intro
00:34 VLOOKUP()
04:03 XLOOKUP()
08:07 HLOOKUP()
----------------------
Social Media:
----------------------
TikTok: www.tiktok.com/@karinadatascientist
Instagram: karinadatascientist
Linkedin: www.linkedin.com/in/karina-samsonova/
Переглядів: 833
Відео
Build Image Recognition Model In Python in 20 min
Переглядів 633День тому
Dive into the world of Deep Learning and master image recognition using Convolutional Neural Networks (CNNs) in Python! This comprehensive tutorial takes you from the basics to building and testing your own powerful image recognition model. No prior deep learning experience required! This tutorial covers: The fundamentals of Deep Learning Setting up your Python environment for CNN development D...
Data Cleaning in Pandas in 20 minutes
Переглядів 3,4 тис.14 днів тому
Learn essential data cleaning techniques in Python. In this video tutorial we will use salary data scraped from job websites that requires some cleaning. We will remove characters, convert hourly salary to yearly, split columns and then create visuals. This tutorial covers: String manipulation with str.replace(), Splitting columns using comma separators, One-hot encoding for categorical data, C...
Build Perfect DATA portfolio
Переглядів 1,8 тис.21 день тому
Creating a strong portfolio is essential if you’re looking to break into data analytics or data science. In this video, I’ll walk you through the key do’s and don’ts when building your portfolio, helping you avoid common mistakes and stand out to potential employers. Whether you’re a beginner or looking to level up your career, this guide will show you how to showcase your skills and land your ...
Hugging Face Tutorial (2024) - Sentiment Analysis, Text Generation, LLM
Переглядів 1,1 тис.Місяць тому
Hugging Face Tutorial (2024) - Sentiment Analysis, Text Generation, LLM
Data Analytics Portfolio Project - Netflix customer base (Python)
Переглядів 2,2 тис.Місяць тому
Data Analytics Portfolio Project - Netflix customer base (Python)
Data Science Portfolio Project - Churn prediction model
Переглядів 2,9 тис.2 місяці тому
Data Science Portfolio Project - Churn prediction model
How To Make Beautiful Line Charts Using Matplotlib in Python
Переглядів 4622 місяці тому
How To Make Beautiful Line Charts Using Matplotlib in Python
How I'd become a Data Analyst if I had to start today
Переглядів 2,2 тис.2 місяці тому
How I'd become a Data Analyst if I had to start today
Data Analysis Project in Excel (Beginner to Intermediate)
Переглядів 3,2 тис.2 місяці тому
Data Analysis Project in Excel (Beginner to Intermediate)
Data Analytics Portfolio Project - Coffee Sales
Переглядів 5 тис.3 місяці тому
Data Analytics Portfolio Project - Coffee Sales
Data Science Portfolio Project - K-means
Переглядів 2,1 тис.3 місяці тому
Data Science Portfolio Project - K-means
Monte Carlo Simulation (Predict NVIDIA Share Price)
Переглядів 5643 місяці тому
Monte Carlo Simulation (Predict NVIDIA Share Price)
Data Scientist Portfolio Project - Logistic Regression (Beginners to Intermediate)
Переглядів 9294 місяці тому
Data Scientist Portfolio Project - Logistic Regression (Beginners to Intermediate)
Data Analyst Portfolio Project with Python
Переглядів 1,3 тис.4 місяці тому
Data Analyst Portfolio Project with Python
Solve Mystery with Stats: Correlation Coefficient
Переглядів 1684 місяці тому
Solve Mystery with Stats: Correlation Coefficient
Amazing 😍😍
Thank you!
Great share as always
Thank you!
This was very helpful. Thank you!
So happy to hear that! Thank you for your comment
It helped a-lot. Thanks!!
Glad it helped!
this was very helpful, thanks! But i´m everytime confused because i´ve never seen a video so far in which the assumptions of linearity between the features and the log odds of the target or multicollinearity in a logistic regression model were checked. Is there´s a reason? Or why didn´t you check these assumptions?
It is a vild point. Have you worked as a data scientist in the business or you worked in academia/as a researcher? It’s quite common for people not to check these assumptions in practical applications of logistic regression. In practical data science tasks, the focus is often on predictive power, and models like decision trees, random forests, or gradient boosting might be preferred, where assumptions of linearity are not required. Logistic regression will still run even with multicollinearity, and in many real-world datasets, multicollinearity doesn’t prevent the model from being useful, particularly when the goal is prediction rather than inference. Since in real-life projects main focus is accuracy - I haven't run into issues where these assumptions caused major problems.
if you know any company where i get data analyst internship them please tell me
I don't know any, but if I come across - I will let you know
My Excel e-book is available here - stan.store/KarinaDataScientist. It is suitable for complete beginners as well as experienced Excel users. I put together all the functions I use, and paid extra attention to Pivot tables (including calculated fields, groupings etc).
Thanks for your videos and share. I have two queries, 1. As a data scientist, whether you work on powerbi? I think in future, data scientist should hav data engineers skills and data analyst skills, irrespective of their own skills... 2. Whether I can practice excel online in the cloud rather than in the local PC....
Hey, I am probably not a good example of a typical data scientist, as I work mostly with startups on everything from strategy implementation and development up to analytics projects and ML projects. And since start ups don't have team to do all the work, I work with PowerBI/Tableau/DOMO/Redash/Mixpanel too. But I don't know if it is expected from DSs if they work for big corporates. I agree with you that data engineering and data analytic skills will probably become part of "Full stack data scientist" role at some point. 2) I think there is Excel Online that is a part of the Microsoft Office 365 suite. You can access it through your Microsoft account on OneDrive. Or you can use Google Sheets, some things are not exactly the same, but it is also a good way of practicing, and it is free
@@karinadatascientist Thanks for your kind response....
Thank you so much. I learn more when watching your videos 😊 Have a nice day ❤
Aww, that's great to hear. Thank you
I follow you at tik tok as well. ❤❤
Thank you :)
I really love how you present the content. ❤❤❤❤
Thank you!
Thanks, continue the good work 🎉
Thank you for your support
Great
thank you
Thanks a lot 🙌
Thank you for watching!
My mentor we need a full explanation video for each algorithm
Thanks my Mentor 🎉
My pleasure
great video, i love the way you make learning simple.
Thank you so much for your feedback
Great !
Thank you
nice walkthrough. Link to the notebook?
Just two things to say: excellent and thank you
thank you :)
hello.which laptop do u use?
Hi. MacBook Air
Great content and good case study...
thank you!
thanks for sharing
Thanks for watching!
Always learning something new. Didn't know about pandas.Index.get_loc...
Very useful ! Thank you.
Glad to hear that!
Please provide roadmap to data science
Will do!