Save user input to a Excel File in Python

Python | Split given list and insert in excel file

Last Updated : 28 Feb, 2019

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 :

Python3 1==

# Python code to split the list two element 
# at a time and insert it into excel.

# Importing pandas as pd
import pandas as pd

# List initialization
list1 = ['Assam', 'India',
         'Lahore', 'Pakistan', 
         'New York', 'USA',
         'Bejing', 'China']

df = pd.DataFrame()

# Creating two columns
df['State'] = list1[0::2]
df['Country'] = list1[1::2]

# Converting to excel
df.to_excel('result.xlsx', index = False)

Output :

Save user input to a Excel File in Python

everythingispossible

Improve

Article Tags :

Practice Tags :

python

Similar Reads

How to Split a File into a List in Python

In this article, we are going to see how to Split a File into a List in Python.Â When we want each line of the file to be listed at consecutive positions where each line becomes an element in the file, the splitlines() or rstrip() method is used to split a file into a list. Let's see a few examples

Save user input to a Excel File in Python

In this article, we will learn how to store user input in an excel sheet using Python, What is Excel? Excel is a spreadsheet in a computer application that is designed to add, display, analyze, organize, and manipulate data arranged in rows and columns. It is the most popular application for account

How to import an excel file into Python using Pandas?

It is not always possible to get the dataset in CSV format. So, Pandas provides us the functions to convert datasets in other formats to the Data frame. An excel file has a '.xlsx' format.Â Before we get started, Â we need to install a few libraries.Â pip install pandas pip install xlrd Â For importin

How to merge multiple excel files into a single files with Python ?

Normally, we're working with Excel files, and we surely have come across a scenario where we need to merge multiple Excel files into one. The traditional method has always been using a VBA code inside excel which does the job but is a multi-step process and is not so easy to understand. Another meth

Get a list as input from user in Python

We often encounter a situation when we need to take a number/string as input from the user. In this article, we will see how to take a list as input from the user using Python.Get list as input Using split() MethodThe input() function can be combined with split() to accept multiple elements in a sin

How to split a Python list into evenly sized chunks

Iteration in Python is repeating a set of statements until a certain condition is met. This is usually done using a for loop or a while loop. There are several ways to split a Python list into evenly sized-chunks. Here are the 5 main methods: Method 1: Using a Loop with List SlicingUse for loop alon

Python | Arithmetic operations in excel file using openpyxl

Prerequisite: Reading & Writing to excel sheet using openpyxlOpenpyxl is a Python library using which one can perform multiple operations on excel files like reading, writing, arithmetic operations and plotting graphs. Let's see how to perform different arithmetic operations using openpyxl.Â Â =S

Read a file line by line in Python

Python provides built-in functions for creating, writing, and reading files. Two types of files can be handled in Python, normal text files and binary files (written in binary language, 0s, and 1s). In this article, we are going to study reading line by line from a file.ExamplePython# Open the file

Read a CSV into list of lists in Python

In this article, we are going to see how to read CSV files into a list of lists in Python. Method 1: Using CSV moduleWe can read the CSV files into different data structures like a list, a list of tuples, or a list of dictionaries.We can use other modules like pandas which are mostly used in ML appl

How to Filter and save the data as new files in Excel with Python Pandas

Sometimes you will want to filter and save the data as new files in Excel with Python Pandas as it can help you in selective data analysis, data organization, data sharing, etc. In this tutorial, we will learn how to filter and save the data as new files in Excel with Python Pandas. This easy guide