from io import BytesIO
import requests
import pandas as pd
filename = 'https://docs.google.com/spreadsheet/ccc?key=1EfyD7A4YcdAzTfUO0t3yQ0HawetVF5pefS5pPyGVX4g&output=csv'
r = requests.get(filename)
data = r.content
df = pd.read_csv(BytesIO(data), index_col=0)
|
Song Name |
Language |
YouTube link |
Genre |
Artist |
Emotion Tag |
Emotion |
Hint |
Geo Location |
Lyrics |
Collector |
S. NO |
|
|
|
|
|
|
|
|
|
|
|
1.0 |
Classified - Inner |
English |
https://www.youtube.com/watch?v=NGhyL8zg3_I |
NaN |
NaN |
NaN |
Gives me some kind of confidence; Relaxed Cana... |
NaN |
NaN |
NaN |
Raja |
2.0 |
Avicii - Wake Me Up |
English |
https://www.youtube.com/watch?v=IcrbM1l_BoI |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
Raja |
3.0 |
Ziroq - Que Pena |
NaN |
https://www.youtube.com/watch?v=Ws_5XC1qqpo |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
Raja |
4.0 |
Koko show |
Finnish |
https://www.youtube.com/watch?v=pmbWpPztg8Y |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
Raja |
5.0 |
Daniel Powter |
English |
https://www.youtube.com/watch?v=gH476CxJxfg |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
NaN |
Raja |
|
Song Name |
Language |
YouTube link |
Genre |
Artist |
Emotion Tag |
Emotion |
Hint |
Geo Location |
Lyrics |
Collector |
S. NO |
|
|
|
|
|
|
|
|
|
|
|
637.0 |
Chogada |
Gujarathi |
https://youtu.be/BzcKINXf-rs |
NaN |
NaN |
NaN |
Let's garba ! |
NaN |
NaN |
NaN |
Fatema |
638.0 |
The breakup song |
Hindi |
https://www.youtube.com/watch?v=kd5KqlmcHNo |
NaN |
NaN |
NaN |
After breakup scene . |
NaN |
NaN |
NaN |
Fatema |
639.0 |
Raat kamaal hai |
Punjabi |
https://www.youtube.com/watch?v=aNwWdF8qq-M |
NaN |
NaN |
NaN |
It's party time ! |
NaN |
NaN |
NaN |
Fatema |
640.0 |
Naah |
Punjabi |
https://www.youtube.com/watch?v=8qs2dZO6wcc |
NaN |
NaN |
NaN |
Savage life . |
NaN |
NaN |
NaN |
Fatema |
641.0 |
Ever hit bollywood song mashup by Aksh baghla |
Hindi |
https://youtu.be/XvT0YoPDlCA |
NaN |
NaN |
NaN |
Mashup mood ON !! |
NaN |
NaN |
NaN |
Fatema |