Karina Data Scientist
Karina Data Scientist
  • Видео 117
  • Просмотров 116 692
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...
Просмотров: 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)
What NOT to do in a Job Interview
Просмотров 4392 месяца назад
What NOT to do in a Job Interview
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
Word Cloud in Python
Просмотров 7664 месяца назад
Word Cloud in Python
For Loops and While Loops in Python
Просмотров 3804 месяца назад
For Loops and While Loops in Python
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
Why Polars is better than Pandas?
Просмотров 1 тыс.5 месяцев назад
Why Polars is better than Pandas?
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 Project - RFM model
Просмотров 4,5 тыс.6 месяцев назад
Data Science Project - RFM model
T-test in MS Excel
Просмотров 2906 месяцев назад
T-test in MS Excel
Data Science Portfolio Project - K-means
Просмотров 2,5 тыс.6 месяцев назад
Data Science Portfolio Project - K-means

Комментарии

  • @ajithdevadiga9939
    @ajithdevadiga9939 2 дня назад

    short and perfect explanation

  • @anandshaw-ie3qk
    @anandshaw-ie3qk 3 дня назад

    After which step we create profile report??

    • @karinadatascientist
      @karinadatascientist 2 дня назад

      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

  • @anandshaw-ie3qk
    @anandshaw-ie3qk 3 дня назад

    would you tell me how to find outliers from describe ''outputs"??

    • @karinadatascientist
      @karinadatascientist 2 дня назад

      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

    • @anandshaw-ie3qk
      @anandshaw-ie3qk 2 дня назад

      @karinadatascientist someone says we can't use IQR on Skewed data, It's really true ???

  • @bubuts-di7wr
    @bubuts-di7wr 4 дня назад

    Cool😊😊😊😊😊

  • @belamonetatheanalyst
    @belamonetatheanalyst 6 дней назад

    Thank youuu❤

  • @bhushanlonkar5117
    @bhushanlonkar5117 6 дней назад

    Accent and content at the top of it 😊

  • @shivanisaraiya617
    @shivanisaraiya617 7 дней назад

    I find python although easy for its syntax but still hard really overwhelming.

  • @BillyT83
    @BillyT83 8 дней назад

    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?

  • @Emadamx
    @Emadamx 9 дней назад

    Thanks a lot 👍

  • @TheRealStus
    @TheRealStus 12 дней назад

    Cool 🔥

  • @franciscorafael7349
    @franciscorafael7349 18 дней назад

    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?

    • @karinadatascientist
      @karinadatascientist 7 дней назад

      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 :) ?

  • @DisconnectedArt
    @DisconnectedArt 18 дней назад

    Thank you

  • @olubunmifaneye8395
    @olubunmifaneye8395 26 дней назад

    Thank you

  • @saifullahhaidar391
    @saifullahhaidar391 26 дней назад

    Great sharing Karina. Karina can I add these in my portfolio as I am on the job hunt.

  • @mohammedrafi9662
    @mohammedrafi9662 26 дней назад

    Make video on how mba finance guy became data analyst

  • @hamidraza1584
    @hamidraza1584 26 дней назад

    Amazing video, video and your look is awesome , love from Lahore Pakistan

  • @ahmedammarali
    @ahmedammarali 27 дней назад

    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.

    • @karinadatascientist
      @karinadatascientist 26 дней назад

      Hi Ahmed. Of course tag me on Linkedin, that's very kind of you. Thank you

    • @ahmedammarali
      @ahmedammarali 26 дней назад

      @karinadatascientist Hi Karina, Thank you, I'm very happy by your response.

  • @reanwithkimleng
    @reanwithkimleng Месяц назад

    Hello sister , feature selection of three columns in 3D if more than three??❤

  • @thugthamizha11
    @thugthamizha11 Месяц назад

    Merci beaucoup madame. C'est vraiment utile

  • @AbyxsDragon
    @AbyxsDragon Месяц назад

    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

    • @ivanlim7583
      @ivanlim7583 Месяц назад

      😂

    • @karinadatascientist
      @karinadatascientist Месяц назад

      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 😂.

    • @TurdBoi666
      @TurdBoi666 25 дней назад

      ​@@karinadatascientist don't worry about it. I really love your accent personally ❤️❤️

  • @okotpascal
    @okotpascal Месяц назад

    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

    • @karinadatascientist
      @karinadatascientist Месяц назад

      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, )

  • @okotpascal
    @okotpascal Месяц назад

    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.

  • @karthiksundaram544
    @karthiksundaram544 Месяц назад

    Hi can u suggest good courses on data analyst 🎉

    • @karinadatascientist
      @karinadatascientist Месяц назад

      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 :)

    • @karthiksundaram544
      @karthiksundaram544 Месяц назад

      hi can u suggest any good course on generative ai

    • @karthiksundaram544
      @karthiksundaram544 Месяц назад

      hi is coursera a good choice

  • @nindogaming4132
    @nindogaming4132 Месяц назад

    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

  • @CultureofSpeech
    @CultureofSpeech Месяц назад

    Bravo 👏 Maestro 👏 Lit 🌠 Impressive 😍 Big respect and gratitude for your satisfactory Work 🚀🌱🌟

  • @bhushanlonkar5117
    @bhushanlonkar5117 Месяц назад

    Please Same videos on SQl, Excel and PowerBi.

  • @ZakirHussain-nd4fw
    @ZakirHussain-nd4fw Месяц назад

    Are you Reading?

  • @nindogaming4132
    @nindogaming4132 Месяц назад

    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?

    • @karinadatascientist
      @karinadatascientist Месяц назад

      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.

    • @nindogaming4132
      @nindogaming4132 Месяц назад

      ​@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!

    • @karinadatascientist
      @karinadatascientist Месяц назад

      @@nindogaming4132 I would avoid COVID19 data. It was very popular in 2019 and 2020 :) Choose more business oriented

    • @nindogaming4132
      @nindogaming4132 Месяц назад

      @@karinadatascientist Thank you!

  • @bahar.around.theworld
    @bahar.around.theworld Месяц назад

    thanks for this great tutorial!

  • @xalxika
    @xalxika Месяц назад

    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!

  • @hoperight5280
    @hoperight5280 Месяц назад

    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.

    • @karinadatascientist
      @karinadatascientist Месяц назад

      Fair enough. If you know how to use index+match, you can achieve a lot in Excel!

  • @karthiksundaram544
    @karthiksundaram544 Месяц назад

    🎉

  • @luffysan2662
    @luffysan2662 Месяц назад

    Hey Karina 😁 guess who's here haha.

  • @balakrishna8167
    @balakrishna8167 Месяц назад

    How AI is impacting data science roles Karina? People are recommending to transition into mlops or data engineering

    • @karinadatascientist
      @karinadatascientist Месяц назад

      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

  • @siddhilipare
    @siddhilipare Месяц назад

    Thank you for making this video. The tips are very helpful. 😊

  • @emmanueledozie1357
    @emmanueledozie1357 Месяц назад

    I have really learnt a lot following you especially with thst your python tips you drop occasionally.

  • @emmanueledozie1357
    @emmanueledozie1357 Месяц назад

    I just found out this is what i have been looking for 🎉

  • @emmanueledozie1357
    @emmanueledozie1357 Месяц назад

    Thanks ❤

  • @BillyT83
    @BillyT83 Месяц назад

    Useful recommendations and tips! Thank You, Karina! 😀

  • @anuvabkumarrit4669
    @anuvabkumarrit4669 Месяц назад

    Yes interested in part 2, if possible

  • @suc1-w4w
    @suc1-w4w Месяц назад

    Hwyyyy was hoping if you added a template for us to download and tweak

    • @karinadatascientist
      @karinadatascientist Месяц назад

      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/

  • @JT-lo9nv
    @JT-lo9nv Месяц назад

    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!

  • @Saicharan_beast
    @Saicharan_beast Месяц назад

    superb teaching

  • @paulok8232
    @paulok8232 Месяц назад

    Thank for sharing! hugs from Brasil