{"id":3645,"date":"2023-10-23T07:55:30","date_gmt":"2023-10-23T02:25:30","guid":{"rendered":"https:\/\/python-programs.com\/?p=3645"},"modified":"2023-11-10T11:56:08","modified_gmt":"2023-11-10T06:26:08","slug":"python-pandas-how-to-create-dataframe-from-dictionary","status":"publish","type":"post","link":"https:\/\/python-programs.com\/python-pandas-how-to-create-dataframe-from-dictionary\/","title":{"rendered":"Python Pandas : How to create DataFrame from dictionary ?"},"content":{"rendered":"
In this article we will discuss about various ways of creating DataFrame object from dictionaries.<\/p>\n
So, let’s start exploring different approaches to achieve this result.<\/p>\n
Want to expert in the python programming language? Exploring Python Data Analysis using Pandas<\/a> tutorial changes your knowledge from basic to advance level in python concepts.<\/p>\n In python DataFrame constructor accepts n-D array, dictionaries etc.<\/p>\n All keys in dictionary are converted to column name and values in dictionaries converted column data.<\/p>\n By passing index list, we can avoid the default index.<\/p>\n By skipping some of the items of dictionary, we can also create a DataFrame object from dictionary<\/p>\n Let’s see the implementation of that.<\/p>\n DataFrame can also be created from dictionary using It accepts orientation too, where we can pass the orientation as index then the keys which were used as columns during creating DataFrame now they will be used as index.<\/p>\n Let’s see the implementation of that.<\/p>\n Suppose we have a nested dictionary, then we ill directly pass it in DataFrame constructor where the keys of dictionary will be used as column.<\/p>\n Let’s see the implementation of that.<\/p>\n Read more Articles on Python Data Analysis Using Padas – Creating Dataframe Objects<\/strong>:<\/p>\n How to create DataFrame from dictionary in Python ? In this article we will discuss about various ways of creating DataFrame object from dictionaries. So, let’s start exploring different approaches to achieve this result. Create DataFrame from Dictionary using default Constructor Create DataFrame from Dictionary with custom indexes Create DataFrame from Dictionary and skip data …<\/p>\n<\/a>Method-1 : Create DataFrame from Dictionary using default Constructor :<\/h3>\n
Syntax : pandas.<\/span>DataFrame<\/span>(<\/span>data=<\/span>None<\/span>, index=<\/span>None<\/span>, columns=<\/span>None<\/span>, dtype=<\/span>None<\/span>, copy=<\/span>False<\/span>)<\/span><\/pre>\n
#program :\r\n\r\n# import pandas library\r\nimport pandas as pd\r\n \r\n# dictionary with list object in values\r\ndata = {\r\n 'Name' : ['Satya', 'Omm', 'Rakesh'],\r\n 'Age' : [21, 21, 23],\r\n 'From' : ['BBSR', 'RKL', 'KDP']\r\n}\r\n \r\n# creating a Dataframe object \r\ndf_obj = pd.DataFrame(data)\r\n \r\ndf_obj\r\n\r\n\r\n<\/pre>\n
Output :\r\n\r\n \u00a0 \u00a0 \u00a0 \u00a0Name\u00a0 \u00a0 Age\u00a0 \u00a0From\r\n0\u00a0 \u00a0 \u00a0 Satya\u00a0 \u00a0 \u00a0 21\u00a0 \u00a0 \u00a0 BBSR\r\n1 Omm 21 RKL\r\n2 Rakesh 23 KDP<\/pre>\n
<\/a>Method-2 : Create DataFrame from Dictionary with custom indexes :<\/h3>\n
#program :\r\n\r\n# import pandas library\r\nimport pandas as pd\r\n \r\n# dictionary with list object in values\r\ndata = {\r\n 'Name' : ['Satya', 'Omm', 'Rakesh'],\r\n 'Age' : [21, 21, 23],\r\n 'From' : ['BBSR',\u00a0'RKL',\u00a0'KDP']\r\n}\r\n \r\n# creating a Dataframe object \r\ndf_obj = pd.DataFrame(data, index = ['a','b','c'])\r\n \r\ndf_obj\r\n\r\n<\/pre>\n
Output :\r\n\u00a0 \u00a0 \u00a0 \u00a0 Name\u00a0 \u00a0 Age\u00a0 \u00a0 \u00a0From\r\na\u00a0 \u00a0 \u00a0 Satya\u00a0 \u00a0 \u00a0 21\u00a0 \u00a0 \u00a0 BBSR\r\nb\u00a0 \u00a0 \u00a0Omm\u00a0 \u00a0 \u00a0 \u00a021\u00a0 \u00a0 \u00a0RKL\r\nc\u00a0 \u00a0 \u00a0Rakesh\u00a0 \u00a0 \u00a023\u00a0 \u00a0 \u00a0KDP<\/pre>\n
<\/a>Method-3 : Create DataFrame from Dictionary and skip data<\/h3>\n
#program :\r\n\r\n# import pandas library\r\nimport pandas as pd\r\n \r\n# dictionary with list object in values\r\ndata = {\r\n 'Name' : ['Satya', 'Omm', 'Rakesh'],\r\n 'Age' : [21, 21, 23],\r\n 'From' : ['BBSR',\u00a0'RKL',\u00a0'KDP']\r\n}\r\n \r\n# creating a Dataframe object \r\n#items skipped with key 'Age'\r\ndf_obj = pd.DataFrame(data, columns=['name', 'From'])\r\n \r\ndf_obj\r\n\r\n\r\n<\/pre>\n
Output :\r\n\u00a0 \u00a0 \u00a0 \u00a0Name\u00a0 \u00a0 \u00a0 \u00a0 From\r\n0\u00a0 \u00a0 \u00a0 Satya\u00a0 \u00a0 \u00a0 \u00a0 BBSR\r\n1\u00a0 \u00a0 \u00a0Omm\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 RKL\r\n2\u00a0 \u00a0 \u00a0Rakesh\u00a0 \u00a0 \u00a0 \u00a0KDP<\/pre>\n
<\/a>Method-4 : Create DataFrame from Dictionary with different Orientation<\/h3>\n
DataFrame.from_dict()<\/code> function.<\/p>\n
DataFrame.<\/span>from_dict<\/span>(<\/span>data, orient=<\/span>'columns'<\/span>, dtype=<\/span>None<\/span>)<\/span><\/pre>\n
#program :\r\n\r\n# import pandas library\r\nimport pandas as pd\r\n \r\n# dictionary with list object in values\r\ndata = {\r\n 'Name' : ['Satya', 'Omm', 'Rakesh'],\r\n 'Age' : [21, 21, 23],\r\n 'From' : ['BBSR',\u00a0'RKL',\u00a0'KDP']\r\n}\r\n \r\n# creating a Dataframe object \r\n#items skipped with key 'Age'\r\ndf_obj = pd.DataFrame(data,orient='index')\r\n \r\ndf_obj\r\n\r\n\r\n<\/pre>\n
Output :\r\n\r\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 0<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2<\/span>\r\n\r\nAame\u00a0 \u00a0Satya\u00a0 \u00a0Omm\u00a0 \u00a0 \u00a0Rakesh<\/span>\r\n\r\nFrom\u00a0 \u00a0 \u00a0BBSR\u00a0 \u00a0 RKL\u00a0 \u00a0 \u00a0 \u00a0KDP<\/span>\r\n\r\nAge\u00a0 \u00a0 \u00a0 \u00a021\u00a0 \u00a0 \u00a0 \u00a0 \u00a021\u00a0 \u00a0 \u00a0 \u00a0 \u00a023<\/span><\/pre>\n
<\/a>Method-5 : Create DataFrame from nested Dictionary :<\/h3>\n
#program :\r\n\r\n# import pandas library\r\nimport pandas as pd\r\n \r\n# dictionary with list object in values\r\n# Nested Dictionary\r\ndata = { \r\n0 : {\r\n 'Name' : 'Satya',\r\n 'Age' : 21,\r\n 'From' : 'BBSR'\r\n },\r\n1 : {\r\n 'Name' : 'Omm',\r\n 'Age' : 21,\r\n 'From' : 'RKL'\r\n },\r\n2 : {\r\n 'Name' : 'Rakesh',\r\n 'Age' : 23,\r\n 'From' : 'KDP'\r\n }\r\n}\r\n \r\n# creating a Dataframe object \r\n#items skipped with key 'Age'\r\ndf_obj = pd.DataFrame(data)\r\n \r\ndf_obj\r\n\r\n<\/pre>\n
Output :\r\n \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 0<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a01<\/span>\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 2<\/span>\r\nAame\u00a0 \u00a0Satya\u00a0 \u00a0Omm\u00a0 \u00a0 \u00a0Rakesh<\/span>\r\nFrom\u00a0 \u00a0 \u00a0BBSR\u00a0 \u00a0 RKL\u00a0 \u00a0 \u00a0 \u00a0KDP<\/span>\r\nAge\u00a0 \u00a0 \u00a0 \u00a021\u00a0 \u00a0 \u00a0 \u00a0 \u00a021\u00a0 \u00a0 \u00a0 \u00a0 \u00a023<\/span><\/pre>\n
\n