import praw
import pandas as pd
from datetime import datetime

# Initialize Reddit API client
reddit = praw.Reddit(
    client_id='YOUR_CLIENT_ID',
    client_secret='YOUR_CLIENT_SECRET',
    user_agent='python_trending_scraper/1.0'
)

def fetch_python_posts(subreddit='all', limit=10):
    """
    Fetch Python-related posts from specified subreddit
    Returns DataFrame with post details
    """
    posts_data = []
    
    try:
        # Search for Python-related content
        for submission in reddit.subreddit(subreddit).search('python', limit=limit):
            post_info = {
                'title': submission.title,
                'score': submission.score,
                'upvote_ratio': submission.upvote_ratio,
                'num_comments': submission.num_comments,
                'created_utc': datetime.fromtimestamp(submission.created_utc),
                'url': submission.url,
                'author': str(submission.author),
                'flair': submission.link_flair_text
            }
            posts_data.append(post_info)
            
        # Convert to DataFrame for easy analysis
        df = pd.DataFrame(posts_data)
        
        # Sort by engagement (score + comments)
        df['engagement_score'] = df['score'] + (df['num_comments'] * 0.5)
        df = df.sort_values('engagement_score', ascending=False)
        
        return df
        
    except Exception as e:
        print(f"Error fetching posts: {e}")
        return pd.DataFrame()

# Example usage
if __name__ == "__main__":
    # Get trending Python posts
    trending_posts = fetch_python_posts('programming', limit=15)
    
    # Display top 5 posts
    if not trending_posts.empty:
        print("\n🔥 TRENDING PYTHON POSTS 🔥\n")
        for idx, row in trending_posts.head(5).iterrows():
            print(f"{idx+1}. {row['title']}")
            print(f"   ⬆️ {row['score']} | 💬 {row['num_comments']} | 👤 {row['author']}\n")
    else:
        print("No posts found or API error occurred")

What Even Is showPython?

Let's break this down like a badly written line of code. Someone, somewhere, decided to post just the word 'showPython' on Reddit. No context. No explanation. Just two words mashed together like a digital Rorschach test. Was it a demand? A request? A cry for help from someone whose pet snake learned to code?

The beauty lies in the ambiguity. It's like walking into a room and someone just says 'banana' with intense eye contact. You're left wondering: Are they hungry? Is this a secret code? Did I miss the banana memo? The internet thrives on these moments of collective confusion.

Why This Is Peak Internet Comedy

First observation: The comments section became a game of 'Who Can Misinterpret This The Hardest?' One person probably thought it was about Python programming tutorials. Another imagined someone proudly displaying their pet snake. A third might have assumed it was a weird new dance challenge. And let's be real - at least one person definitely took it in a... let's say 'creative' direction. That's just how Reddit works.

Second observation: 890 people upvoted this. Not because they understood it, but precisely because they didn't. It's the digital equivalent of seeing a crowd gathered around something and joining in because FOMO is real. 'I don't know what we're looking at, but I'm invested now!' - every Redditor ever.

Third observation: The fact that there are only nine comments is comedy gold. It means most people looked at 'showPython,' had a brief existential crisis about what it meant, upvoted out of confusion, and scrolled away to question their life choices. The brave nine who commented? Internet heroes, every one of them.

The Punchline We All Needed

Here's the thing about viral moments like 'showPython' - they remind us that the internet is just a bunch of humans pretending to know what's going on. We're all just throwing phrases into the void and seeing what sticks. Sometimes it's profound. Sometimes it's political. And sometimes it's just two random words that make 890 people go 'huh?'

The real showPython was the friends we made along the way. Or maybe it was the confusion. Or possibly someone's pet snake doing a little dance. Honestly, at this point, your guess is as good as mine - and that's exactly why it's perfect.