Can Python "normalise" the CSV table?

18 views
Skip to first unread message

Drazen D. Babic

unread,
Nov 17, 2022, 7:33:26 PM11/17/22
to Jam.py Users Mailing List
Hi all, 

years ago I think there was a way to "split" the CSV into more "normalised" 
tables, basically a proper database with primary keys, removing redunancies, etc.

But looks like I can't find the library any more. Does anyone know?

That way we could build the App from CSV.

Thanks

Fabio Lenzarini

unread,
Nov 18, 2022, 12:56:30 AM11/18/22
to Drazen D. Babic, Jam.py Users Mailing List
Hi Darren,
Do you know Pandas?
I think this can help you to read CSV and write to DB.
I use it for my import-export function.

Ciao
Fabio 

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jam-py/bb1a3b20-69c5-4800-9de2-25c746930c59n%40googlegroups.com.

Drazen D. Babic

unread,
Nov 18, 2022, 1:18:25 AM11/18/22
to Jam.py Users Mailing List
Hi Fab,
It is not about Export/Import :)

It is about "splitting" one imported cvs into multiple "normalised" tables. Like MS Access "Analyse table" does. It can read huge Excel file and make small tables, like this:
Schema.PNG

And then you have a nice App.

Reply all
Reply to author
Forward
0 new messages