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'])