Nov-22-2019, 11:37 AM
After cleaning all the rows that has null values, why do I still have a row count that is uneven ?
The data set and my code can be found here: https://drive.google.com/drive/folders/1...sp=sharing
Theses lines:
Showed me that the columns: Year, NA_Sales, JP_Sales, EU_Sales don't have 16598 rows...
The data set and my code can be found here: https://drive.google.com/drive/folders/1...sp=sharing
Theses lines:
1 2 3 4 5 6 7 |
cursor.execute( 'SELECT * FROM VG_sale' ) query = cursor.fetchall() rows = pd.DataFrame(query, columns = ([ 'RANK' , 'NAME' , 'PLATFORM' , 'YEAR' , 'GENRE' , 'PUBLISHER' , 'NA_SALES' , 'EU_SALES' , 'JP_SALES' , 'OTHER_SALES' , 'GLOBAL_SALES' ])) print (rows.count()) |