Set the cleaning rules first

मॉड्यूल 2: Spreadsheets, Python and BI with AI

कोर्स की रूपरेखा

यह पाठ अभी आपकी भाषा में नहीं है, इसलिए यहाँ अंग्रेज़ी में है।

झटपट जाँच

Guess first, no penalty. You ask an AI to "remove duplicates" from a customer list, and 340 of 5,000 rows disappear. What should have come first?

A bigger file, so the loss looks smallerA written rule for what counts as a duplicateNothing, since duplicates are always safe to remove

Cleaning means fixing messy data: extra spaces, mixed date formats, blanks and repeats. AI is quick at it. But every cleaning step is a decision about what to keep, and those decisions change your totals.

So write the rules before the AI touches anything:

Duplicates. Which columns must match for two rows to be the same?
Blanks. Leave them empty, fill them, or drop the row? In SQL, AVG and COUNT(column) skip blanks (NULLs) without telling you, while COUNT(*) counts every row.
Formats. Which date format is the source in? 03/04 is 3 April in one country and 4 March in another.

Then keep the raw file untouched, and count rows before and after each step.

इस पाठ का बाकी हिस्सा Learn Pro में है

हर कोर्स का पहला मॉड्यूल फ्री है। Learn Pro से हर कोर्स का हर पाठ खुल जाता है, $10 महीने में। JobRise के सारे टूल फ्री ही रहेंगे।