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 11 months agoTue, 12 Feb 2019 07:53:13 -0800 | Last update 10 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 1 year agoTue, 08 Jan 2019 22:34:09 -0800 | Last update 10 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.
Fix "typeerror: 'module' object is not callable"?
Answers in Scripting and Automation | By Some Guy
Published 1 year agoSun, 16 Dec 2018 09:37:24 -0800
Last Reply
This error is likely occurring because of code that involves a module that contains a function that has the same name as the module. For example, the...
August R. Garcia,
This error is likely occu...
[Python] Solution to "ValueError: cannot convert float nan to integer?"
Answers in Scripting and Automation | By Some Guy
Published 1 year agoSun, 13 Jan 2019 06:04:53 -0800
Last Reply
If there are some scenarios where the value is actually not intended to be a number, this can also be solved with a try-catch block:
try:
#...
August R. Garcia,
If there are some scenari...
How to fix "indexerror: arrays used as indices must be of integer (or boolean) type?"
Answers in Scripting and Automation | By Some Guy
Published 1 year 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 months 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 3 months 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 1 year 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 1 year 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 3 months 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 4 months 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 4 months agoWed, 25 Sep 2019 15:54:55 -0700 | Last update 3 months 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 4 months agoThu, 05 Sep 2019 04:39:30 -0700 | Last update 4 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 4 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 4 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 4 months agoSun, 15 Sep 2019 17:06:46 -0700 | Last update 4 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 5 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 1 year 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 6 months agoFri, 28 Jun 2019 09:02:04 -0700 | Last update 6 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 5 months agoSun, 25 Aug 2019 12:04:00 -0700 | Last update 5 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 5 months agoFri, 16 Aug 2019 06:38:19 -0700 | Last update 5 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 6 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 6 months agoSat, 20 Jul 2019 23:22:36 -0700 | Last update 6 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 6 months agoFri, 05 Jul 2019 23:22:06 -0700 | Last update 6 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 10 months agoThu, 14 Mar 2019 06:25:36 -0700 | Last update 10 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 6 months agoTue, 02 Jul 2019 17:29:24 -0700 | Last update 6 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 1 year agoSun, 16 Dec 2018 09:40:29 -0800 | Last update 6 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 1 year 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 11 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 1 year 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...