The Movie Database 支持
支持 → 一般问题
Export movie data to .csv
PatuleiaSTAFFMOD 发布于 2015 年 03 月 22 日 8:27下午
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.
Devin Bayer 的回复
于 2015 年 05 月 17 日 4:36上午
An export feature for themoviedb would make me much more comfortable using it.
nefycee 的回复
于 2016 年 01 月 08 日 7:24上午
+1
Travis Bell 的回复
于 2016 年 01 月 08 日 11:12上午
My plan is to get to this sometime this year. I have a lot of things on my plate currently ;)
harlanchen 的回复
于 2016 年 07 月 13 日 7:08上午
+1
blizeH 的回复
于 2018 年 02 月 08 日 9:59上午
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 :(
pwhinson 的回复
于 2018 年 05 月 21 日 2:41下午
Ditto to blizeH
gilllance 的回复
于 2019 年 01 月 12 日 5:07下午
I'm actually interested in this as well.
Travis Bell 的回复
于 2019 年 01 月 12 日 5:20下午
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.
gilllance 的回复
于 2019 年 01 月 12 日 5:39下午
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.
Travis Bell 的回复
于 2019 年 01 月 12 日 5:53下午
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.
PT 100 的回复
于 2019 年 01 月 12 日 8:41下午
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.
gilllance 的回复
于 2019 年 01 月 12 日 11:11下午
That’s extremely helpful. Thank you. I actually have a large set of movies. Mind me asking what program you use?
PT 100 的回复
于 2019 年 01 月 12 日 11:25下午
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).