Pandas
Read csv without header
pd.read_csv(file_path, header=None, names=['A', 'B', 'C']
Rename columns
df.columns = ['a', 'b'] # Rename all columns
df.rename(columns={'$a': 'a', '$b': 'b'}) # Rename individual columns
Delete columns
df.drop('column_name', axis=1)
Sort
# Ascending
df.sort_values('column_name')
# Descending
df.sort_values('column_name', ascending=False)
Show more rows/columns
pd.set_option('display.max_rows', 500)
pd.set_option('display.width', None)
pd.set_option('display.max_columns', None)
Drop duplicates
df.drop_duplicates(subset=['A', 'B'])