Spit in the Face of God: Five Tasks You Didn’t Know Could be Done with Google Sheets
Articles in Spreadsheets | By August R. Garcia
Published 7 months agoTue, 12 Feb 2019 07:53:13 -0800 | Last update 6 months agoThu, 28 Feb 2019 22:37:26 -0800 📌
Last Reply
Any opportunity to spit in the face of god is good by me.
Excellent post homie.
Hash Brown,
Any opportunity to spit i...
An introduction to scraping with Python and BeautifulSoup
Articles in Web Scraping, Data Analysis | By Hash Brown
Published 8 months agoTue, 08 Jan 2019 22:34:09 -0800 | Last update 6 months agoMon, 11 Mar 2019 22:19:33 -0700 📌
Last Reply
Very nice, as they say.
Other scraping methods
For those who don’t perhaps have the skills needed to code something there are also other...
August R. Garcia,
Very nice, as they say.
[Solved] Correct-Horse-Battery-Staple Implementations (Misc. Languages)
Answers in Scripting and Automation | By August R. Garcia
Published 3 days agoMon, 16 Sep 2019 19:25:37 -0700
Currently: Python, Bash
MoreSee: Correct Horse Battery Staple from XKCD, if somehow you haven't seen this before. There's also a generator that can be used here. How to...[Solved] How to Get Random Punctuation in Python
Answers in Scripting and Automation | By August R. Garcia
Published 3 days agoMon, 16 Sep 2019 19:14:26 -0700
Code:
MoreCode: # string.punctuation contains the following characters: # !"#$%&'()*+,-./:;<=>?@[\]^_`{|}~ import random, string print( rand...[Solved] How to immediately kill all Python threads when working with multithreading
Answers in Scripting and Automation | By August R. Garcia
Published 4 days agoSun, 15 Sep 2019 17:06:46 -0700 | Last update 4 days agoSun, 15 Sep 2019 20:49:11 -0700
why is this answer so hard to find
MoreNormally, to kill a Python script while it is running, pressing CTRL+C will work. However, if there are multiple threads running because the program i...[Solved] Color code HTTP status codes in Python
Answers in Web Scraping, Data Analysis | By August R. Garcia
Published 1 month agoMon, 29 Jul 2019 22:34:12 -0700
Last Reply
For Python 3:
import http.client
[...]
try: msg = " " + http.client.responses[status_code]
[...]
Code is basically th...
August R. Garcia,
For Python 3:
Solve "Typeerror: unhashable type: 'list'"?
Answers in Scripting and Automation | By Some Guy
Published 9 months agoSun, 16 Dec 2018 09:34:42 -0800
Last Reply
Ran into this like five minutes ago and found this fucking thread in the SERPs. What a shitty fucking thread that did not answer my question. Anyway,...
August R. Garcia,
Ran into this like five m...
How to Make a Simple, Automatically-Updating Dashboard for Python Scripts Using HTML, JavaScript, and JSONP
Articles in Scripting and Automation | By August R. Garcia
Published 2 weeks agoThu, 05 Sep 2019 04:39:30 -0700 | Last update 2 weeks agoThu, 05 Sep 2019 05:15:22 -0700
Last Reply
Hell motherfucking yeah sir
Hash Brown,
Hell motherfucking yeah s...
The Basics to Web Scraping with cURL and XPath
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 2 months agoFri, 28 Jun 2019 09:02:04 -0700 | Last update 2 months agoTue, 02 Jul 2019 17:37:33 -0700
Last Reply
Bump. Some more cURL, used to determine the quality of proxygo's proxies:
for i in {1..48} ; do curl https://www.blackhatworld.com/seo/ssl-proxi...
August R. Garcia,
Bump. Some more cURL, use...
[Solved] Basic progress bar functionality with Python
Answers in Scripting and Automation | By August R. Garcia
Published 3 weeks agoSun, 25 Aug 2019 12:04:00 -0700 | Last update 3 weeks agoSun, 25 Aug 2019 12:06:08 -0700
Commentary is hard. Use your reading ski...
MoreCommentary is hard. Use your reading skills to read this code: #!/usr/bin/env python # -*- coding: utf-8 -*- import time import sys from...[Solved] How to Show Number of Remaining Threads in Python
Answers in Scripting and Automation | By August R. Garcia
Published 1 month agoFri, 16 Aug 2019 06:38:19 -0700 | Last update 3 weeks agoMon, 26 Aug 2019 01:21:58 -0700
Self explanatory, mostly.
MoreSelf explanatory, mostly. Original Code import Queue from threading import Thread, active_count import time que = Queue.Queue()...[Solved] Google Sheets: "Text result of JOIN is longer than the limit of 50000 characters"
Answers in Spreadsheets | By August R. Garcia
Published 1 month agoTue, 23 Jul 2019 15:38:52 -0700
The answer is to fucking kill yourself.<...
MoreThe answer is to fucking kill yourself.[Solved, Basically] Nautilus - Open Multiple Tabs from Command Line?
Answers in Shell Scripting | By August R. Garcia
Published 1 month agoSat, 20 Jul 2019 23:22:36 -0700 | Last update 1 month agoSat, 20 Jul 2019 23:22:46 -0700
How to open multiple GUI file manager ta...
MoreThe answer is that there's no built in option to do this in Nautilus, although there are Stack Exchange threads discussing ghetto hack workarounds....[BASH, cURL] Yellow Pages Scraper: Fully Functional Script with Source Code
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 2 months agoFri, 05 Jul 2019 23:22:06 -0700 | Last update 2 months agoSat, 06 Jul 2019 01:44:02 -0700
What a nice, free YellowPages scraper.
MoreEdit: When trying to scrape indefinitely (~100+ pages), there's some buggy behavior with exit conditions currently. If/when an updated script is poste...Downloading Bulk Images: ThisPersonDoesNotExist with Python and urllib2
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 6 months agoThu, 14 Mar 2019 06:25:36 -0700 | Last update 6 months agoThu, 14 Mar 2019 08:05:08 -0700
Last Reply
Here's a shorter version with cURL and BASH that does basically the same thing:
for i in $( seq 1 10 ) ; do curl --user-agent "Some User-Agent St...
August R. Garcia,
Here's a shorter version...
[cURL, BASH] How to Crawl and Scrape DuckDuckGo Search Results
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 2 months agoTue, 02 Jul 2019 17:29:24 -0700 | Last update 2 months agoThu, 04 Jul 2019 19:21:52 -0700
You can use these same concepts to build...
MoreAs discussed recently, it is relatively easy to scrap various arbitrary pieces of data using cURL (and XPath). You can use these same concepts to buil...The Easiest Way to Build a Reddit Bot?
Forum in Scripting and Automation | By Some Guy
Published 9 months agoSun, 16 Dec 2018 09:40:29 -0800 | Last update 2 months agoSun, 30 Jun 2019 14:54:21 -0700
Last Reply
Also, see this post. Could probably do something similar, depending on use case:
https://www.256kilobytes.com/content/show/10842/the-basics-to-w...
August R. Garcia,
Also, see this post. Coul...
[Python] Fixing "TypeError: only integer scalar arrays can be converted to a scalar index?"
Answers in Scripting and Automation | By Some Guy
Published 8 months agoSun, 13 Jan 2019 05:54:12 -0800
Last Reply
A simple case that generates this error message:
In [8]: [1,2,3,4,5][np.array([1])]
--------------------------------------------------------------...
Univa,
A simple case that genera...
[Google Sheets] Dollar sign usage? What does it do?
Answers in Spreadsheets | By Some Guy
Published 7 months agoWed, 06 Feb 2019 14:35:22 -0800
Last Reply
The $ is used in a cell reference to create an absolute reference. An absolute reference is one that will not change when the formula is copied.
Th...
Univa,
The $ is used in a cell r...
[JavaScript] Fix for "Uncaught SyntaxError: unexpected token export/import/illegal?"
Answers in Scripting and Automation | By Some Guy
Published 8 months agoSun, 13 Jan 2019 06:00:03 -0800
Last Reply
In case you get this error it might also be related to how you included the javascript file into your html page. When loading modules you have to expl...
Univa,
In case you get this erro...
Extracting Emails from HTML with Google Sheets: Get Contact Information in Bulk for Guest Posts, (lmao) 404 Replacement, and Other Outreach
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 3 months agoSat, 25 May 2019 17:20:37 -0700
What a nice trick.
MoreWhat a nice trick. How to Extract Emails from HTML with Google Sheets Code function get_raw_html(url) { // The code below logs the H...[Solved] Bash: cannot create temp file for here-document: No space left on device.
Answers in Shell Scripting | By Whisky Fren
Published 4 months agoThu, 16 May 2019 21:24:37 -0700
Now I can use tab completion on my celeb...
MoreThe answer is that you're out of storage space. Possibly because of temporary files, but also possibly your hard drive is close to full. Or your serve...[Google Sheets] Global conditional formatting across multiple sheets/tabs?
Answers in Spreadsheets | By Some Guy
Published 8 months agoSun, 13 Jan 2019 04:11:14 -0800
Last Reply
Create sheets by clicking the "+" button at the bottom of your browser window.
In Sheet1, type this formula into any cell in column A:
=INDIRECT("...
Univa,
Create sheets by clicking...
Solve "ImportError: DLL load failed: the specified module could not be found"?
Answers in Scripting and Automation | By Some Guy
Published 9 months agoSun, 16 Dec 2018 09:27:46 -0800
Last Reply
Run print(os.environ['PATH']) in the system terminal using the same interpreter
Copy the result and add as a PATH environment variable to your Ru...
Univa,
[Infographic] The Beginner's SQLite Cheat Sheet
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 4 months agoSat, 04 May 2019 23:59:37 -0700
The important hotkeys, commands, and tri...
MoreWhat a great infographic. Copy-Pasteable Version of the SQLite Commands Cheat Sheet General SQLite Commands and Information Opening SQLit...Analyzing the Web: Downloading the Majestic Million, Setting up SQLite, Crawling the Web, and Generating Reports
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 4 months agoWed, 24 Apr 2019 03:29:27 -0700 | Last update 4 months agoThu, 25 Apr 2019 09:14:10 -0700
Last Reply
The longest domain names in the Majestic Million, most of which are expired and basically all of which are terrible garbage:
255461 ...
August R. Garcia,
The longest domain names...
[Python] Fix for "TypeError: this constructor takes no arguments?"
Answers in Scripting and Automation | By Some Guy
Published 8 months agoSun, 13 Jan 2019 05:56:52 -0800
Last Reply
Typeerror This Constructor Takes No Arguments Python Error error codes are caused, in one way or another, by misconfigured system files in your Window...
Univa,
Typeerror This Constructo...
How to use the Quick Analysis tool in Excel 2016?
Answers in Spreadsheets | By Some Guy
Published 9 months agoSun, 16 Dec 2018 09:31:51 -0800
Last Reply
Select the cells of data that you want to analyze
Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Click it
Rol...
Univa,
Finding outliers in Excel?
Answers in Spreadsheets | By Some Guy
Published 9 months agoSun, 16 Dec 2018 09:37:00 -0800
Last Reply
By using Box and Whisker charts, you can easily identify outliers of your data, and it shows you where the data lies in and outside your inner quartil...
Univa,
By using Box and Whisker...
How to round number to nearest 5 in Excel?
Answers in Spreadsheets | By Some Guy
Published 9 months agoSun, 16 Dec 2018 09:35:18 -0800
Last Reply
For rounding numbers to the nearest 5, you can use the formula =MROUND(number,5)
Let's take an example that in cell B contains number 17 in Row 6 a...
Univa,
For rounding numbers to t...