Jul-05-2020, 10:27 AM
(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