The Movie Database atbalsts
Atbalsts → Vispārēji
Export movie data to .csv
posted by PatuleiaSTAFFMOD on marts 22, 2015 at 8:27 PM
Hi, I'd like to know if there is any app or website that allows me to get the full details of all movies from a list created by me.
I recently found a website (mooviestats.com) that does more or less what I want, but the displayed fields are few and not allow me to export the data to a .csv file.
The idea is to compile the data from all the movies I see in a certain period of time and then process the data in my own way. Examples: Director X: 5 movies; Average runtime: 96 minutes; Director of Photography Y: 3 movies.
Atbilde no Devin Bayer
on maijs 17, 2015 at 4:36 AM
An export feature for themoviedb would make me much more comfortable using it.
Atbilde no nefycee
on janvāris 8, 2016 at 7:24 AM
+1
Atbilde no Travis Bell
on janvāris 8, 2016 at 11:12 AM
My plan is to get to this sometime this year. I have a lot of things on my plate currently ;)
Atbilde no harlanchen
on jūlijs 13, 2016 at 7:08 AM
+1
Atbilde no blizeH
on februāris 8, 2018 at 9:59 AM
Hi, is there any update on this please? :) I've just imported my information from IMDB and love the site, but I'm also a little worried that if I start adding more things to my watchlist/rated etc I won't be able to move them again if I have to :(
Atbilde no pwhinson
on maijs 21, 2018 at 2:41 PM
Ditto to blizeH
Atbilde no gilllance
on janvāris 12, 2019 at 5:07 PM
I'm actually interested in this as well.
Atbilde no Travis Bell
on janvāris 12, 2019 at 5:20 PM
Being able to export your watchlist, rated and favourite lists was added back at the end of August. Just click the options link on any of your lists. Example here.
Atbilde no gilllance
on janvāris 12, 2019 at 5:39 PM
Thank you for the quick response Travis. Maybe I'm overlooking an aspect, or perhaps I'm just confused how APIs work. I tried the way you suggested, but am not getting the level of data I'm hoping for. The first comment on tfhis thread asked, "The idea is to compile the data from all the movies I see in a certain period of time and then process the data in my own way. Examples: Director X: 5 movies; Average runtime: 96 minutes; Director of Photography Y: 3 movies." Is this available to do with a list I've created? Would be great if it saved the Trailer and poster links as well.
Atbilde no Travis Bell
on janvāris 12, 2019 at 5:53 PM
I don’t have any current plans to offer an export with that kind of information. That’s more of a personal data aggregation feature than it is a list export.
As it stands right now the only thing you can export is your 3 accounts lists.
Having said all that, someone could certainly build this personal aggregation with the list of items found in the export. So you’re kind of half way there.
Atbilde no PT 100
on janvāris 12, 2019 at 8:41 PM
There are many software solutions that will aggregate data exported from TMDb. Some are expensive and intended to manage very large data sets (such as the package I own). But there are free, open-source tools that will aggregate exported data as well. And Microsoft Excel has a built-in aggregate function. If you have access to Excel, you can import a .csv file and aggregate whatever fields you wish.
Atbilde no gilllance
on janvāris 12, 2019 at 11:11 PM
That’s extremely helpful. Thank you. I actually have a large set of movies. Mind me asking what program you use?
Atbilde no PT 100
on janvāris 12, 2019 at 11:25 PM
Among other things, I'm a professional data-mining consultant, so I usually use a statistical software package called SPSS (now owned by IBM) for data preparation/aggregation and advanced multivariate statistical modeling/analysis on very large "big data" databases (thousands or millions of cases). I tend to use Excel not for data aggregation but for operations research analyses, such as linear programming/process optimization, etc.
SQL, a database management language (e.g., Oracle, MySQL, PostgreSQL, etc.), can also be used to aggregate data from databases. Usually it is used on relational databases, not "flat files" (simple two-dimensional databases or single data tables such as .csv files).