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 :
- Reading an excel file using Python
- Python | Excel File Comparison
- Python | Reading an excel file using openpyxl module
- Python | Writing to an excel file using openpyxl module
- Python | Arithmetic operations in excel file using openpyxl
- Python | Trigonometric operations in excel file using openpyxl
- Python | Pandas Split strings into two List/Columns using str.split()
- Python | Create and write on excel file using xlsxwriter module
- Python | Adjusting rows and columns of an excel file using openpyxl module
- Python list | insert()
- Python | Split list into lists by particular value
- Python | Custom list split
- Python | Insert after every Nth element in a list
- Python | Split string into list of characters
- Python | Split a list into sublists of given lengths
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.