Given a list containing Names and Addresses consecutively, the task is to split these two elements at a time and insert it into excel.
We can use a very popular library for data analysis, Pandas. Using pandas we can easily manipulate the columns and simply insert the filtered elements into excel file using df.to_excel() function.
Below is the implementation :
# Python code to split the list two element # at a time and insert it into excel. # Importing pandas as pdimport pandas as pd # List initializationlist1 = ['Assam', 'India', 'Lahore', 'Pakistan', 'New York', 'USA', 'Bejing', 'China'] df = pd.DataFrame() # Creating two columnsdf['State'] = list1[0::2]df['Country'] = list1[1::2] # Converting to exceldf.to_excel('result.xlsx', index = False) |
Output :
… [Trackback]
[…] Find More here on that Topic: geeksforgeeks.org/python-split-given-list-and-insert-in-excel-file/ […]
… [Trackback]
[…] Information on that Topic: geeksforgeeks.org/python-split-given-list-and-insert-in-excel-file/ […]
… [Trackback]
[…] Read More here on that Topic: geeksforgeeks.org/python-split-given-list-and-insert-in-excel-file/ […]