{"id":3653,"date":"2023-10-23T07:55:53","date_gmt":"2023-10-23T02:25:53","guid":{"rendered":"https:\/\/python-programs.com\/?p=3653"},"modified":"2023-11-10T11:55:45","modified_gmt":"2023-11-10T06:25:45","slug":"python-pandas-how-to-convert-lists-to-a-dataframe","status":"publish","type":"post","link":"https:\/\/python-programs.com\/python-pandas-how-to-convert-lists-to-a-dataframe\/","title":{"rendered":"Python Pandas : How to convert lists to a dataframe"},"content":{"rendered":"
As we know in python, lists are used to store multiple values in an ordered sequence inside a single variable.\u00a0 Each element inside the list is called an item.<\/p>\n
Syntax : my_list = [ element1, element2, element3, .....]<\/pre>\nwhere,<\/p>\n
[].<\/code><\/li>\n- items are separated by , symbol.<\/li>\n
- It can contain any number of items.<\/li>\n
- elements can be of different types i.e string, float, integer etc.<\/li>\n<\/ul>\n
The pandas library is one of the most preferred tool to do data manipulation and analysis.<\/p>\n
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>\nCreating DataFrame from list of lists :<\/strong><\/h3>\nNow, let\u2019s take an example.<\/p>\n
#program :\r\n\r\nimport\u00a0pandas\u00a0as\u00a0pd\r\n#List of list\r\nData=[[\u2018apple\u2019, \u2018banana\u2019, \u2018orange\u2019],[\u2018dog\u2019, \u2018cat\u2019, \u2018cow\u2019],[\u2018potato\u2019, \u2018tomato\u2019, \u2018onion\u2019]]\r\n#creating a dataframe object from list of list\r\ndf=pd.DataFrame(Data)\r\n<\/pre>\nOutput:\r\n \u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\r\n0\u00a0 apple\u00a0\u00a0 banana\u00a0 orange\r\n1\u00a0 dog\u00a0\u00a0\u00a0\u00a0 cat\u00a0\u00a0\u00a0\u00a0 cow\r\n2\u00a0 potato\u00a0 tomato\u00a0 onion<\/pre>\nCreating DataFrame from list of tuples :<\/strong><\/h3>\nNow, let\u2019s take an example.<\/p>\n
#Program\r\n\r\nimport\u00a0pandas\u00a0as\u00a0pd\r\n#List of tuples\r\nData=[(\u2018apple\u2019, \u2018banana\u2019, \u2018orange\u2019),(\u2018dog\u2019, \u2018cat\u2019, \u2018cow\u2019),(\u2018potato\u2019, \u2018tomato\u2019, \u2018onion\u2019)]\r\n#creating a dataframe object from list of tuples\r\ndf=pd.DataFrame(Data)\r\n<\/pre>\nOutput:\r\n \u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\r\n0\u00a0 apple\u00a0\u00a0 banana\u00a0 orange\r\n1\u00a0 dog\u00a0\u00a0\u00a0\u00a0 cat\u00a0\u00a0\u00a0\u00a0 cow\r\n2\u00a0 potato\u00a0 tomato\u00a0 onion<\/pre>\nConverting list of tuples to dataframe and set column names and indexes :<\/strong><\/h3>\nWe can also make the column and index names.<\/p>\n
#Program \r\n\r\n\r\nimport\u00a0pandas\u00a0as\u00a0pd\r\n#List of tuples \r\nData=[(\u2018apple\u2019, \u2018banana\u2019, \u2018orange\u2019),(\u2018dog\u2019, \u2018cat\u2019, \u2018cow\u2019),(\u2018potato\u2019, \u2018tomato\u2019, \u2018onion\u2019)] \r\n#Converting list of tuples to dataframe and set column names and indexes \r\ndf=pd.DataFrame(Data, columns=[\u2018a\u2019, \u2018b\u2019, \u2018c\u2019], index=[\u2018fruits\u2019, \u2018animals\u2019, \u2018vegetables\u2019])<\/pre>\nOutput:\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\r\nfruits\u00a0\u00a0\u00a0\u00a0\u00a0 apple\u00a0\u00a0 banana\u00a0 orange\r\nanimals\u00a0\u00a0\u00a0\u00a0 dog\u00a0\u00a0\u00a0\u00a0 cat\u00a0\u00a0\u00a0\u00a0 cow\r\nvegetables\u00a0 potato\u00a0 tomato\u00a0 onion<\/pre>\nWe can also skip one more than one columns like we have 3 rows and 3 columns<\/p>\n
This can be used when you don\u2019t need a column<\/p>\n
so let\u2019s try removing 1 column.<\/p>\n
#Program \r\n\r\nimport\u00a0pandas\u00a0as\u00a0pd\r\n#List of tuples \r\nData=[(\u2018apple\u2019, \u2018banana\u2019, \u2018orange\u2019),(\u2018dog\u2019, \u2018cat\u2019, \u2018cow\u2019),(\u2018potato\u2019, \u2018tomato\u2019, \u2018onion\u2019)] \r\n#Converting list of tuples to dataframe and set column names and indexes \r\ndf=pd.DataFrame(Data, exclude=[\u20182\u2019], columns=[\u2018a\u2019, \u2018b\u2019, \u2018c\u2019], index=[\u2018fruits\u2019, \u2018animals\u2019, \u2018vegetables\u2019])<\/pre>\nOutput:\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\r\nfruits\u00a0\u00a0\u00a0\u00a0\u00a0 apple\u00a0\u00a0 banana\r\nanimals\u00a0\u00a0\u00a0\u00a0 dog\u00a0\u00a0\u00a0\u00a0 cat\r\nvegetables\u00a0 potato\u00a0 tomato<\/pre>\nCreating a dataframe from multiple lists :<\/h3>\n
We can also create a dataframe by giving multiple multiple lists.<\/p>\n
Let\u2019s try this:<\/p>\n
#Program :\r\n\r\nimport\u00a0pandas\u00a0as\u00a0pd\r\nroll_no = [1, 2, 3]\r\nname = [\u2018Tia\u2019, \u2018Raj\u2019, \u2018Rahul\u2019]\r\nstate = [\u2018Goa\u2019, \u2019Assam\u2019, \u2018Punjab\u2019]\r\nwrapoflist = list(zip(roll_no, name, state))\r\ndf = pd.DataFrame(wrapoflist, column=[\u2018roll_no\u2019, \u2018name\u2019, \u2018state\u2019], index=[\u2018a\u2019, \u2018b\u2019, \u2018c\u2019])\r\n<\/pre>\nOutput:\r\n \u00a0 roll_no\u00a0 name\u00a0\u00a0\u00a0 state\r\na\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0 Tia\u00a0\u00a0\u00a0 \u00a0\u00a0 Goa\r\nb\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0 Raj\u00a0\u00a0\u00a0 Assam\r\nc\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3\u00a0\u00a0 Rahul\u00a0 Punjab<\/pre>\nWant to expert in the python programming language? Exploring\u00a0Python Data Analysis using Pandas<\/a>\u00a0tutorial changes your knowledge from basic to advance level in python concepts.<\/p>\n\n- How to create DataFrame from a dictionary?<\/a><\/li>\n
- How to create an empty DataFrame and add data to it later?<\/a><\/li>\n
- How to read a csv file to Dataframe with custom delimiter?<\/a><\/li>\n
- How to skip rows while reading csv file to a Dataframe using read_csv()?<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
How to convert lists to a dataframe in python ? As we know in python, lists are used to store multiple values in an ordered sequence inside a single variable.\u00a0 Each element inside the list is called an item. Syntax : my_list = [ element1, element2, element3, …..] where, elements\/items are placed inside square brackets …<\/p>\n