Breaking News: Grepper is joining You.com. Read the official announcement!

insert list in excel python

Vraj Patel answered on December 26, 2022 Popularity 9/10 Helpfulness 2/10

answer insert list in excel python

insert list in excel python

Comment

# 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)

Popularity 9/10 Helpfulness 2/10 Language python

Source: www.geeksforgeeks.org

Tags: excel insert list python

Link to this answer
Share Copy Link