Aug 1, 2023
Aug 1, 2023
Task D: Detection of Duplicate rows, What is wrong in the following query? it shows target table is not updatetable WITH Duplicates AS( SELECT *, ROW_NUMBER() OVER(ORDER BY job_id) AS RowNumber FROM job_data ) DELETE FROM Duplicates WHERE RowNumber NOT
Aug 1, 2023
Data Cleaning
Aug 1, 2023
IMDb query
Aug 1, 2023
regarding the first question about the missing value
Aug 1, 2023
I amusing EXCEL 2016 version and calculating on such a large dataset results in continuously lagging in each steps, is there a solution since it is taking too much time for a simple calculation?
Aug 1, 2023
Excel finds oulier,Q1,Q2 and IQR by itself after creating a box plot and we can also calculate Q1,Q2 and IQR individually for columns, since there are so many numerical columns, can we proceed with the first method?
Aug 1, 2023
The project 6 contains two large datasets, Application data and previous application data,do we have to work with both the datasets or we can answer using only one dataset?
Aug 1, 2023
The project 6 contains two large datasets, Application data and previous application data,do we have to work with both the datasets or we can answer using only one dataset?
Aug 1, 2023