import pandas as pd import spotipy from spotipy.oauth2 import SpotifyOAuth, SpotifyClientCredentials import yaml import re from sklearn.feature_extraction.text import TfidfVectorizer from sklearn.metrics.pairwise import cosine_similarity from sklearn.preprocessing import MinMaxScaler import pickle def playlist_model(url, model, max_gen=3, same_art=5): log = [] Fresult = [] try: log.append('Start logging') uri = url.split('/')[-1].split('?')[0] stream = open("Spotify/Spotify5.yaml") spotify_details = yaml.safe_load(stream) auth_manager = SpotifyClientCredentials( client_id=spotify_details['Client_id'], client_secret=spotify_details['client_secret']) sp = spotipy.client.Spotify(auth_manager=auth_manager) if model == 'Spotify Model': def get_IDs(user, playlist_id): try: log.append('start playlist extraction') track_ids = [] playlist = sp.user_playlist(user, playlist_id) for item in playlist['tracks']['items']: track = item['track'] track_ids.append(track['id']) return track_ids except Exception as e: log.append('Failed to load the playlist') log.append(e) track_ids = get_IDs('Ruby', uri) track_ids_uni = list(set(track_ids)) log.append('Starting Spotify Model') Spotifyresult = pd.DataFrame() for i in range(len(track_ids_uni)-5): if len(Spotifyresult) >= 50: break try: ff = sp.recommendations(seed_tracks=list(track_ids_uni[i:i+5]), limit=5) except Exception as e: log.append(e) continue for z in range(5): result = pd.DataFrame([z+(5*i)+1]) result['uri'] = ff['tracks'][z]['id'] Spotifyresult = pd.concat([Spotifyresult, result], axis=0) Spotifyresult.drop_duplicates(subset=['uri'], inplace=True,keep='first') Fresult = Spotifyresult.uri[:50] log.append('Model run successfully') return Fresult, log lendf=len(pd.read_csv('Data/streamlit.csv',usecols=['track_uri'])) dtypes = {'track_uri': 'object', 'artist_uri': 'object', 'album_uri': 'object', 'danceability': 'float16', 'energy': 'float16', 'key': 'float16', 'loudness': 'float16', 'mode': 'float16', 'speechiness': 'float16', 'acousticness': 'float16', 'instrumentalness': 'float16', 'liveness': 'float16', 'valence': 'float16', 'tempo': 'float16', 'duration_ms': 'float32', 'time_signature': 'float16', 'Track_release_date': 'int8', 'Track_pop': 'int8', 'Artist_pop': 'int8', 'Artist_genres': 'object'} col_name= ['track_uri', 'artist_uri', 'album_uri', 'danceability', 'energy', 'key', 'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness', 'liveness', 'valence', 'tempo', 'duration_ms', 'time_signature', 'Track_release_date', 'Track_pop', 'Artist_pop', 'Artist_genres'] try: def get_IDs(user, playlist_id): log.append('start playlist extraction') track_ids = [] artist_id = [] playlist = sp.user_playlist(user, playlist_id) for item in playlist['tracks']['items']: track = item['track'] track_ids.append(track['id']) artist = item['track']['artists'] artist_id.append(artist[0]['id']) return track_ids, artist_id except Exception as e: log.append('Failed to load the playlist') log.append(e) track_ids, artist_id = get_IDs('Ruby', uri) log.append("Number of Track : {}".format(len(track_ids))) artist_id_uni = list(set(artist_id)) track_ids_uni = list(set(track_ids)) log.append("Number of unique Artists : {}".format(len(artist_id_uni))) log.append("Number of unique Tracks : {}".format(len(track_ids_uni))) def extract(track_ids_uni, artist_id_uni): err = [] err.append('Start audio features extraction') audio_features = pd.DataFrame() for i in range(0, len(track_ids_uni), 25): try: track_feature = sp.audio_features(track_ids_uni[i:i+25]) track_df = pd.DataFrame(track_feature) audio_features = pd.concat([audio_features, track_df], axis=0) except Exception as e: err.append(e) continue err.append('Start track features extraction') track_ = pd.DataFrame() for i in range(0, len(track_ids_uni), 25): try: track_features = sp.tracks(track_ids_uni[i:i+25]) for x in range(25): track_pop = pd.DataFrame([track_ids_uni[i+x]], columns=['Track_uri']) track_pop['Track_release_date'] = track_features['tracks'][x]['album']['release_date'] track_pop['Track_pop'] = track_features['tracks'][x]["popularity"] track_pop['Artist_uri'] = track_features['tracks'][x]['artists'][0]['id'] track_pop['Album_uri'] = track_features['tracks'][x]['album']['id'] track_ = pd.concat([track_, track_pop], axis=0) except Exception as e: err.append(e) continue err.append('Start artist features extraction') artist_ = pd.DataFrame() for i in range(0, len(artist_id_uni), 25): try: artist_features = sp.artists(artist_id_uni[i:i+25]) for x in range(25): artist_df = pd.DataFrame([artist_id_uni[i+x]], columns=['Artist_uri']) artist_pop = artist_features['artists'][x]["popularity"] artist_genres = artist_features['artists'][x]["genres"] artist_df["Artist_pop"] = artist_pop if artist_genres: artist_df["genres"] = " ".join([re.sub(' ', '_', i) for i in artist_genres]) else: artist_df["genres"] = "unknown" artist_ = pd.concat([artist_, artist_df], axis=0) except Exception as e: err.append(e) continue try: test = pd.DataFrame( track_, columns=['Track_uri', 'Artist_uri', 'Album_uri']) test.rename(columns={'Track_uri': 'track_uri', 'Artist_uri': 'artist_uri', 'Album_uri': 'album_uri'}, inplace=True) audio_features.drop( columns=['type', 'uri', 'track_href', 'analysis_url'], axis=1, inplace=True) test = pd.merge(test, audio_features, left_on="track_uri", right_on="id", how='outer') test = pd.merge(test, track_, left_on="track_uri", right_on="Track_uri", how='outer') test = pd.merge(test, artist_, left_on="artist_uri", right_on="Artist_uri", how='outer') test.rename(columns={'genres': 'Artist_genres'}, inplace=True) test.drop(columns=['Track_uri', 'Artist_uri_x', 'Artist_uri_y', 'Album_uri', 'id'], axis=1, inplace=True) test.dropna(axis=0, inplace=True) test['Track_pop'] = test['Track_pop'].apply(lambda x: int(x/5)) test['Artist_pop'] = test['Artist_pop'].apply(lambda x: int(x/5)) test['Track_release_date'] = test['Track_release_date'].apply(lambda x: x.split('-')[0]) test['Track_release_date'] = test['Track_release_date'].astype('int16') test['Track_release_date'] = test['Track_release_date'].apply(lambda x: int(x/50)) test[['danceability', 'energy', 'key', 'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness', 'liveness', 'valence', 'tempo', 'time_signature']] = test[[ 'danceability', 'energy', 'key', 'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness', 'liveness', 'valence', 'tempo', 'time_signature']].astype('float16') test[['duration_ms']] = test[['duration_ms']].astype('float32') test[['Track_release_date', 'Track_pop', 'Artist_pop']] = test[[ 'Track_release_date', 'Track_pop', 'Artist_pop']].astype('int8') except Exception as e: err.append(e) err.append('Finish extraction') return test, err test, err = extract(track_ids_uni, artist_id_uni) for i in err: log.append(i) del err grow = test.copy() test['Artist_genres'] = test['Artist_genres'].apply(lambda x: x.split(" ")) tfidf = TfidfVectorizer(max_features=max_gen) tfidf_matrix = tfidf.fit_transform(test['Artist_genres'].apply(lambda x: " ".join(x))) genre_df = pd.DataFrame(tfidf_matrix.toarray()) genre_df.columns = ['genre' + "|" +i for i in tfidf.get_feature_names_out()] genre_df = genre_df.astype('float16') test.drop(columns=['Artist_genres'], axis=1, inplace=True) test = pd.concat([test.reset_index(drop=True),genre_df.reset_index(drop=True)], axis=1) Fresult = pd.DataFrame() x = 1 for i in range(int(lendf/2), lendf+1, int(lendf/2)): try: df = pd.read_csv('Data/streamlit.csv',names= col_name,dtype=dtypes,skiprows=x,nrows=i) log.append('reading data frame chunks from {} to {}'.format(x,i)) except Exception as e: log.append('Failed to load grow') log.append(e) grow = grow[~grow['track_uri'].isin(df['track_uri'].values)] df = df[~df['track_uri'].isin(test['track_uri'].values)] df['Artist_genres'] = df['Artist_genres'].apply(lambda x: x.split(" ")) tfidf_matrix = tfidf.transform(df['Artist_genres'].apply(lambda x: " ".join(x))) genre_df = pd.DataFrame(tfidf_matrix.toarray()) genre_df.columns = ['genre' + "|" +i for i in tfidf.get_feature_names_out()] genre_df = genre_df.astype('float16') df.drop(columns=['Artist_genres'], axis=1, inplace=True) df = pd.concat([df.reset_index(drop=True), genre_df.reset_index(drop=True)], axis=1) del genre_df try: df.drop(columns=['genre|unknown'], axis=1, inplace=True) test.drop(columns=['genre|unknown'], axis=1, inplace=True) except: log.append('genre|unknown not found') log.append('Scaling the data .....') if x == 1: sc = pickle.load(open('Data/sc.sav','rb')) df.iloc[:, 3:19] = sc.transform(df.iloc[:, 3:19]) test.iloc[:, 3:19] = sc.transform(test.iloc[:, 3:19]) log.append("Creating playlist vector") playvec = pd.DataFrame(test.sum(axis=0)).T else: df.iloc[:, 3:19] = sc.transform(df.iloc[:, 3:19]) x = i if model == 'Model 1': df['sim']=cosine_similarity(df.drop(['track_uri', 'artist_uri', 'album_uri'], axis = 1),playvec.drop(['track_uri', 'artist_uri', 'album_uri'], axis = 1)) df['sim2']=cosine_similarity(df.iloc[:,16:-1],playvec.iloc[:,16:]) df['sim3']=cosine_similarity(df.iloc[:,19:-2],playvec.iloc[:,19:]) df = df.sort_values(['sim3','sim2','sim'],ascending = False,kind='stable').groupby('artist_uri').head(same_art).head(50) Fresult = pd.concat([Fresult, df], axis=0) Fresult = Fresult.sort_values(['sim3', 'sim2', 'sim'],ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).head(50) elif model == 'Model 2': df['sim'] = cosine_similarity(df.iloc[:, 3:16], playvec.iloc[:, 3:16]) df['sim2'] = cosine_similarity(df.loc[:, df.columns.str.startswith('T') | df.columns.str.startswith('A')], playvec.loc[:, playvec.columns.str.startswith('T') | playvec.columns.str.startswith('A')]) df['sim3'] = cosine_similarity(df.loc[:, df.columns.str.startswith('genre')], playvec.loc[:, playvec.columns.str.startswith('genre')]) df['sim4'] = (df['sim']+df['sim2']+df['sim3'])/3 df = df.sort_values(['sim4'], ascending=False,kind='stable').groupby('artist_uri').head(same_art).head(50) Fresult = pd.concat([Fresult, df], axis=0) Fresult = Fresult.sort_values(['sim4'], ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).head(50) del test try: del df log.append('Getting Result') except: log.append('Getting Result') if model == 'Model 1': Fresult = Fresult.sort_values(['sim3', 'sim2', 'sim'],ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).track_uri.head(50) elif model == 'Model 2': Fresult = Fresult.sort_values(['sim4'], ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).track_uri.head(50) log.append('{} New Tracks Found'.format(len(grow))) if(len(grow)>=1): try: new=pd.read_csv('Data/new_tracks.csv',dtype=dtypes) new=pd.concat([new, grow], axis=0) new=new[new.Track_pop >0] new.drop_duplicates(subset=['track_uri'], inplace=True,keep='last') new.to_csv('Data/new_tracks.csv',index=False) except: grow.to_csv('Data/new_tracks.csv', index=False) log.append('Model run successfully') except Exception as e: log.append("Model Failed") log.append(e) return Fresult, log def top_tracks(url,region): uri = url.split('/')[-1].split('?')[0] stream= open("Spotify/Spotify.yaml") spotify_details = yaml.safe_load(stream) auth_manager = SpotifyClientCredentials(client_id=spotify_details['Client_id'],client_secret=spotify_details['client_secret']) sp = spotipy.client.Spotify(auth_manager=auth_manager) log = [] Fresult = [] try: log.append('Starting Spotify Model') top=sp.artist_top_tracks(uri,country=region) for i in range(10) : Fresult.append(top['tracks'][i]['id']) log.append('Model run successfully') except Exception as e: log.append("Model Failed") log.append(e) return Fresult,log def song_model(url, model, max_gen=3, same_art=5): log = [] Fresult = [] try: log.append('Start logging') uri = url.split('/')[-1].split('?')[0] stream = open("Spotify/Spotify.yaml") spotify_details = yaml.safe_load(stream) auth_manager = SpotifyClientCredentials( client_id=spotify_details['Client_id'], client_secret=spotify_details['client_secret']) sp = spotipy.client.Spotify(auth_manager=auth_manager) if model == 'Spotify Model': log.append('Starting Spotify Model') aa=sp.recommendations(seed_tracks=[uri], limit=25) for i in range(25): Fresult.append(aa['tracks'][i]['id']) log.append('Model run successfully') return Fresult, log lendf=len(pd.read_csv('Data/streamlit.csv',usecols=['track_uri'])) dtypes = {'track_uri': 'object', 'artist_uri': 'object', 'album_uri': 'object', 'danceability': 'float16', 'energy': 'float16', 'key': 'float16', 'loudness': 'float16', 'mode': 'float16', 'speechiness': 'float16', 'acousticness': 'float16', 'instrumentalness': 'float16', 'liveness': 'float16', 'valence': 'float16', 'tempo': 'float16', 'duration_ms': 'float32', 'time_signature': 'float16', 'Track_release_date': 'int8', 'Track_pop': 'int8', 'Artist_pop': 'int8', 'Artist_genres': 'object'} col_name= ['track_uri', 'artist_uri', 'album_uri', 'danceability', 'energy', 'key', 'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness', 'liveness', 'valence', 'tempo', 'duration_ms', 'time_signature', 'Track_release_date', 'Track_pop', 'Artist_pop', 'Artist_genres'] log.append('Start audio features extraction') audio_features = pd.DataFrame(sp.audio_features([uri])) log.append('Start track features extraction') track_ = pd.DataFrame() track_features = sp.tracks([uri]) track_pop = pd.DataFrame([uri], columns=['Track_uri']) track_pop['Track_release_date'] = track_features['tracks'][0]['album']['release_date'] track_pop['Track_pop'] = track_features['tracks'][0]["popularity"] track_pop['Artist_uri'] = track_features['tracks'][0]['artists'][0]['id'] track_pop['Album_uri'] = track_features['tracks'][0]['album']['id'] track_ = pd.concat([track_, track_pop], axis=0) log.append('Start artist features extraction') artist_id_uni=list(track_['Artist_uri']) artist_ = pd.DataFrame() artist_features = sp.artists(artist_id_uni) artist_df = pd.DataFrame(artist_id_uni, columns=['Artist_uri']) artist_pop = artist_features['artists'][0]["popularity"] artist_genres = artist_features['artists'][0]["genres"] artist_df["Artist_pop"] = artist_pop if artist_genres: artist_df["genres"] = " ".join([re.sub(' ', '_', i) for i in artist_genres]) else: artist_df["genres"] = "unknown" artist_ = pd.concat([artist_, artist_df], axis=0) try: test = pd.DataFrame(track_, columns=['Track_uri', 'Artist_uri', 'Album_uri']) test.rename(columns={'Track_uri': 'track_uri','Artist_uri': 'artist_uri', 'Album_uri': 'album_uri'}, inplace=True) audio_features.drop(columns=['type', 'uri', 'track_href', 'analysis_url'], axis=1, inplace=True) test = pd.merge(test, audio_features,left_on="track_uri", right_on="id", how='outer') test = pd.merge(test, track_, left_on="track_uri",right_on="Track_uri", how='outer') test = pd.merge(test, artist_, left_on="artist_uri",right_on="Artist_uri", how='outer') test.rename(columns={'genres': 'Artist_genres'}, inplace=True) test.drop(columns=['Track_uri', 'Artist_uri_x','Artist_uri_y', 'Album_uri', 'id'], axis=1, inplace=True) test.dropna(axis=0, inplace=True) test['Track_pop'] = test['Track_pop'].apply(lambda x: int(x/5)) test['Artist_pop'] = test['Artist_pop'].apply(lambda x: int(x/5)) test['Track_release_date'] = test['Track_release_date'].apply(lambda x: x.split('-')[0]) test['Track_release_date'] = test['Track_release_date'].astype('int16') test['Track_release_date'] = test['Track_release_date'].apply(lambda x: int(x/50)) test[['danceability', 'energy', 'key', 'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness', 'liveness', 'valence', 'tempo', 'time_signature']] = test[['danceability', 'energy', 'key', 'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness', 'liveness', 'valence', 'tempo', 'time_signature']].astype('float16') test[['duration_ms']] = test[['duration_ms']].astype('float32') test[['Track_release_date', 'Track_pop', 'Artist_pop']] = test[['Track_release_date', 'Track_pop', 'Artist_pop']].astype('int8') except Exception as e: log.append(e) log.append('Finish extraction') grow = test.copy() test['Artist_genres'] = test['Artist_genres'].apply(lambda x: x.split(" ")) tfidf = TfidfVectorizer(max_features=max_gen) tfidf_matrix = tfidf.fit_transform(test['Artist_genres'].apply(lambda x: " ".join(x))) genre_df = pd.DataFrame(tfidf_matrix.toarray()) genre_df.columns = ['genre' + "|" +i for i in tfidf.get_feature_names_out()] genre_df = genre_df.astype('float16') test.drop(columns=['Artist_genres'], axis=1, inplace=True) test = pd.concat([test.reset_index(drop=True),genre_df.reset_index(drop=True)], axis=1) Fresult = pd.DataFrame() x = 1 for i in range(int(lendf/2), lendf+1, int(lendf/2)): try: df = pd.read_csv('Data/streamlit.csv',names= col_name,dtype=dtypes,skiprows=x,nrows=i) log.append('reading data frame chunks from {} to {}'.format(x,i)) except Exception as e: log.append('Failed to load grow') log.append(e) grow = grow[~grow['track_uri'].isin(df['track_uri'].values)] df = df[~df['track_uri'].isin(test['track_uri'].values)] df['Artist_genres'] = df['Artist_genres'].apply(lambda x: x.split(" ")) tfidf_matrix = tfidf.transform(df['Artist_genres'].apply(lambda x: " ".join(x))) genre_df = pd.DataFrame(tfidf_matrix.toarray()) genre_df.columns = ['genre' + "|" +i for i in tfidf.get_feature_names_out()] genre_df = genre_df.astype('float16') df.drop(columns=['Artist_genres'], axis=1, inplace=True) df = pd.concat([df.reset_index(drop=True), genre_df.reset_index(drop=True)], axis=1) del genre_df try: df.drop(columns=['genre|unknown'], axis=1, inplace=True) test.drop(columns=['genre|unknown'], axis=1, inplace=True) except: log.append('genre|unknown not found') log.append('Scaling the data .....') if x == 1: sc = pickle.load(open('Data/sc.sav','rb')) df.iloc[:, 3:19] = sc.transform(df.iloc[:, 3:19]) test.iloc[:, 3:19] = sc.transform(test.iloc[:, 3:19]) log.append("Creating playlist vector") playvec = pd.DataFrame(test.sum(axis=0)).T else: df.iloc[:, 3:19] = sc.transform(df.iloc[:, 3:19]) x = i if model == 'Model 1': df['sim']=cosine_similarity(df.drop(['track_uri', 'artist_uri', 'album_uri'], axis = 1),playvec.drop(['track_uri', 'artist_uri', 'album_uri'], axis = 1)) df['sim2']=cosine_similarity(df.iloc[:,16:-1],playvec.iloc[:,16:]) df['sim3']=cosine_similarity(df.iloc[:,19:-2],playvec.iloc[:,19:]) df = df.sort_values(['sim3','sim2','sim'],ascending = False,kind='stable').groupby('artist_uri').head(same_art).head(50) Fresult = pd.concat([Fresult, df], axis=0) Fresult = Fresult.sort_values(['sim3', 'sim2', 'sim'],ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).head(50) elif model == 'Model 2': df['sim'] = cosine_similarity(df.iloc[:, 3:16], playvec.iloc[:, 3:16]) df['sim2'] = cosine_similarity(df.loc[:, df.columns.str.startswith('T') | df.columns.str.startswith('A')], playvec.loc[:, playvec.columns.str.startswith('T') | playvec.columns.str.startswith('A')]) df['sim3'] = cosine_similarity(df.loc[:, df.columns.str.startswith('genre')], playvec.loc[:, playvec.columns.str.startswith('genre')]) df['sim4'] = (df['sim']+df['sim2']+df['sim3'])/3 df = df.sort_values(['sim4'], ascending=False,kind='stable').groupby('artist_uri').head(same_art).head(50) Fresult = pd.concat([Fresult, df], axis=0) Fresult = Fresult.sort_values(['sim4'], ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).head(50) del test try: del df log.append('Getting Result') except: log.append('Getting Result') if model == 'Model 1': Fresult = Fresult.sort_values(['sim3', 'sim2', 'sim'],ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).track_uri.head(50) elif model == 'Model 2': Fresult = Fresult.sort_values(['sim4'], ascending=False,kind='stable') Fresult.drop_duplicates(subset=['track_uri'], inplace=True,keep='first') Fresult = Fresult.groupby('artist_uri').head(same_art).track_uri.head(50) log.append('{} New Tracks Found'.format(len(grow))) if(len(grow)>=1): try: new=pd.read_csv('Data/new_tracks.csv',dtype=dtypes) new=pd.concat([new, grow], axis=0) new=new[new.Track_pop >0] new.drop_duplicates(subset=['track_uri'], inplace=True,keep='last') new.to_csv('Data/new_tracks.csv',index=False) except: grow.to_csv('Data/new_tracks.csv', index=False) log.append('Model run successfully') except Exception as e: log.append("Model Failed") log.append(e) return Fresult, log def update_dataset(): col_name= ['track_uri', 'artist_uri', 'album_uri', 'danceability', 'energy', 'key', 'loudness', 'mode', 'speechiness', 'acousticness', 'instrumentalness', 'liveness', 'valence', 'tempo', 'duration_ms', 'time_signature', 'Track_release_date', 'Track_pop', 'Artist_pop', 'Artist_genres'] dtypes = {'track_uri': 'object', 'artist_uri': 'object', 'album_uri': 'object', 'danceability': 'float16', 'energy': 'float16', 'key': 'float16', 'loudness': 'float16', 'mode': 'float16', 'speechiness': 'float16', 'acousticness': 'float16', 'instrumentalness': 'float16', 'liveness': 'float16', 'valence': 'float16', 'tempo': 'float16', 'duration_ms': 'float32', 'time_signature': 'float16', 'Track_release_date': 'int8', 'Track_pop': 'int8', 'Artist_pop': 'int8', 'Artist_genres': 'object'} df = pd.read_csv('Data/streamlit.csv',dtype=dtypes) grow = pd.read_csv('Data/new_tracks.csv',dtype=dtypes) cur = len(df) df=pd.concat([df,grow],axis=0) grow=pd.DataFrame(columns=col_name) grow.to_csv('Data/new_tracks.csv',index=False) df=df[df.Track_pop >0] df.drop_duplicates(subset=['track_uri'],inplace=True,keep='last') df.dropna(axis=0,inplace=True) df.to_csv('Data/streamlit.csv',index=False) return (len(df)-cur)