Edit - Stack Overflow

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

Rev

Title*

Body*

What are the details of your problem?
I am a teacher and I want to use Python to create a worksheet for my students. I have a vocabulary PDF with content like this:
```
do your best duː jɔː best
33, 81
do your hair/make-up duː jɔː heə/ ˈmeɪkʌp
81
do/work overtime duː/wɜːk ˈəʊvətaɪm
36
do/write an essay duː/raɪt æn ˈeseɪ
33
document ˈdɒkjəmənt
54
documentary ˌdɒkjəˈmentəri
52
dollar ˈdɒlə
19
dolphin ˈdɒlfɪn
8
don’t worry dəʊnt ˈwʌri
65
```

I want to convert it into a table with three columns: vocab, API, and number that I can paste directly into Google Sheets, like this:
```
vocab	API	number
do your best	duː jɔː best	33, 81
do your hair/make-up	duː jɔː heə/ˈmeɪkʌp	81
do/work overtime	duː/wɜːk ˈəʊvətaɪm	36
...	...	...
```

I tried using the following Python code to extract text from the PDF and save it to a CSV:
```
import os
import csv
from pdfminer.high_level import extract_text

base_path = r"C:\Users\PC\OneDrive\Desktop\New folder"

pdf_file = os.path.join(base_path, "vocab.pdf")
csv_file = os.path.join(base_path, "vocab.csv")

text = extract_text(pdf_file)

lines = text.splitlines()

with open(csv_file, "w", newline="", encoding="utf-8") as f:
 writer = csv.writer(f)
 for line in lines:
 if line.strip(): # bỏ dòng trống
 writer.writerow([line.strip()])

print(f"Done! File CSV đã được tạo ở: {csv_file}")
```

However, this only produces a blank CSV file.

What I was expecting:
I want the CSV to have three separate columns: vocab, API, and number with each entry properly aligned, so I can paste it directly into Google Sheets.

Draft saved

Draft discarded

CollectivesTM on Stack Overflow