f15.py

df1 = pd.read_csv("communities.data" , header=None)
def read_header(filename):
    '''
    Given a filename containing headers, extract the headers and assign it to df
    '''

    header_list = []
    with open(filename) as f:
        for line in f:
            if "@attribute" in line:
                header_list.append(line.split(" ")[1])
    return header_list
    
headers = read_header("communities.names")
df1.columns = headers