hollywood_social_network_analysis
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
hollywood_social_network_analysis [2019/12/10 14:04] – hkimscil | hollywood_social_network_analysis [2019/12/11 08:09] (current) – hkimscil | ||
---|---|---|---|
Line 43: | Line 43: | ||
| | ||
?m dbp: | ?m dbp: | ||
- | # error here | + | FILTER(xsd:date(? |
- | FILTER(DATATYPE(? | + | |
?m dbp: | ?m dbp: | ||
?a rdfs:label ?actor . | ?a rdfs:label ?actor . | ||
Line 53: | Line 52: | ||
| | ||
- | ## Sys.setenv(TZ = " | ||
res <- SPARQL(endpoint, | res <- SPARQL(endpoint, | ||
+ | head(res) | ||
+ | </ | ||
- | res</code> | + | < |
- | <code> | + | |
- | # output: | + | 1 "Pat O' |
- | # actor movie director | + | 2 |
- | # 1 "Harland Williams"@en "Big Money Hustlas"@en "John Cafiero" | + | 3 |
- | # 2 | + | 4 "Kevin Gage (actor)" |
- | # 3 | + | 5 |
- | # 4 "Joseph Utsler"@en "Big Money Hustlas"@en "John Cafiero" | + | 6 "Rex Harrison" |
- | # 5 | + | movie_date |
- | # ...</ | + | 1 -1203379200 |
+ | 2 -1580083200 | ||
+ | 3 1005609600 | ||
+ | 4 1005609600 | ||
+ | 5 -1257724800 | ||
+ | 6 | ||
+ | </ | ||
< | < | ||
+ | head(res) | ||
</ | </ | ||
- | < | + | < |
- | # actor movie director | + | > head(res) |
- | # 1 "Harland Williams"@en "Big Money Hustlas"@en "John Cafiero" | + | actor movie |
- | # 2 | + | 1 "Pat O' |
- | # 3 | + | 2 |
- | # 4 "Joseph Utsler"@en "Big Money Hustlas"@en "John Cafiero" | + | 3 |
- | # 5 | + | 4 "Kevin Gage (actor)" |
- | # ... | + | 5 |
+ | 6 "Rex Harrison" | ||
+ | movie_date | ||
+ | 1 1931-11-14 | ||
+ | 2 1919-12-07 | ||
+ | 3 2001-11-13 | ||
+ | 4 2001-11-13 | ||
+ | 5 1930-02-23 | ||
+ | 6 1967-12-12 | ||
+ | > | ||
</ | </ | ||
+ | < | ||
+ | # write the data somewhere else | ||
+ | write.csv(res, | ||
+ | getwd() | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | actor_movie_matrix[849: | ||
+ | </ | ||
+ | |||
+ | < | ||
+ | > actor_movie_matrix[849: | ||
+ | |||
+ | " | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | "Woody Harrelson" | ||
+ | "Wynne Gibson" | ||
+ | |||
+ | "The Hunger Games: Mockingjay < | ||
+ | " | ||
+ | " | ||
+ | " | ||
+ | "Woody Harrelson" | ||
+ | "Wynne Gibson" | ||
+ | > | ||
+ | </ | ||
hollywood_social_network_analysis.1575954284.txt.gz · Last modified: 2019/12/10 14:04 by hkimscil