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 | Last Update 📌
Last ReplyAny 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 | Last Update 📌
Last ReplyVery 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.
[Python] Solution to "TypeError: a bytes-like object is required, not 'str'?"
Answers in Scripting and Automation | By Some Guy
Published
Last ReplyPython makes a clear distinction between bytes and strings . Bytes objects contain raw data — a sequence of octets — whereas strings are U... bennetcole,
Python makes a clear dist...
[Python] Help with "TypeError: 'float' object cannot be interpreted as an integer?"
Answers in Scripting and Automation | By Some Guy
Published
Last ReplyWhen we try to use float numbers in Python range() function, we get a type error 'float' object that cannot be interpreted as an integer.&nb... rahuldev,
When we try to use float...
[Python] Fix for "TypeError: can't convert 'int' object to str implicitly?"
Answers in Scripting and Automation | By Some Guy
Published
Last ReplyExplicitly cast the int object to a string: x = 10 # Integer print("X is set to " + str(10)) # Explicitly a string August R. Garcia,
Explicitly cast the int o...
Last ReplyWait, is this a spam post? You got me. ThanhKim,
Wait, is this a spam post...
Fix "typeerror: 'module' object is not callable"?
Answers in Scripting and Automation | By Some Guy
Published
Last ReplyThis 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
Last ReplyIf 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
Last ReplyIt'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
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
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
Last ReplyWhat 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
Last ReplyCast 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
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
Last ReplyHere'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 | Last Update
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 | Last Update
Last ReplyThank 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
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
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 | Last Update
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
Last ReplyFor 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
Last ReplyRan 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 | Last Update
Last ReplyBump. 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 | Last Update
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 | Last Update
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
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 | Last Update
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 | Last Update
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 | Last Update
Last ReplyHere'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 | Last Update
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...