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 9 months agoTue, 12 Feb 2019 07:53:13 -0800 | Last update 8 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 10 months agoTue, 08 Jan 2019 22:34:09 -0800 | Last update 8 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.
How to fix "indexerror: arrays used as indices must be of integer (or boolean) type?"
Answers in Scripting and Automation | By Some Guy
Published 10 months agoSun, 13 Jan 2019 04:06:53 -0800
Last Reply
It's possible that if you have an array of values that you believe to be integers, that at some point they were converted to floats. Try printing out...
August R. Garcia,
It's possible that if you...
[Solved] Python - ValueError: unsupported format character ')' (0x29) at index 113
Answers in Scripting and Automation | By August R. Garcia
Published 3 weeks agoSat, 26 Oct 2019 01:56:29 -0700
Alternatively "TypeError: %o format: an...
MoreThis is technically a different error message, but is what was causing the issue. string = "The value is one hundred (100)." # Raises an error...[Solved] How to un-shorten/resolve Twitter's t.co links using Python
Answers in Web Scraping, Data Analysis | By August R. Garcia
Published 4 weeks agoFri, 18 Oct 2019 07:49:38 -0700
TFW
MoreSee code. Yeah, it seems like you do in fact have to make a bunch of additional HTTP requests. def resolve_t_co(t_co_url): if t_co_url !...[Python] Fix for "TypeError: unsupported operand type(s) for - or / or + 'str'/'int'/'nonetype'/'list' and 'str'?"
Answers in Scripting and Automation | By Some Guy
Published 10 months agoSun, 13 Jan 2019 05:57:52 -0800
Last Reply
What the fuck is this question. This is like eight different errors. The answer is probably to cast something as something else. Look at this thread:...
August R. Garcia,
What the fuck is this que...
[Python] Fix for "TypeError: can only concatenate str (not "int") to str?"
Answers in Scripting and Automation | By Some Guy
Published 10 months agoSun, 13 Jan 2019 05:45:01 -0800
Last Reply
Cast the integer to be a string.
# Probably something like this is causing the error
x = 3
text = "whatever"
# "TypeError: unsupported op...
August R. Garcia,
Cast the integer to be a...
[Solved] Running Selenium with a Proxy (Python, FireFox)
Answers in Web Scraping, Data Analysis | By August R. Garcia
Published 1 month agoThu, 17 Oct 2019 07:37:05 -0700
It's time to post code so that I can fin...
MoreIt's time to post code so that I can find this the next eight times I need to do this: # ##### ##### ################# ##### ##### # # ##### ###...[Solved] Scraping Number of Search Results from Bing with Google Sheets
Answers in Web Scraping, Data Analysis | By August R. Garcia
Published 1 month agoFri, 20 Sep 2019 10:59:05 -0700
Last Reply
Here's a better version that removes the " results" string and then casts the result to a number instead of a string:
=VALUE(substitute(importXML...
August R. Garcia,
Here's a better version t...
[Solved] Python - Getting the remote/server IP address and port from an HTTP response using the requests library?
Answers in Web Scraping, Data Analysis | By August R. Garcia
Published 1 month agoWed, 25 Sep 2019 15:54:55 -0700 | Last update 1 month agoThu, 26 Sep 2019 13:25:27 -0700
Some edge case what even is this.
MoreThe solution here seems to generally work: https://stackoverflow.com/questions/22492484/how-do-i-get-the-ip-address-from-a-http-request-using-th...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 months agoThu, 05 Sep 2019 04:39:30 -0700 | Last update 2 months agoThu, 05 Sep 2019 05:15:22 -0700
Last Reply
Thank you for the post.
Blogger at Radio Box
https://www.youtube.com/watch?v=Jfh_qbzhUKI
RadioBox,
Thank you for the post.
[Solved] Correct-Horse-Battery-Staple Implementations (Misc. Languages)
Answers in Scripting and Automation | By August R. Garcia
Published 2 months 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 2 months 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 2 months agoSun, 15 Sep 2019 17:06:46 -0700 | Last update 2 months 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 3 months 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 11 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...
The Basics to Web Scraping with cURL and XPath
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 4 months agoFri, 28 Jun 2019 09:02:04 -0700 | Last update 4 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 2 months agoSun, 25 Aug 2019 12:04:00 -0700 | Last update 2 months 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 3 months agoFri, 16 Aug 2019 06:38:19 -0700 | Last update 2 months 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 3 months 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 3 months agoSat, 20 Jul 2019 23:22:36 -0700 | Last update 3 months 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 4 months agoFri, 05 Jul 2019 23:22:06 -0700 | Last update 4 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 8 months agoThu, 14 Mar 2019 06:25:36 -0700 | Last update 8 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 4 months agoTue, 02 Jul 2019 17:29:24 -0700 | Last update 4 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 11 months agoSun, 16 Dec 2018 09:40:29 -0800 | Last update 4 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 10 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 9 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 10 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 5 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 6 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...