How to save a tuple to excel in python

Question

I have fetched some data from an application and the output is in tuple.

deals

(   

  Instrument Date Announced  SDC Deal No
 0  154085693165     2020-07-16   3577020040
 1  154086829977     2020-07-16   3603239040
 2  154086830011     2020-07-16   3603259040
 3  154086830078     2020-07-16   3603284040
 4  154086830341     2020-07-16   3603413040,
 None)

How do i save this to an xlsx file using python?

This might be useful: pandas.pydata.org/pandas-docs/stable/reference/api/… — zabop
– zabop, Commented Jul 16, 2020 at 10:34
Please add what you have tried so far. Stack Over Flow is not a people write code for you for free. — user13838641
– user13838641, Commented Jul 16, 2020 at 10:34

Alan003 · Accepted Answer · 2020-07-17 08:25:28Z

2

The tuple returns 2 values. One with the data frame and other with any error. In this case. So the below code helps.

datframe,error=ek.function_name(argument1,argument2,...)

or,

deals,e=ek.get_data(common_name,company_id)

So now

print(deals) returns

Instrument Date Announced  SDC Deal No
 0  154085693165     2020-07-16   3577020040
 1  154086829977     2020-07-16   3603239040
 2  154086830011     2020-07-16   3603259040
 3  154086830078     2020-07-16   3603284040
 4  154086830341     2020-07-16   3603413040

and print(e) returns

none

answered Jul 17, 2020 at 8:25

Alan003

791 gold badge3 silver badges9 bronze badges

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

1 Comment

Peter Badida Over a year ago

Finally an answer trying to show the why, not a workaround instead. +1

Kerem Akinli · Accepted Answer · 2020-07-16 10:52:17Z

0

import pandas as pd
df = pd.DataFrame(deals)
df.head()

Can you see what you get from this? After you editted your index and columns, you can run:

df.to_excel('name.xls')

answered Jul 16, 2020 at 10:52

Kerem Akinli

465 bronze badges

2 Comments

Alan003 Over a year ago

The df looks like this 0 0 Instrument Date Announced SDC Deal No 0 ... 1 None

Kerem Akinli Over a year ago

I am confused, can you do print(deals[:5]) and share the output?

MatejR · Accepted Answer · 2020-07-16 11:06:17Z

0

import csv

deals = list(deals)

with open("NameOfFile.csv",  "w") as csvfile:
    write = csv.writer(csvfile)
    
    for x in deals:
        write.writerow(map(lambda x: [x], deals))

This should work. This is taken (slightly modified) from csv docs for Python.

edited Jul 16, 2020 at 11:06

answered Jul 16, 2020 at 10:40

MatejR

8610 bronze badges

10 Comments

Alan003 Over a year ago

I have tried this. but getting this error "TypeError: a bytes-like object is required, not 'str'"

MatejR Over a year ago

Then, instead of "wb" try using "w". Check my edited post.

Alan003 Over a year ago

5 6 for x in deals: ----> 7 write.writerow(x) Error: iterable expected, not NoneType

MatejR Over a year ago

Is your deals tuple ONE HUGE TUPLE or TUPLE OF TUPLES?

MatejR Over a year ago

Luck or no luck?

|

Nitesh Jindal · Accepted Answer · 2020-07-16 11:16:47Z

0

You may try something like below code to write a list of string in a csv file:

import numpy as np
import pandas as pd

deals = ("Instrument", "Date", "Announced",  "SDC", "Deal", "No")

x = []
for j in range(0,len(deals)):
    x.append(str(deals[j]))

with open("myfile.txt", "w") as file1:
    for i in range(0,len(x)):
        file1.write(x[i])

answered Jul 16, 2020 at 11:16

Nitesh Jindal

1068 bronze badges

Collectives™ on Stack Overflow

How to save a tuple to excel in python

4 Answers 4

1 Comment

2 Comments

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related