add a series as a column in data frame with custom name code example

Example: how to add column headers in pandas

#suppose team is a df that has unnamed columns (0,1...)
team.columns =['Name', 'Code', 'Age', 'Weight']