WebMar 24, 2024 · Unfortunately, I do have some performance issues. Due to the fact that I paginate based on created_utc - 1 (and since I do not want to miss any comments/posts), the initial dataframe will contain duplicates (since there won't be 100 (=API limit) new comments/posts every new second). WebNov 24, 2024 · I have used the PMAW Pushshift API to gather reddit submissions from a specific subreddit, using Python and I want to convert the UTC timestamp to regular …
How to create a DataFrame with Reddit API loop and manage …
WebMar 4, 2024 · 1 Answer. Sorted by: 2. If your data is stored in variable d, you should be able to do this: from datetime import datetime date = datetime.utcfromtimestamp (d ['author_created_utc']) If you only care about the date and don't need to work with it as a datetime object, you can use this instead: WebAug 11, 2024 · :created_utc is the name of the key that reddit chose to contain the timestamp in seconds since epoch. Snowflake allows us to navigate JSON objects easily with this syntax. heller in pink tights film
Getting the date of a submission - reddit
WebMay 20, 2024 · import praw import csv import pandas as pd reddit = praw.Reddit(client_id="THE CLIENT ID YOU GOT FROM REDDIT", client_secret="THE SECRET YOU GOT FROM REDDIT", user_agent="A UNIQUE USER AGENT YOU SET RIGHT NOW") You’ll need to fill in the client_id and secret that Reddit assigned you … WebDec 18, 2015 · 2. After hovering on the "submitted 2 months ago" I can get the created date of the post on reddit UI. In my case, the post I'm looking at has this datetime: Fri Dec 18 02:06:06 2015 UTC. But when I call the reddit API using praw I'm getting this in the created_utc field: 1450404366.0. I'm not able to translate "Fri Dec 18 02:06:06 2015 … WebFeb 18, 2016 · Filter the results out in Python before you put them into your DB. get_hot and get_new return generator objects, so you can use a list comprehension like this: from datetime import datetime, timedelta import praw # assuming you run this script every hour an_hour_ago = datetime.utcnow () - timedelta (hours=1) r = praw.Reddit … heller in pink tights book