Integrate / visualise country / city level (bidtoart) data

[kaljuvee]

Tree Menu

• Estonian Art Index
• European Art Index - Auction House (bidtoart)
• European Art Index - All (findartinfo)

1 / Split Source into Auction House +City (remove city address) For instance:

• Christie's | London, King Street -> Christie's + London
• Christie's | London, South Kensington -> Christie's + London

Comments:

• id - NO
• auction_date - NO
• auction_year - YES
• author - YES
• title - NO
• start_price - YES, remove nulls, all text, keep only numeric value
• end_price - YES, remove nulls, all text, keep only numeric value
• currency - always convert to EUR, use current static rates, from conversion table
• decade - YES
• technique - YES
• source - split Auction House + City as above
• dimension - YES

Conversion Dict / Yaml / CSV GBP = 1.14 USD = 0.94 SEK = .... DKK = .....

end_price = end_price * (currency_lookup)

Connection:

3.125.65.93 db: bidtoart artindex_user dCjYsIYQGCyzQKx2

Let's visualise / analyse bidtoart info similar way we did for Estonia.

[markussulg]

Early prototype