[Air-L] Instagram hashtag in date range?
Thomas Ball
xtc283 at gmail.com
Thu Jul 27 07:55:28 PDT 2017
Here's a simple example of a range-based, 'fuzzy merge' using SAS SQL. This
code is easily translated into any SQL language or code.
data one;
input time time5. sample;
format time datetime13.;
time=dhms('23nov94'd,0,0,time);
datalines;
09:01 100
10:03 101
10:58 102
11:59 103
13:00 104
14:02 105
16:00 106
;
data two;
input time time5. sample;
format time datetime13.;
time=dhms('23nov94'd,0,0,time);
datalines;
09:00 200
09:59 201
11:04 202
12:02 203
14:01 204
14:59 205
15:59 206
16:59 207
18:00 208
;
proc sql;
create table match2 as
select *
from one(rename=(time=time1 sample=sample1)) full join
two(rename=(time=time2 sample=sample2))
on abs(time1-time2)<=5*60;
quit;
On Thu, Jul 27, 2017 at 12:26 AM, Jonathon Hutchinson <
jonathon.hutchinson at sydney.edu.au> wrote:
> Hi AoIR list,
>
> Apologies if this has been answered previously, but I can’t seem to find
> the answer elsewhere.
>
> I have an honours student who is undertaking research on #mbfwa on
> Instagram.
>
> She is looking at the hashtag within the date range of April 6 - April 10
> 2017. She is manually accessing the content, which means she has to scroll
> back through a large amount of entries to access the required content.
>
> Just wondering if anyone knows of any methods or techniques (post API
> changes) that can enable us to search an Instagram hashtag via a date range?
>
> Thanks in advance
>
> Jonathon.
> DR JONATHON HUTCHINSON | Lecturer in Online and Social Media
> Department of Media and Communications | Faculty of Arts and Social
> Sciences
> THE UNIVERSITY OF SYDNEY
> Room N233, John Woolley Building A20 | The University of Sydney | NSW |
> 2006
> T +61 2 9351 2821 | F +61 2 9351 2434
> E jonathon.hutchinson at sydney.edu.au<mailto:grant.bollmer at sydney.edu.au>
> | W jonathonhutchinson.com<http://sydney.edu.au/arts/digital_cultures/>
>
> _______________________________________________
> The Air-L at listserv.aoir.org mailing list
> is provided by the Association of Internet Researchers http://aoir.org
> Subscribe, change options or unsubscribe at: http://listserv.aoir.org/
> listinfo.cgi/air-l-aoir.org
>
> Join the Association of Internet Researchers:
> http://www.aoir.org/
More information about the Air-L
mailing list