I am trying to assign the output from a value\_count to a new df. My code follows.

```
import pandas as pd
import glob

df = pd.concat((pd.read_csv(f, names=['date','bill_id','sponsor_id']) for f in glob.glob('/home/jayaramdas/anaconda3/df/s11?_s_b')))

column_list = ['date', 'bill_id']

df = df.set_index(column_list, drop = True)
df = df['sponsor_id'].value_counts()

df.columns=['sponsor', 'num_bills']
print (df)

```

The value count is not being assigned the column headers specified 'sponsor', 'num\_bills'. I'm getting the following output from print.head

```
1036    426
791     408
1332    401
1828    388
136     335
Name: sponsor_id, dtype: int64

```