Python Forum
Pandas DataFrame visual
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandas DataFrame visual
#8
(Jul-08-2020, 08:38 PM)Truman Wrote: After adding print('-' * 50) columns are aligned. Not sure how this code exactly solved the issue
It's the way you combine Series to a DataFrame.
After States will have no index/column only area and pop.
>>> data.columns
Index(['area', 'pop'], dtype='object')
So to fix this use reset_index() and give a name.
>>> data = data.reset_index()
>>> data.columns
Index(['index', 'area', 'pop'], dtype='object')

# Rename to a useful name
data = data.rename(columns={'index': 'States'})

>>> data.columns
Index(['States', 'area', 'pop'], dtype='object')
>>> 
>>> data
       States    area       pop
0  California  423967  38332521
1       Texas  695662  26448193
2    New York  141297  19651127
3     Florida  170312  19552860
4    Illinois  149995  12882135 
There is no problem in doing this way to fix it.
I don't now how data is collect or that you have to combine two pd.Series like this.
There maybe is a way to make usable DataFrame for raw data,
but using reset_index() is a common way to fix thing to a usable DataFrame.
Reply


Messages In This Thread
Pandas DataFrame visual - by Truman - Jul-04-2020, 10:12 PM
RE: Pandas DataFrame visual - by snippsat - Jul-05-2020, 10:27 AM
RE: Pandas DataFrame visual - by Truman - Jul-06-2020, 09:34 PM
RE: Pandas DataFrame visual - by snippsat - Jul-06-2020, 11:33 PM
RE: Pandas DataFrame visual - by Truman - Jul-07-2020, 01:55 PM
RE: Pandas DataFrame visual - by snippsat - Jul-07-2020, 05:11 PM
RE: Pandas DataFrame visual - by Truman - Jul-08-2020, 08:38 PM
RE: Pandas DataFrame visual - by snippsat - Jul-09-2020, 08:43 AM
RE: Pandas DataFrame visual - by hussainmujtaba - Jul-10-2020, 06:11 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Add NER output to pandas dataframe dg3000 0 326 Apr-22-2024, 08:14 PM
Last Post: dg3000
  HTML Decoder pandas dataframe column mbrown009 3 1,170 Sep-29-2023, 05:56 PM
Last Post: deanhystad
  Use pandas to obtain cartesian product between a dataframe of int and equations? haihal 0 1,181 Jan-06-2023, 10:53 PM
Last Post: haihal
  Pandas Dataframe Filtering based on rows mvdlm 0 1,507 Apr-02-2022, 06:39 PM
Last Post: mvdlm
  Pandas dataframe: calculate metrics by year mcva 1 2,422 Mar-02-2022, 08:22 AM
Last Post: mcva
  Pandas dataframe comparing anto5 0 1,319 Jan-30-2022, 10:21 AM
Last Post: anto5
  PANDAS: DataFrame | Replace and others questions moduki1 2 1,891 Jan-10-2022, 07:19 PM
Last Post: moduki1
  PANDAS: DataFrame | Saving the wrong value moduki1 0 1,611 Jan-10-2022, 04:42 PM
Last Post: moduki1
  update values in one dataframe based on another dataframe - Pandas iliasb 2 9,535 Aug-14-2021, 12:38 PM
Last Post: jefsummers
  empty row in pandas dataframe rwahdan 3 2,560 Jun-22-2021, 07:57 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020