import pandas as pd
df = pd.read_csv("jams.tsv", sep='\t', error_bad_lines=False)
id_first = df['user_id']
id_series = pd.Series()
for i in id_first.index:
if id_first[i] not in id_series:
id_series.append(id_first[i])
id_series.sample(n=1000)
id_series
sample_df = df[df['user_id'].isin(id_series)]
sample_df.drop(colums=['jam_id', 'creation_date', 'link', 'spotify_uri'])
sample_df['song'] = sample_df['title'] + sample_df['artist']
sample_df.drop(columns=['title', 'artist'])
b'Skipping line 7872: expected 7 fields, saw 8\nSkipping line 11730: expected 7 fields, saw 9\nSkipping line 14131: expected 7 fields, saw 8\nSkipping line 58054: expected 7 fields, saw 8\nSkipping line 58754: expected 7 fields, saw 8\n'
b'Skipping line 847129: expected 7 fields, saw 8\n'
b'Skipping line 1091153: expected 7 fields, saw 8\nSkipping line 1175375: expected 7 fields, saw 8\n'
b'Skipping line 1225935: expected 7 fields, saw 8\nSkipping line 1255357: expected 7 fields, saw 8\nSkipping line 1279671: expected 7 fields, saw 8\n'
b'Skipping line 1330675: expected 7 fields, saw 8\n'
b'Skipping line 1448033: expected 7 fields, saw 8\nSkipping line 1543893: expected 7 fields, saw 8\n'
b'Skipping line 1579569: expected 7 fields, saw 8\nSkipping line 1612448: expected 7 fields, saw 8\n'
b'Skipping line 1784588: expected 7 fields, saw 8\n'
/shared-libs/python3.7/py-core/lib/python3.7/site-packages/ipykernel_launcher.py:6: DeprecationWarning: The default dtype for empty Series will be 'object' instead of 'float64' in a future version. Specify a dtype explicitly to silence this warning.
TypeError: cannot concatenate object of type '<class 'str'>'; only Series and DataFrame objs are valid