Reading all notes from a deck

[CaptainDario]

Reading all notes from a deck

[klieret]

Hi @CaptainDario, I think the field you're looking for is called cdeck :) All columns of the "cards" table are prefixed with c. Let me know if this works!

[klieret]

Ah, I just saw that the old closed issue references deck instead of cdeck (probably and earlier version of AnkiPandas). I'll add a note there, thanks for making me aware of this.

Thanks btw for providing such a complete issue report including all the logs and code and link :)

[CaptainDario]

@klieret Thank you for your help!
With cdeck I can now iterate over all cards from a test-deck.

I added:

for cnt in range(t.shape[0]):
    print(t.iloc[cnt][19])

to print the back and front of a basic note (I guess there is a prettier way to do that...).

However I have problems accessing a nested deck.
The deck I want to access is nested like this:
"Sprachen" -> "Japanisch" -> "Japanisch Vokabeln"
when I try:

t = cards.query("cdeck == 'Japanisch Vokabeln'")

or

t = cards.query("cdeck == 'Sprachen::Japanisch::Japanisch Vokabeln'")

I get an empty deck.

What is the correct notation to access a nested deck?

[klieret]

Can you just check cards["cdeck"].unique() before the query? This should print all available deck names, so you'll probably find yours there.

I can also recommend you to simply do a pandas tutorial, this will probably help you a lot with these things :) (also for finding your way with accessing the content of the tables).

[klieret]

I can also highly recommend to run AnkiPandas in a Jupyter notebook. This will give you a graphical representation of the tables and lets you play around with it much more interactively

[CaptainDario]

Thank you, a Pandas tutorial is overdue thats true...

I just read a little bit about pandas and could finally figure out how to get all notes from a deck. The separator for nested decks is \x1f.
This is just a small side project for one or two days, so thank you for saving my time budget with this very nice library!

[klieret]

That's good to know with the \x1f separator! I'll see if I add some documentation for that!

Good luck with your side project, don't hesitate if there are more questions :)