Questions tagged [trending]
88 questions
0
votes
1 answer
add categories to a trend table
Hi folks I've been noddling how to approach this one for a while now and I'm just stuck. Hoping this question is useful to the community.
I have a trend table with data like the first table below. I have another table with categories like the second…

xMarcus
- 1
0
votes
1 answer
Get next 10 batch of info after a certain ID mySQL query?
I am creating a trending feed of videos for an iPhone app and am calculating all of the views on a video in the last 24 hours in a views table (a row is added to the views table everytime it is views and has a timestamp and videoid). When I do…

stuyam
- 9,561
- 2
- 21
- 40
0
votes
1 answer
How to work out what's "trending" on site I have no access too
On a forum I'm on there's a news section where members post news. Every day it seems there is articles about Apple and someone made a petition to have apple articles removed as it's the same stories day in day out. Each forum section has an RSS…

Joshua
- 906
- 5
- 12
- 23
0
votes
1 answer
Calculations between columns in data frame: week-on-week 'trending' sales detection
I have a data.frame representing frequency book sales for a set of authors over 25 weeks:
author week_1 week_2 week_3 week_4 ...
author1 7 4 5 2
author2 3 6 18 5
author3 1 0 2 …

Harry Palmer
- 468
- 1
- 6
- 17
0
votes
1 answer
R: loop to add to table new columns, each populated with data aggregated from different csv file
I am struggling to work out how to do this in R.
I have data like this from a set of ~50 csv files, each detailing an individual books sale transaction:
**week 1**
**author** **title** **customerID**
author1 title1 1
author1 title2 2
author2 title3…

Harry Palmer
- 468
- 1
- 6
- 17
0
votes
2 answers
SQL CODE to do: Trending topics equals a twitter
If i wants count the matching words in a rows of two tables, with milions of rows, sample:
Table posts, sample:
+----+---------+-----------------------------+
| ID | ID_user | text |…
Bruno
0
votes
2 answers
trending based on twitter mentions and facebook likes
Our website allow people to upload images and then share them on twitter and/or like them on facebook. There's a trending page with the top X images based on the total number of twitter mentions and facebook likes of a specific page.
The only way at…

Nicolas
- 2,754
- 6
- 26
- 41
0
votes
1 answer
MySQL monthly trending
I am working with a charting program to show monthly inventory totals. So far I only have data for May (the June data will be inserted into the table automatically on June 1st and timestamped).
I am using the below query, and it returns 1 row…

Ben
- 153
- 2
- 6
- 18
-1
votes
1 answer
store an array value to a new variable using it's key - twitter api
I'm trying to write code that will return the past 100 tweets that contain the current trending hashtags on twitter. First I get the contents of the current trends and isolate just trending hashtags:…

Jennifer
- 41
- 2
-1
votes
1 answer
JQuery Load doesn't load live
I'm using JQuery in a PHP file to load the files of another content called 'live.php' which displays time(), but it doesn't load live. Why is this happening? It used to work.
MAIN.PHP
echo "";
echo '