Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Q&A

Welcome to Software Development on Codidact!

Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.

How can software track [1] how many subscribers to subreddits, [2] if subreddit is private, [3] if submissions are restricted?

+1
−5

Master lists like 82 food subreddits and 128 tech subreddits don't indicate

  1. each's subscribers.

  2. if it's private. Sometimes moderators can make the sub private for several days, to clean it up.

  3. if the moderators restricted the submission.

Indubitably, I don't have time to check 200 subreddits every week. I'm thinking of copying and pasting all 200 subreddits in an Excel spreadsheet, then making one column each for 1-3 above. But how do I command Excel to check these?

I don't even know if Excel can't do this. If it can't, how do I accomplish?

History
Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

1 comment thread

General comments (3 comments)

1 answer

+3
−0

It's entirely possible that there's some no-code product being developed out there that supports connecting to Reddit's API, so that you could collect the information you want without writing an actual program.

But you're on the Software Development Codidact, so I'm going to assume that you're here because you're open to the possibility of developing some software. (If you aren't, this question should be closed as off-topic.)

So broadly, if you don't have any preference for a programming language or other toolkit yourself, what I would recommend doing is this:

  1. First, find a popular library for accessing Reddit (possibly referred to as a binding or a wrapper for Reddit's API). Here's one for Python; here's one for Go; you can find more yourself. Pick one with documentation that you think you can understand; good documentation is probably the single most important feature of a library for beginners. (It's technically possible to achieve your goal by contacting Reddit's API directly, but that won't be a good project for a beginner.)
  2. Follow that library's instructions for installing it, if applicable. For Reddit, I think any library is going to require you to sign up for a Reddit developer key, and you will also need to read about Reddit's API usage restrictions.
  3. Write a program in the language supported by that library. In any general-purpose programming language, the program itself should be a good beginner's project. Use either the documentation provided by the library you've chosen, or Reddit's API documentation, to figure out how to get the information you want about the subreddits you're interested in. Use the language documentation, or tutorials that you might find for the language, to figure out how to represent or read a list of subreddits and perform an action for each one.

(I would not recommend attempting this in Excel. At the very least, you would need to write VBA code in order to make Excel contact Reddit, and you probably won't find a VBA wrapper for Reddit's API, so you would have to write a lot of extra code yourself. Possibly worth it if you had programming experience, were looking for a challenge, and had some compelling reason to publish this information specifically as an Excel spreadsheet, but it doesn't sound like any of those are true.)

If you have follow-up questions about specific issues you encounter while embarking on the above, search for their answers yourself, and if you come up empty, feel free to ask them here.

History
Why does this post require moderator attention?
You might want to add some details to your flag.

0 comment threads

Sign up to answer this question »