Issue: Corrupted Data in streams Column

Evidence: The streams column, which should contain numerical values, has some entries that appear to be non-numeric.
track_name  artist(s)_name  artist_count  ... streams ...
0          Seven           Latto, Jung Kook  2         ... 141381703 ...
1          LALA            Myke Towers       1         ... 133716286 ...
2          vampire         Olivia Rodrigo    1         ... 140003974 ...
3          Cruel Summer    Taylor Swift      1         ... 800840817 ...
4          WHERE SHE GOES  Bad Bunny         1         ... 303236322 ...
This dataset entry appears correct, but inspecting more entries reveals potential issues, such as 1.41E+08 instead of 141000000.
Description: The streams column should consistently contain numeric data. Any non-numeric or incorrectly formatted numeric entries need correction to maintain data integrity and facilitate accurate analysis.
Issue: Missing Values in key Column

Evidence: The key column has missing values (NaN) for some entries.
15  key 858 non-null object
Description: The key column is essential for musical analysis, indicating the musical key of each track. Missing values should be addressed by filling them with appropriate values or removing incomplete entries to ensure the dataset is useful for comprehensive analysis.
Issue: Inconsistent Data Types in in_shazam_charts Column

Evidence: The in_shazam_charts column contains mixed data types (some values are objects instead of integers).
13  in_shazam_charts  903 non-null  object
Description: Data types should be consistent across all entries in a column to avoid errors in data processing and analysis. The in_shazam_charts column should only contain integer values, representing the chart positions of songs on Shazam.