On Sun, Nov 6, 2016 at 3:53 PM, Mohamed Oun <mohamed...@gmail.com> wrote: > > Okay Davide, so I managed to get it to work by switching to Ubuntu and > ditching windows entirely, kind of unorthodox haha.
:-) Glad at least this is working. > So now I want to split the votes distribution column into 10 different > columns, one for each number. How do you think that could be done? Hmmm... do you really need to do it in the database? After all, you can read it and split it in python or any other programming language. Anyway, you can surely create a series of 10 new columns in the title tables, to store the single digits, but also in this case you have to parse each value, identify the movie_id, split the votes distribution (with the substring function present in most SQL servers) and store them. Not so simple to do, but should work. -- Davide Alberani <davide.alber...@gmail.com> [PGP KeyID: 0x465BFD47] http://www.mimante.net/ ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi _______________________________________________ Imdbpy-help mailing list Imdbpy-help@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/imdbpy-help
