Start learning 50% faster. Sign in now
Standardizing categorical entries to a single representation ensures consistency by consolidating multiple formats of the same entity into one standardized label. For example, consolidating "USA," "U.S.A," "United States," and "US" into one uniform label, like "United States," ensures that all data entries are interpreted consistently. This process is essential in data cleaning, as inconsistencies in categorical data can lead to inaccurate analysis, skewed results, and duplications in reporting. A uniform categorical format enables reliable grouping, sorting, and filtering for analysis. The other options are incorrect because: • Option 1 (Filtering duplicates) removes identical rows but doesn’t address inconsistency in a single field. • Option 2 (Using normalization) only applies to numeric scaling, not categorical consistency. • Option 3 (Applying data transformation) would encode inconsistencies rather than correct them. • Option 5 (Converting to uppercase) helps with case sensitivity but does not fully standardize variations.
The interest earned when a sum is invested at simple interest of 20% p.a., for 3 years, is Rs. 1500. What will be the total amount received after 2 year...
Compound interest received after 2 years on ₹7000 at R% rate of interest compounded annually is ₹1164.8. Find the value of R.
The difference between compound interest and simple interest at rate of 16% per annum for 2 years is Rs. 192. Find the simple interest obtained on same ...
Sunil invested Rs. ‘5x’ in scheme ‘A’ offering simple interest of 25% p.a. and reinvested the interest earned from scheme ‘A’ at the end of ...
Some amount out of Rs. 24000 was lent out at 10% per annum and the rest amount @ 16% per annum and thus in 5 years the total interest from both the amou...
If the compound interest on a certain sum of money for two years at 9% p.a. is ₹3,762, then the sum is:
Abhishek allocates Rs.1600 each into two different investment schemes, A and B. Scheme A provides simple interest annually at a rate of (R-2)%, while sc...
A man deposited Rs. 9000 at 10% compound interest, compounded annually while Rs. 8500 at 13% simple interest per annum. What will be the difference betw...
A principal amount of ₹5p grows to ₹(5p + 660) in 2 years at an annual interest rate of 20% compounded yearly. Determine the ...
A took a loan of Rs.5320 at simple interest of 20% p.a. and invested the same money in a scheme at simple interest of 30% p.a. Find the profit earned by...