How to Replace Values of Dataframes | Replace, Where, Mask, Update and More

Поделиться
HTML-код
  • Опубликовано: 21 авг 2024

Комментарии • 64

  • @misraturp
    @misraturp  Год назад

    👉 All you need to know about Pandas in one place!
    Download my Pandas Cheat Sheet (free)
    misraturp.gumroad.com/l/pandascs

  • @himanshupandey9902
    @himanshupandey9902 2 года назад +2

    Hey, again. You really make things simpler, so that a laymen also can understand.

  • @message59
    @message59 8 месяцев назад +1

    hands down your videos are the best ressources I found to these kind of topics
    thanks a lot for making these videos✌🏻😁

  • @maxinechantel8361
    @maxinechantel8361 2 года назад +4

    Hi Misra, thank you for your videos they are helping me to learn Pandas. You explain so simple and it is really encouraging.

    • @misraturp
      @misraturp  2 года назад +1

      That's amazing to hear, thank you Maxine!

  • @ArnauViaM
    @ArnauViaM 2 года назад +1

    pandas cut seems extremely useful! Thanks

    • @misraturp
      @misraturp  2 года назад

      I know right! You're welcome.

  • @saheedoyewole9424
    @saheedoyewole9424 Год назад +1

    Thanks a lot Misra, you're doing a wonderful job.

  • @chastippett
    @chastippett Год назад

    super helpful. have never seen the pd.cut function - Thank you

  • @burakceylan.92
    @burakceylan.92 2 года назад

    Crystal clear speak and to the point infos. Thank you

    • @misraturp
      @misraturp  2 года назад

      You're very welcome!

  • @birsenbas1009
    @birsenbas1009 Год назад

    Hi Mısra, you're really have great explanations. I have learned a lot of and useful things even a few days. I am really excited to continue listening your videos aas a new data scientist candidate. Also you make me very motivated. Thanks a lot again!

    • @misraturp
      @misraturp  Год назад

      That's great to hear Birsen! Happy to hear you like the videos and that they motivate you.

  • @avonstar8893
    @avonstar8893 Год назад

    Very helpful Misra. Thank you.

  • @isha4350
    @isha4350 3 месяца назад

    Informative video .

  • @Asma-ir8rr
    @Asma-ir8rr 7 месяцев назад

    I like your explanation 👌🏻♥️

  • @kennethstephani692
    @kennethstephani692 Год назад

    Terrific Video!!

  • @e.t.499
    @e.t.499 2 года назад +2

    Hey Misra, can you make a video about deciding under which conditions we should use normalization or standardization?

  • @curtisjackson3377
    @curtisjackson3377 2 года назад +2

    Hey MIsra, thanks for another simple to understand video. Can you possibly make a similar thread on pandas dataframe Join/Merge? That would be great help. Thanks again.
    Cheers
    🍻

    • @Kidpambi
      @Kidpambi 2 года назад

      This would be very helpful 🎉

    • @misraturp
      @misraturp  2 года назад

      Hey Curtis, you're very welcome. :) I actually have that video already: ruclips.net/video/788KHREDbX8/видео.html

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

    nice explain

  • @lucifer-kq1sc
    @lucifer-kq1sc Год назад +2

    you're making my life easier with these tuts :')

  • @GregThatcher
    @GregThatcher 3 месяца назад

    Thanks!

  • @reledata8035
    @reledata8035 Год назад

    thank you Misra

  • @mehdismaeili3743
    @mehdismaeili3743 2 года назад

    Excellent, thanks.

  • @mjacfardk
    @mjacfardk 2 года назад

    Thank you
    Pls video of pd.cut and filling/imputing missing values

    • @misraturp
      @misraturp  2 года назад

      Yes, working on that one now! Thank you for the suggestion!

  • @graceblomqvist5378
    @graceblomqvist5378 Год назад

    Very very good! thx!

  • @durgav8122
    @durgav8122 10 месяцев назад

    Hai Mam....Can you please come with the videos for SQL in data Analytics.....?

  • @vrbaac1641
    @vrbaac1641 Год назад

    Hi, Thank you for this video... it is very clear and easy to follow... I also want to ask... In case of a data frame having negative numbers, is it possible to replace these negative numbers by its corresponding absolute value, using the same routine in the video? thank you ^^

    • @misraturp
      @misraturp  Год назад +1

      I don't know this off the top of my head but I'm sure there is a quick way to achieve this using Pandas :)

  • @learnwithgandalf
    @learnwithgandalf 2 года назад +1

    cool mam

  • @user-ru5yt4vg4v
    @user-ru5yt4vg4v 5 месяцев назад

    Hi Misra,
    If we have a column where we are having a message which is returned from the device, so from this message how can we create a new column by taking keyword from the existing column and display the status of it in the new column by using python?

  • @vashisht1
    @vashisht1 4 месяца назад

    When didn't you use replace like this
    data[ 'Agency'].replace( { dict})
    Inside dictionary I will give all the old values as key and new values a pair ..

  • @sakhachowdhury5266
    @sakhachowdhury5266 2 месяца назад

    Can we use any function to replace a data.like normally we replace a data with tha mean of that column.is there any other method instead of mean.

  • @muriloambrozio7563
    @muriloambrozio7563 9 месяцев назад

    Could I use a list in the loc. Method?

  • @Krishnapatil1996
    @Krishnapatil1996 2 года назад

    as compared to data cleansing .... till the end video, I just see you ...

  • @arvinstatistics
    @arvinstatistics 2 месяца назад

    You are so pretty and smart.

  • @barisbulut7193
    @barisbulut7193 Год назад

    selam, thanks for the info. i have a probem in changing characters within the cells. in my dataframe, some of values are for instance: 12.4 and some of them are 12,4, meaning some are seperated with comma, and some are seperated with dot. how can i change all the dots with commas without changing the values. thanks

  • @SlimPit
    @SlimPit Год назад

    Hi, i have a question that i dont know. I need to change a specific value in a specific line in my Dataframe. Example in your Dataframe in Column "Job ID" in the line (1), i want to change the value 379094 to another value, how can i do this? I tried to loc but not worked. Can someone help please, thank you. Sorry for the english, im brazilian.

  • @tonywillingham8109
    @tonywillingham8109 Год назад

    How does one download the chest sheet? It is unclear.

    • @misraturp
      @misraturp  Год назад

      Here is the link: misraturp.gumroad.com/l/pandascs

  • @marcelocarvalho4510
    @marcelocarvalho4510 Год назад

    Hello, I loved your video!
    I would like to ask a question. In this case, the intent would be data cleaning where I have a dataframe where all the information in the "data" column has characters that shouldn't be there, for example: '01012023TT00'. I would like to remove these "TT00" characters. How should I do?
    I'm doing it this way, but it doesn't update the dataframe.:
    import pandas as pd
    import numpy as np
    df = pd.read_csv('/content/HRDataset_v14.csv')
    df.head()
    df['Employee_Name'].str.replace('Anderson, Carol','Anderson')
    df
    ################
    If we put the df = df['Employee_Name'].str.replace('Anderson, Carol','Anderson')
    It will update, but not in the dataframe.

  • @myselfandpesit
    @myselfandpesit Год назад

    Too many ways to do it makes it quite confusing for me

  • @comment8767
    @comment8767 4 месяца назад +1

    Misra is too distracting .... makes it difficult to concentrate on the code...

  • @user-ss9je8hf8j
    @user-ss9je8hf8j 11 месяцев назад

    aww

  • @barspinoza
    @barspinoza Год назад

    Thanks!