Change language

Python | Split given list and paste into Excel file

| |

We can use a very popular library for data analysis, Pandas. Using pandas, we can easily manipulate the columns and just insert the filtered items into the Excel file using the df.to_excel () function.

Below is the implementation:

Output:

Shop

Learn programming in R: courses

$

Best Python online courses for 2022

$

Best laptop for Fortnite

$

Best laptop for Excel

$

Best laptop for Solidworks

$

Best laptop for Roblox

$

Best computer for crypto mining

$

Best laptop for Sims 4

$

Latest questions

NUMPYNUMPY

psycopg2: insert multiple rows with one query

12 answers

NUMPYNUMPY

How to convert Nonetype to int or string?

12 answers

NUMPYNUMPY

How to specify multiple return types using type-hints

12 answers

NUMPYNUMPY

Javascript Error: IPython is not defined in JupyterLab

12 answers


Wiki

Python OpenCV | cv2.putText () method

numpy.arctan2 () in Python

Python | os.path.realpath () method

Python OpenCV | cv2.circle () method

Python OpenCV cv2.cvtColor () method

Python - Move item to the end of the list

time.perf_counter () function in Python

Check if one list is a subset of another in Python

Python os.path.join () method

# Python code to split the list into two elements
# and paste it into Excel.

 
# Import pandas as pd

import pandas as pd

  
# Initialization list

list1 = [ ’ Assam’ , ’India’ ,

  ’ Lahore’ , ’Pakistan’

’New York’ , ’USA’ ,

’Bejing’ , ’ China’ ]

 

df = pd.DataFrame ()

 
# Create two columns

df [ ’State’ ] = list1 [ 0 :: 2 ]

df [ ’Country’ ] = list1 [ 1 :: 2 ]

 
# Excel conversion

df.to_excel ( ’result.xlsx’ , index = False )