Python:- How to create Csv from Excel(for specific columns)

Question

I want to Create Csv from Excel but only with two specific columns.

csv_file = open(csv_file_path, 'w+')
wr = csv.writer(csv_file, quoting=csv.QUOTE_ALL)

for row_num in xrange(sh.nrows):
  wr.writerow(sh.row_values(row_num))

This Script is Writing all rows of sh sheet into Csv file, i want to write only specific columns into my csv with Header "Id" and "Price" .??

Boendal · Accepted Answer · 2019-12-19 13:44:42Z

1

If you don't know the indeces you can do it this way:

import xlrd

wb = xlrd.open_workbook("myfile.xlsx")
sh = wb.sheet_by_index(0)

headers = ['Price', 'Id']
headers_index = []

for index,column in enumerate(sh.row_values(0)):
    if column in headers:
        if column in headers:
            headers_index.append(index)


for row_num in range(sh.nrows):
    output = [sh.row_values(row_num)[x] for x in headers_index]
    wr.writerow(output)

I assume that the headers are in the first row.

edited Dec 19, 2019 at 13:44

answered Dec 19, 2019 at 11:13

Boendal

2,5162 gold badges25 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Boendal Over a year ago

@EMp1 I added the part of the code in which I create the sh object. It works for me. How do you create it? that should work (Python 3)

DHANANJAY RAUT · Accepted Answer · 2019-12-19 10:59:37Z

1

csv_file = open(csv_file_path, 'w+')
wr = csv.writer(csv_file, quoting=csv.QUOTE_ALL)

for row_num in xrange(sh.nrows):
  row = sh.row_values(row_num)
  wr.writerow([row[3], row[4]])

here 3 and 4 are index for columns Id and Price.

answered Dec 19, 2019 at 10:59

DHANANJAY RAUT

19010 bronze badges

Comments

hithyshi · Accepted Answer · 2019-12-19 11:00:02Z

1

Try that for exporting the 3rd and 4th column as an example

for row_num in xrange(sh.nrows): 
     wr.writerow([sh.cell(row_num, 2).value, sh.cell(row_num, 3).value])

reference : Selecting multiple specific columns in excel and exporting to CSV using Python

answered Dec 19, 2019 at 11:00

hithyshi

7231 gold badge5 silver badges11 bronze badges

Collectives™ on Stack Overflow

Python:- How to create Csv from Excel(for specific columns)

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related