Preventa de eBooks de Bases de datos

Learn to build a web app that can monitor millions of posts across all social media platforms to chart public opinion in real time.Social media has become our modern-day agora, the place where we get our news and engage in political discourse. With disinformation, hate speech, foreign interference, authoritarianism, market monopolization, and political polarization all on the rise, monitoring social media in the public interest has never been so difficult nor so urgent. Social Media Exposed is an in-depth beginners guide to coding full-stack web applications in Python to track and analyze social media activity at scale, giving you unparalleled insights into the cultural and political conversations of our time, then empowering you to reach your own conclusions.Youll start by coding a web app to monitor Russian disinformation channels discussing Ukraine on Telegram, then learn more adversarial methods to scrape the Wayback Machine, Instagram, and TikTok. Youll detect Twitter bots following Saudi influencers, extract text-embedded URLs to reveal a white supremacist blogosphere, parse archived tweets to reveal the discourse leading up to the January 6 insurrection, and learn to circumvent Metas and ByteDances defenses to scrape Instagram and TikTok, collecting evidence of war crimes in the Middle East. Finally, youll write an API and deploy your observatory to a cloud server to collaborate with other investigators. By the end of the book, youll have a working website that allows collaborators to log in, request data collection, and perform analysis of collected data, via a point-and-click interface. Along the way, youll learn to: Use Python and RabbitMQ to retrieve Telegram data from a remote API Store data with PostgreSQL and query it with SQLAlchemy Analyze the data youve retrieved with Pandas, NetworkX, Gephi, and other tools Use state-of-the-art AI tools to transcribe audio and classify text Deploy a website with an interactive dashboard using FastAPI, Dash, Cytoscape, Uvicorn, Gunicorn, Nginx, AWS, and Lets Encrypt Containerize your apps with Docker and provision infrastructure with Pulumi Whether youre a citizen scientist, a security researcher, a journalist, an activist, or a scholar, Social Media Exposed is an essential blueprint for building your window into online worlds.

AI can write the code. You still need to know what it does.Youre already good at Excel. But youre tired of the copy/paste, the helper columns, and the brittle formulas that break when someone adds a row. You want automation, and whether you write the code yourself or let AI generate it, you need to understand whats actually running your business processes.Automate Excel with Python teaches you to build real workflows, step-by-step. Youll read messy workbooks into pandas dataframes, filter and reshape data without helper columns, merge sources without silent VLOOKUP failures, and export polished results with formatting intact. A capstone chapter ties it together: import a multi-tab workbook, generate exception reports, and email the resultsall from one script you run with a single click.Youll learn how to: Read existing Excel files you already use into Python, even the messy ones Replace daily copy/paste routines with reusable scripts Merge and match data across sources with auditable results Handle dates, times, and the edge cases that break formulas Export from Python to Excel with column widths, number formats, and frozen panes intact Build workflows that run daily without babysitting AI can write the code. This book makes sure youre the one in control of it.