image_output_1.png
import csv

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

import csv
import gc
from pathlib import Path
columns = ['tweetcreatedts', 'extractedts', 'userid', 'tweetid', 'text', 'language']
dataframe_collection = []
csvfile = '/kaggle/input/ukraine-russian-crisis-twitter-dataset-1-2-m-rows/UkraineCombinedTweetsDeduped_MAR14.csv.gzip'
df = pd.read_csv(csvfile, compression='gzip', index_col=0, encoding='utf-8', quoting=csv.QUOTE_ALL)
df = df[columns]

df = df[df['language'] == 'en']
df.reset_index(drop=True, inplace=True)
df.shape