CHANGE COLUMN DTYPE | How to change the datatype of a column in Pandas (2020)

[@bryanparis7779]

The best video...i was searching in so many videos here and thanks to you I'm done:) MANY WISHESSSSS

[@michaelmiachel1832]

Thank you! I've watched a lot of videos, but it was yours that helped me at a certain point👍

[@amaanraza2704]

Explanation with rationale as to why we do it a certain way is exemplary

[@7Dikano]

Hi, thank you! I have a problem while trying to convert 'missing' to int I have this error (IntCastingNaNError: Cannot convert non-finite values (NA or inf) to integer). Also my vs Code ipynb file won't recognise Int64: ..errors='coerce').astype(Int64)

[@mahboobalam5689]

It's a nicely explained tutorial. 👍

[@darksider8207]

can anyone explain at money col he replaces everything with empty string but i have loss which is indicated by - how can i keep the - sign for indicatiing loss and change its type to nu[meric ??

[@experiencewithgeoffrey]

Thank you so much for this! :)

[@ChartExplorers]

You're Welcome!

[@arunimav6592]

How to find out which of the columns are having a datatype object and convert them to string type ...i mean not specifically mentioning the column name..but by iterating and taking them automatically...PLS REPLY

[@unknown7261]

Hello, I just want to ask what to do if a dataframe is displaying 1,500 even if the value on the excel is 1,500.00

[@ChartExplorers]

When you read in the excel file you can specify the data type (dtype) of the column df = pd.read_excel('excel_file.xlsx', dtype={'col_a': float, 'col_d':float}) If your column of numbers has commas in (1,500.00) it you will have to read in the file, remove the commas and any other symbols and then convert to float. If you want two decimal places you can change it for the entire dataframe with the following pd.options.display.float_format = "{:,.2f}".format

[@miketruong0808]

Can you share the link to the video for converting column to datetime? It's not in your descriptions

[@ChartExplorers]

Hi Mike, thanks for letting me know! I had forgotten to add the link kzbin.info/www/bejne/nGivgHeBfs-nl6M

[@miketruong0808]

@@ChartExplorers thank you. Your video was very helpful by the way

[@ChartExplorers]

Thanks! I'm glad it helped (it makes it feel worth it when I know it actually helps out).

[@mrmuranga]

nice and short..thanks

[@sergio_bandera]

Thank youuuuuuuuuuuuuuuuuuuu!!!!!!!!!!!!!!!!!!!!

[@mr.sakshamjolly8972]

really helpful bro... thanks for creating this video

[@brandonjones5326]

Thanks for this!

[@ChartExplorers]

You're welcome! :D

[@honest_review2492]

How to convert high and low in float

[@honest_review2492]

It is not working with any of your suggestions please help

[@abdelrhmansayed340]

Thanks so much it is very informative.

[@ridoychandraray2413]

Very helpful

[@artibhardwaj5035]

Thanks alot u save my life

[@ChartExplorers]

You're welcome, I'm glad it helped!

[@shubhamjami5341]

Thank you so much bro

[@robiatuladawiyahal-qosh2916]

Thank you!

[@ameysonawane]

thank you so much..!!

[@ChartExplorers]

Did you figure out your error?

[@ameysonawane]

@@ChartExplorers yes.. thanks again.!

[@QuietPenguinGaming]

You completely skipped over the only column I cared about (missing) by saying "now we should be fully equipped to deal with this on our own". Abysmal tutorial and teacher.

[@weronikajakubowska2976]

Thank you!