import pandas as pd import os curdir = os.path.abspath('./..') df = pd.read_csv(os.path.join(curdir, 'scraped_data', 'department_all.csv')) df df[['name', 'year', 'net_profit', 'tipp', 'staff_costs', 'financial_costs', 'debt_repayments', 'allocation', 'rsa']].head(n=20)