Understanding Data Cleaning | Google Data Analytics Certificate

  Рет қаралды 194,380

Google Career Certificates

Google Career Certificates

Күн бұрын

Пікірлер: 73
@inhlam5909
@inhlam5909 2 жыл бұрын
* Starting the data cleansing process: 18:57 * Cleaning Data from multiple sources: 25:16, 25:48 * Data cleaning features: Conditional format rules, Remove duplicates, Split, Concatenate * Optimize the Data Cleaning Process: 35:11, 38:27, 39:36, 40:00, 41:18 (Functions: COUNTIF, LEN, & Conditional formatting, LEFT, RIGHT, MID, TRIM, CONCATENATE,..) * Data perspectives: Sorting, Filtering, Pivot Table, VLOOKUP, Plotting * Even more data cleaning techniques: Data mapping, Compatibility, Schema, Primary Key, Foreign Key
@fuehrer_tb5597
@fuehrer_tb5597 2 жыл бұрын
keep in mind that data cleaning is the hardest and the most time consuming phase in data analysis..
@oluyomifadipe5634
@oluyomifadipe5634 2 жыл бұрын
Yep. Finding this out the hard way🤯
@sustainability.s
@sustainability.s 3 жыл бұрын
With clarity, eloquently and in simple language concepts are explained. Much appreciated and anyone interested in data analytics & related disciplines could learn a lot.
@kakayemi
@kakayemi 2 жыл бұрын
When you are able to clean you data, your analysis begins and that is where it all starts, data cleaning. cleaning data is critical to a good analysis
@ivanklful
@ivanklful 3 жыл бұрын
I've past through the entire course and I had completed it in period between July and November 2021, this year, and I earned certificate. I would say that the course is really awesome in many aspects, one of which is data cleaning jobs searching!
@damondjackson7239
@damondjackson7239 2 жыл бұрын
do you have an update? Did you get a job?
@RockstahRolln
@RockstahRolln 2 жыл бұрын
Thank you for your input! Are you currently employed?
@jslime6713
@jslime6713 Жыл бұрын
I got employed
@ditsaphongthep827
@ditsaphongthep827 Жыл бұрын
Her section is the best of this course.
@robinpuerta
@robinpuerta 3 жыл бұрын
Excellent summary of key functions on Spreadsheets for data cleaning!
@taiwoakinosho7982
@taiwoakinosho7982 Жыл бұрын
Interesting stuff. I don't use conditional formatting to find errors that much. I use filters and inspect the dropdown for inspecting anomalies. The dropdown contains unique values anyway.
@beetelvj10
@beetelvj10 Жыл бұрын
This session is eazy n engaging, it's can be more effective if the whole screen in the vedio becomes the computer screen n the instructor holds a small place at the corner...it's solves the problem for those who are using it in mobile , and sometimes the text becomes hazy n hard to read.
@minjinjargalsaikhan7325
@minjinjargalsaikhan7325 10 ай бұрын
Thank you so much. I would love to see your videos more. I really needed this well explained content. Thank you. You are the best!
@blooming93
@blooming93 6 ай бұрын
Easy to understand even for a very beginner like me!
@ksumar
@ksumar Жыл бұрын
Nicely explained. Very clear vocabulary and examples. I've not really used Google Sheets but Excel is the King of tools I use. Some great tips were given, thank you!
@federicofiorio6996
@federicofiorio6996 2 жыл бұрын
12:50 The rows #27 and #31 are not duplicates, they have different SO number and different amount of dollars transfered
@adamyapgoyal
@adamyapgoyal 2 жыл бұрын
Needs more upvotes!
@pablovelasquez9806
@pablovelasquez9806 2 жыл бұрын
If you paid more attention you would've heard that the data she was looking for at that point was "How many users you have", in that sense both accounts for Elaine, regardless of expenditure or any other variable, belong to the same user, therefore they are in fact duplicates.
@andilensele247
@andilensele247 2 жыл бұрын
@@pablovelasquez9806 as long as the column values in those 2 rows are not exactly the same then they are not duplicates. The 2 rows are unique and cannot simply delete because you losing some information !!
@tsaoh5572
@tsaoh5572 Жыл бұрын
@@pablovelasquez9806 As someone with an extremely generic name, just because the same ‘names’ occur in a dataset, doesn’t mean they’re actually the same people. Even if they share the same address! (Could be a son named after a father)
@nanasophia6242
@nanasophia6242 2 жыл бұрын
So easy to understand. Thank you so much!
@akin242002
@akin242002 3 жыл бұрын
This videos are awesome!!!
@sanjayrajbanshi7698
@sanjayrajbanshi7698 2 жыл бұрын
Beauty with the brain. Clearly explanation!
@AnneLopezlovesLife
@AnneLopezlovesLife 2 жыл бұрын
Done watching. Thanks for freely sharing this Google :)
@fevenasefa1865
@fevenasefa1865 2 жыл бұрын
Thank you so much I get my certificate last month!!
@Tanaka-Buchou
@Tanaka-Buchou 3 жыл бұрын
Thank you, Google.
@Catwomanloyal24009
@Catwomanloyal24009 2 жыл бұрын
Thank you so much!
@shreeshree4270
@shreeshree4270 Жыл бұрын
Can We Have A Video On Cleaning A Database With Multiple Column Header Like, Subject, Term1 & 2, Unit tests For Yearly Resuult Of a School
@Mrroy08657
@Mrroy08657 Жыл бұрын
Plz provide this Data Sets where I can access the MULTIPLE Data Sources for DATA CLEANING Portfolio Projects.
@tabishkhan-qz2vz
@tabishkhan-qz2vz 8 ай бұрын
where are these excel files???? can find them anwhere... any help is welcome
@vazdabilo6983
@vazdabilo6983 9 ай бұрын
how to get this data u are clearing so we can follow ?
@keylanoslokj1806
@keylanoslokj1806 Жыл бұрын
We have an Excel file with 10 columns and 500 rows. Last.4 columns have years and sales. There are blanks there but are randomly distributed. We want to delete the rows that have 4 blanks in a row. How would you go on about it?
@MrEveloff
@MrEveloff Жыл бұрын
Hi! Add filters to the columns using the filter button, then filter on blank cells on each of the 4 columns, you should find your empty lines in a second. Hope this helps!
@keylanoslokj1806
@keylanoslokj1806 Жыл бұрын
@@MrEveloff how to isolate, select en mass, and delete Only those who have all 4 horizontally cells in a row blank? Cause in that whole range you can have rows which have from 0-4 blank ones randomly distributed.
@MrEveloff
@MrEveloff Жыл бұрын
@@keylanoslokj1806 Select the columns you want to filter, add a filter by clicking the filter button, then on each column select the blank cell to filter on empty cells - the order does not matter as you want to select only rows with all 4 cells empty. There you have all the empty rows appearing. -> If you're using Google Sheets: select the whole lines then right click and click "Delete the selected lines" which will delete only the lines you selected. -> If you're using Excel you will need to select the filtered lines then type Alt+; to select only the filtered lines, then right click and delete the lines. This is a quick solution, there are other more complex ones but this one seems the most adapted to the situation you described ;)
@musicbox6574
@musicbox6574 Жыл бұрын
Is this included in Google data analytic certificate offered by coursera?
@GoogleCareerCertificates
@GoogleCareerCertificates Жыл бұрын
Yep! All of our lessons on KZbin are the same as the lessons offered on Coursera.
@adamyagogreen
@adamyagogreen Жыл бұрын
please provide this dataset
@LaCorvier
@LaCorvier Жыл бұрын
Thank you !!!!
@ШарльАрзуманов
@ШарльАрзуманов Жыл бұрын
Thank you
@nicouekuete8842
@nicouekuete8842 Жыл бұрын
This is good!
@fathimak9434
@fathimak9434 2 жыл бұрын
How do we deal with false positives?
@usmaniqbal1836
@usmaniqbal1836 2 жыл бұрын
Please share practice file..
@AbadirMahanad
@AbadirMahanad Жыл бұрын
#history#view#all
@calmmind3160
@calmmind3160 Жыл бұрын
why is google saying to fix problems manually in a spreadsheet? such a bad practice....... give me the way to do it like a professional using 100k records
@SavageThrifter
@SavageThrifter Жыл бұрын
That's exactly what I'm saying. What a waste of time. Just do everything manually? Wow thanks for nothing
@TanmoyTheDeadBoy
@TanmoyTheDeadBoy Жыл бұрын
She's too cute to sound this serious. 😶😅🥰
@AbadirMahanad
@AbadirMahanad Жыл бұрын
#playlist#view#all
@pewolo_nyenh
@pewolo_nyenh 11 ай бұрын
All the errors mentioned here can be avoided using a database!
@geelemo
@geelemo 9 ай бұрын
This course is on KZbin for free?? Why am i paying on coursera then lol
@GoogleCareerCertificates
@GoogleCareerCertificates 8 ай бұрын
Hi! On our KZbin channel, we offer the videos so you can get a preview of the content before enrolling, but it is only through Coursera that you will receive your certificate for completing the program. The full certificate program on Coursera also includes assessments, readings, and hands-on labs.
@ubiquitous1212
@ubiquitous1212 Жыл бұрын
Why she is not blinking her eyes..
@japptappseva
@japptappseva 11 ай бұрын
1.30 she did 😂
@BTSARMY-pc8bx
@BTSARMY-pc8bx 11 ай бұрын
She is a robot
@innerpeacemeditation6499
@innerpeacemeditation6499 10 ай бұрын
She did. You didn't notice
@Pathan264-f7q
@Pathan264-f7q 6 ай бұрын
Why are you noticing nonsense things.
@Pa1-369
@Pa1-369 5 ай бұрын
Looks like u are blinking too much
@YlmazDALKIRANscallion
@YlmazDALKIRANscallion 2 жыл бұрын
0:50 Who is she?
@ИринаКим-ъ5ч
@ИринаКим-ъ5ч Ай бұрын
Young James Perez Patricia Taylor David
@stevesmith2553
@stevesmith2553 2 жыл бұрын
That a DBA
@mohammadmujeeb6592
@mohammadmujeeb6592 2 жыл бұрын
is she robot??
@yameen3448
@yameen3448 Жыл бұрын
A very poor video on data cleaning by Google. Expected way more from them. Using a spreadsheet is just not acceptable.
@reanwithkimleng
@reanwithkimleng 3 ай бұрын
U are gorgeous ❤❤❤😊
@DataSet
@DataSet Жыл бұрын
Im ready for my bath 🛁
@bbayat4093
@bbayat4093 2 жыл бұрын
Better to say corrupt data.
@darshanvadile1288
@darshanvadile1288 Ай бұрын
The tutor is too pretty
@annanikolayan931
@annanikolayan931 11 ай бұрын
dude just show, stop talking that much
@kiptoocollins-y3u
@kiptoocollins-y3u 5 ай бұрын
is the instructor human??
@carlosjarquin5540
@carlosjarquin5540 5 ай бұрын
Yeap
Ways to Ensure Data Integrity | Google Data Analytics Certificate
33:24
Google Career Certificates
Рет қаралды 25 М.
Data Cleaning in SQL | Google Data Analytics Certificate
42:16
Google Career Certificates
Рет қаралды 129 М.
Интересно, какой он был в молодости
01:00
БЕЗУМНЫЙ СПОРТ
Рет қаралды 3,8 МЛН
小丑教训坏蛋 #小丑 #天使 #shorts
00:49
好人小丑
Рет қаралды 33 МЛН
Lamborghini vs Smoke 😱
00:38
Topper Guild
Рет қаралды 68 МЛН
If people acted like cats 🙀😹 LeoNata family #shorts
00:22
LeoNata Family
Рет қаралды 44 МЛН
Intro to Data Calculations in Spreadsheets and SQL | Google Data Analytics Certificate
1:12:32
Master Data Cleaning Essentials on Excel in Just 10 Minutes
10:16
Kenji Explains
Рет қаралды 697 М.
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 2,2 МЛН
Intro to Data Visualization with R & ggplot2 | Google Data Analytics Certificate
50:35
Google Career Certificates
Рет қаралды 48 М.
Data Analysis Using Spreadsheets | Google Data Analytics Certificate
34:05
Google Career Certificates
Рет қаралды 67 М.
Cleaning Data in Excel | Excel Tutorials for Beginners
21:04
Alex The Analyst
Рет қаралды 593 М.
I Tried 50 Data Analyst Courses. Here Are Top 5
8:41
Stefanovic
Рет қаралды 160 М.
Интересно, какой он был в молодости
01:00
БЕЗУМНЫЙ СПОРТ
Рет қаралды 3,8 МЛН