i have table formatted data and wanted to convert into tuple format

Question

I have a csv file mentioned as below screen shot ...

and i want to convert the whole file in the below format in python.

what are you headers of csv file? – Hari Krishnan Aug 27 '18 at 06:22 — Hari Krishnan, Aug 27 '18 at 06:22
Use `tuples = [tuple(x) for x in df.values]` – jezrael Aug 27 '18 at 06:22 — jezrael, Aug 27 '18 at 06:22

score 1 · Accepted Answer · answered Aug 27 '18 at 06:26

1

You can try this after reading your CSV file correct file path.

import pandas as pd
df = pd.read_csv("path/to/file", names=["Sentence", "Value"])
result = [(row["Sentence"], row["Value"]) for index, row in df.iterrows()]
print(result)

answered Aug 27 '18 at 06:26

Raviteja Ainampudi

282
1
11

That's is exactly what i was looking for ! Thanks – Jitesh Vacheta Aug 27 '18 at 06:38

score 0 · Answer 2 · answered Aug 27 '18 at 06:22

0

It's a single line using apply() method of dataframe

df.apply(lambda x: x.tolist(), axis=1)

OR

df.values.tolist() will also work

answered Aug 27 '18 at 06:22

bigbounty

16,526
5
37
65

i have table formatted data and wanted to convert into tuple format

2 Answers2