Python Forum
Pandas DataFrame visual
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pandas DataFrame visual
#2
(Jul-04-2020, 10:12 PM)Truman Wrote: this is how it looks like:
No it dos not look like this when i run it.
import pandas as pd

area = pd.Series({'California': 423967, 'Texas': 695662,
                  'New York': 141297, 'Florida': 170312,
                  'Illinois': 149995})
pop = pd.Series({'California': 38332521, 'Texas': 26448193,
                 'New York': 19651127, 'Florida': 19552860,
                 'Illinois': 12882135})
data = pd.DataFrame({'area':area, 'pop':pop})

print(data)
Output:
area pop California 423967 38332521 Texas 695662 26448193 New York 141297 19651127 Florida 170312 19552860 Illinois 149995 12882135
So to make in the way it should possible be reset_index() and rename first column.
>>> data = data.reset_index()
>>> data
        index    area       pop
0  California  423967  38332521
1       Texas  695662  26448193
2    New York  141297  19651127
3     Florida  170312  19552860
4    Illinois  149995  12882135
>>> 
>>> data = data.rename(columns={'index': 'States'})
>>> 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  
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
Question [Solved] Formatting cells of a pandas dataframe into an OpenDocument ods spreadsheet Calab 1 1,006 Mar-01-2025, 04:51 AM
Last Post: Calab
  Find duplicates in a pandas dataframe list column on other rows Calab 2 2,569 Sep-18-2024, 07:38 PM
Last Post: Calab
  Find strings by index from a list of indexes in a different Pandas dataframe column Calab 3 1,842 Aug-26-2024, 04:52 PM
Last Post: Calab
  Add NER output to pandas dataframe dg3000 0 1,267 Apr-22-2024, 08:14 PM
Last Post: dg3000
  HTML Decoder pandas dataframe column mbrown009 3 2,902 Sep-29-2023, 05:56 PM
Last Post: deanhystad
  Use pandas to obtain cartesian product between a dataframe of int and equations? haihal 0 2,132 Jan-06-2023, 10:53 PM
Last Post: haihal
  Pandas Dataframe Filtering based on rows mvdlm 0 2,168 Apr-02-2022, 06:39 PM
Last Post: mvdlm
  Pandas dataframe: calculate metrics by year mcva 1 3,592 Mar-02-2022, 08:22 AM
Last Post: mcva
  Pandas dataframe comparing anto5 0 2,006 Jan-30-2022, 10:21 AM
Last Post: anto5
  PANDAS: DataFrame | Replace and others questions moduki1 2 2,803 Jan-10-2022, 07:19 PM
Last Post: moduki1

Forum Jump:

User Panel Messages

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