Cleaning Data in Google Sheets

[@nategraham3980]

Thank you! Going through the google data analytics certificate and this has been a helpful resource!

[@WilliamGabriel-fp5dj]

Thanks man. I'm studying DS while improve my english. I'm brazilian and i hope to get a job as Data Scientist still this year

[@jsmarier]

Good luck!

[@farhanatasnim2548]

Great work. Such a resourceful video for the beginner!

[@jsmarier]

Thank you!

[@elmago1298]

Super helpful, thanks so much!!

[@jsmarier]

Thank you!

[@FeyisayoOgunlade]

Can you give a document containing the formulars

[@jsmarier]

I apologize for the late reply. Here's the dataset from the video: docs.google.com/spreadsheets/d/14cLoYyHq_wiZuikvY0LcUUfZ5UUoJkDcYWnIx5I4bZM/edit?usp=sharing

[@danielramirez9329]

Hi Jean! If this process needs to be repeated every month, how can I "record" the cleaning steps to repeat? I mean: Does Google have a tool like Power Query?
thanks.

[@jsmarier]

Hello Daniel. I'm not sure whether it would work perfectly, but you can look into macros: support.google.com/docs/answer/7665004

[@SearchingforScraps]

Great vid !

[@jsmarier]

Thank you!

[@hasnatkabirshakil9128]

can you give us the dataset ?

[@jsmarier]

Hello. You can find it here: drive.google.com/file/d/18TeB3BRTmdevW7xo_RwbPUplw2S7-EaA/view?usp=share_link

[@gabrielpalmer9496]

@@jsmarier Really appreciate it. I was having trouble copying the link address

[@mikaeladelulu]

very helpful thanks!

[@jsmarier]

Thank you!

[@pj04laus]

Thank You So Much! 😁

[@jsmarier]

Thank you!

[@MegaAvijitdey]

you deleted almost everything,

[@jsmarier]

Yes, I did. This is just a demo. In a real-life scenario, I would likely keep more of the data.