i have two columns in a dataframe one has column name and other has no column name how can i name them both on python pandas?

Question

Input

 Fruit 
    Apple   55
    Orange  43

Output

Fruit   Count
Apple   55
Orange  43

I need to rename columns accordingly please help

So need `df.columns = ['Fruit','Count']` ? Or `df = df.reset_index)` first ? — jezrael, Jul 30 '18 at 10:49
OK, what is `print (df.info())` or `print (df.head().to_dict())` ? — jezrael, Jul 30 '18 at 10:52
RangeIndex: 1084 entries, 0 to 1083 Data columns (total 2 columns): Fruit 1084 non-null int64 (Emptycolumn ) 1084 non-null int64 dtypes: int64(2) memory usage: 17.0 KB None — Yog, Jul 30 '18 at 10:53
Yes it's working.df = df.reset_index(name='Count') Please upload as answer — Yog, Jul 30 '18 at 10:54
Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/177012/discussion-between-yogesh-s-p-and-jezrael). — Yog, Jul 30 '18 at 10:56

score 1 · Accepted Answer · answered Jul 30 '18 at 11:11

1

I think need convert Series to DataFrame by:

df = df.reset_index(name='Count')

answered Jul 30 '18 at 11:11

jezrael

1 Answers1