How to convert list to dataframe in python
|
How to Convert List of Lists to a Pandas Dataframe Show Problem: You’re given a list of lists. Your goal is to convert it into a Pandas Dataframe. Example: Say, you want to compare salary data of different companies and job descriptions. You’ve obtained the following salary data set as a list of list: salary = [['Google', 'Machine Learning Engineer', 121000],
['Google', 'Data Scientist', 109000],
['Google', 'Tech Lead', 129000],
['Facebook', 'Data Scientist', 103000]]How can you convert this into a Pandas Dataframe?
Solution: The straight-forward solution is to use the Here’s how to do it for the given example: import pandas as pd
salary = [['Google', 'Machine Learning Engineer', 121000],
['Google', 'Data Scientist', 109000],
['Google', 'Tech Lead', 129000],
['Facebook', 'Data Scientist', 103000]]
df = pd.DataFrame(salary)This results in the following Dataframe: print(df)
'''
0 1 2
0 Google Machine Learning Engineer 121000
1 Google Data Scientist 109000
2 Google Tech Lead 129000
3 Facebook Data Scientist 103000
'''Try It Yourself: Run this code in our interactive Python shell by clicking the “Run” button. DataFrame.from_records()An alternative is the import pandas as pd
salary = [['Company', 'Job', 'Salary($)'],
['Google', 'Machine Learning Engineer', 121000],
['Google', 'Data Scientist', 109000],
['Google', 'Tech Lead', 129000],
['Facebook', 'Data Scientist', 103000]]
df = pd.DataFrame.from_records(salary)
print(df)
'''
0 1 2
0 Google Machine Learning Engineer 121000
1 Google Data Scientist 109000
2 Google Tech Lead 129000
3 Facebook Data Scientist 103000
'''
Try It Yourself: Run this code in our interactive Python shell by clicking the “Run” button. Column NamesIf you want to add column names to make the output prettier, you can also pass those as a separate argument: import pandas as pd
salary = [['Google', 'Machine Learning Engineer', 121000],
['Google', 'Data Scientist', 109000],
['Google', 'Tech Lead', 129000],
['Facebook', 'Data Scientist', 103000]]
df = pd.DataFrame(salary, columns=['Company', 'Job', 'Salary($)'])
print(df)
'''
Company Job Salary($)
0 Google Machine Learning Engineer 121000
1 Google Data Scientist 109000
2 Google Tech Lead 129000
3 Facebook Data Scientist 103000
'''Try It Yourself: Run this code in our interactive Python shell by clicking the “Run” button. If the first list of the list of lists contains the column name, use slicing to separate the first list from the other lists: import pandas as pd
salary = [['Company', 'Job', 'Salary($)'],
['Google', 'Machine Learning Engineer', 121000],
['Google', 'Data Scientist', 109000],
['Google', 'Tech Lead', 129000],
['Facebook', 'Data Scientist', 103000]]
df = pd.DataFrame(salary[1:], columns=salary[0])
print(df)
'''
Company Job Salary($)
0 Google Machine Learning Engineer 121000
1 Google Data Scientist 109000
2 Google Tech Lead 129000
3 Facebook Data Scientist 103000
'''Slicing is a powerful Python feature and before you can master Pandas, you need to master slicing. To refresh your Python slicing skills, download my ebook “Coffee Break Python Slicing” for free. Summary: To convert a list of lists into a Pandas DataFrame, use the Programmer HumorThere are only 10 kinds of people in this world: those who know binary and those who don’t. There are 10 types of people in the world. Those who understand trinary, those who don’t, and those who mistake it for binary. 👩🧔♂️👱♀️ Where to Go From Here?Enough theory. Let’s get some practice! Coders get paid six figures and more because they can solve problems more effectively using machine intelligence and automation. To become more successful in coding, solve more real problems for real people. That’s how you polish the skills you really need in practice. After all, what’s the use of learning theory that nobody ever needs? You build high-value coding skills by working on practical coding projects! Do you want to stop learning with toy projects and focus on practical code projects that earn you money and solve real problems for people? 🚀 If your answer is YES!, consider becoming a Python freelance developer! It’s the best way of approaching the task of improving your Python skills—even if you are a complete beginner. If you just want to learn about the freelancing opportunity, feel free to watch my free webinar “How to Build Your High-Income Skill Python” and learn how I grew my coding business online and how you can, too—from the comfort of your own home. Join the free webinar now!  While working as a researcher in distributed systems, Dr. Christian Mayer found his love for teaching computer science students. To help students reach higher levels of Python success, he founded the programming education website Finxter.com. He’s author of the popular programming book Python One-Liners (NoStarch 2020), coauthor of the Coffee Break Python series of self-published books, computer science enthusiast, freelancer, and owner of one of the top 10 largest Python blogs worldwide. His passions are writing, reading, and coding. But his greatest passion is to serve aspiring coders through Finxter and help them to boost their skills. You can join his free email academy here. Can you convert a list to DataFrame in Python?We can create data frames using lists in the dictionary.
How do I convert a list to a DataFrame row in Python?Here we are passing the individual lists which act as columns in the data frame to keys to the dictionary, so by passing the dictionary into dataframe() we can convert list to dataframe. These keys will be the column names in the dataframe. Example: Python3.
How do I convert a list to a DataFrame column in Python?tolist() you can convert pandas DataFrame Column to List. df['Courses'] returns the DataFrame column as a Series and then use values. tolist() to convert the column values to list.
How do I convert a list to pandas?Since there is no method to convert pandas. DataFrame , pandas. Series directly to list , first get the NumPy array ndarray with the values attribute, and then use tolist() method to convert to list . The values attribute does not include labels (row/column names).
|
