{"id":112192,"date":"2020-04-29T09:47:43","date_gmt":"2020-04-29T09:47:43","guid":{"rendered":"https:\/\/blog.finxter.com\/?p=8027"},"modified":"2020-04-29T09:47:43","modified_gmt":"2020-04-29T09:47:43","slug":"pandas-to_csv","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2020\/04\/29\/pandas-to_csv\/","title":{"rendered":"Pandas to_csv()"},"content":{"rendered":"
\"Pandas<\/figure>\n

You can convert a list of lists to a Pandas<\/a> DataFrame that provides you with powerful capabilities such as the to_csv()<\/code> method<\/a>. This is the easiest method and it allows you to avoid importing yet another library<\/strong> (I use Pandas in many Python projects anyways). <\/p>\n

salary = [['Alice', 'Data Scientist', 122000], ['Bob', 'Engineer', 77000], ['Ann', 'Manager', 119000]] # Method 2\nimport pandas as pd\ndf = pd.DataFrame(salary)\ndf.to_csv('file2.csv', index=False, header=False)<\/pre>\n
Output:<\/p>\n
# file2.csv<\/em><\/strong>\nAlice,Data Scientist,122000\nBob,Engineer,77000\nAnn,Manager,119000<\/pre>\n
You create a Pandas DataFrame—which is Python’s default representation of tabular data. Think of it as an Excel spreadsheet within your code (with rows and columns). <\/p>\n
The DataFrame is a very powerful data structure that allows you to perform various methods. One of those is the to_csv()<\/code> method that allows you to write its contents into a CSV file.<\/p>\n
You set the index<\/code> and header<\/code> arguments of the to_csv()<\/code> method to False<\/code> because Pandas, per default, adds integer row and column indices 0, 1, 2, …. Again, think of them as the row and column indices in your Excel spreadsheet. You don’t want them to appear in the CSV file so you set the arguments to False<\/code>. <\/p>\n
If you want to customize the CSV output, you’ve got a lot of special arguments to play with. Check out this <\/a>article for a comprehensive list of all arguments.<\/p>\n
Related article<\/strong>: Pandas Cheat Sheets to Pin to Your Wall<\/a><\/p>\n
Feel free to play with alternative methods to convert a list of lists to a CSV file <\/a>in our interactive code shell. Simply click the “Run” button and find the generated CSV files in the “Files” tab. <\/p>\n