import pandas as pd

cols = ['ID', 'img', 'title']

df = pd.read_csv(r'C:\Users\Ryan\metacritic\comments_metacritic_en.csv')
df.loc[:,cols] = df.loc[:,cols].ffill()
df = df.dropna()
df = df.drop_duplicates()
df.to_csv('output.csv',index=False)
e700b6bad20a79656d586dad36c2ca47dc3ef3d3
<mask token>

<mask token>
df.to_csv('output.csv', index=False)

<mask token>
cols = ['ID', 'img', 'title']
df = pd.read_csv('C:\\Users\\Ryan\\metacritic\\comments_metacritic_en.csv')
df.loc[:, cols] = df.loc[:, cols].ffill()
df = df.dropna()
df = df.drop_duplicates()
df.to_csv('output.csv', index=False)

import pandas as pd
cols = ['ID', 'img', 'title']
df = pd.read_csv('C:\\Users\\Ryan\\metacritic\\comments_metacritic_en.csv')
df.loc[:, cols] = df.loc[:, cols].ffill()
df = df.dropna()
df = df.drop_duplicates()
df.to_csv('output.csv', index=False)

import pandas as pd

cols = ['ID', 'img', 'title']

df = pd.read_csv(r'C:\Users\Ryan\metacritic\comments_metacritic_en.csv')
df.loc[:,cols] = df.loc[:,cols].ffill()
df = df.dropna()
df = df.drop_duplicates()
df.to_csv('output.csv',index=False)