Feeli-Song-Csv
Sat 17 May 2025
title: "Feeli Song Collection" author: "Raja CSP Raman" date: 2019-04-20 description: "-" type: technical_note draft: false
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)
df.head()
| 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 |
df.tail()
| 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 |
Score: 5
Category: basics