I’m trying to learn Japanese, and the spaced repetition software Anki
is one of my favourite tools. I usually use premade decks for learning
Japanese (Core 2k, etc), but when I discovered the Chrono Trigger
Retranslation Project a few days ago, I just had to make a deck.
I downloaded the spreadsheet translation, and exported it as a CSV,
using | as column delimiter, and no string delimiter. Since the
sentences are split over several rows, I had to clean it up a bit.
# clean.py import csv with open("translation.csv", "rb") as csvfile: reader = csv.reader(csvfile, delimiter="|") columns = len(reader.next()) # A list of lists for building strings currentstr = [ for i in range(columns)] for row in reader: # Build strings for each column for idx, string in enumerate(row): currentstr[idx].append(string) # Check if we are done building strings if "".join(row) == "": # Done. Print useful columns. print "".join(currentstr), "|", # Original translation print "".join(currentstr), "|",# Japanese print "".join(currentstr), # Retranslation print # Empty strings currentstr = [ for i in range(columns)]
Save the cleaned file:
clean.py > cleaned.csv
Then I used Vim to remove things like item names, extra spaces
and switch delimiter to tabs, since Anki didn’t like pipes.
And there you go. You can download the deck here.
When I posted this on Reddit some people commented on the quality of the translation. It is worth reading those comments if you are considering using this deck.