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 5 months agoTue, 12 Feb 2019 07:53:13 -0800 | Last update 4 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 6 months agoTue, 08 Jan 2019 22:34:09 -0800 | Last update 4 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.<b...
[Solved, Basically] Nautilus - Open Multiple Tabs from Command Line?
Answers in Shell Scripting | By August R. Garcia
Published 13 hours agoSat, 20 Jul 2019 23:22:36 -0700 | Last update 13 hours 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 weeks agoFri, 05 Jul 2019 23:22:06 -0700 | Last update 2 weeks 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 4 months agoThu, 14 Mar 2019 06:25:36 -0700 | Last update 4 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 weeks agoTue, 02 Jul 2019 17:29:24 -0700 | Last update 2 weeks 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 Basics to Web Scraping with cURL and XPath
Articles in Web Scraping, Data Analysis | By August R. Garcia
Published 3 weeks agoFri, 28 Jun 2019 09:02:04 -0700 | Last update 2 weeks agoTue, 02 Jul 2019 17:37:33 -0700
Last Reply
Basic DuckDuckGo result scraping:
curl https://duckduckgo.com/html?q=asdf | awk '{$1=$1};1' | sed '/^$/d' | hxselect -c a.result__url | sed '/^$...
August R. Garcia,
Basic DuckDuckGo result s...
The Easiest Way to Build a Reddit Bot?
Forum in Scripting and Automation | By Some Guy
Published 7 months agoSun, 16 Dec 2018 09:40:29 -0800 | Last update 2 weeks 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 6 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 5 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 6 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 1 month 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 2 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 6 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 7 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 2 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 2 months agoWed, 24 Apr 2019 03:29:27 -0700 | Last update 2 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 6 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 7 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 7 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 7 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...
in Linux systems, what file contains the settings for the dhcp service?
Answers in Shell Scripting | By Some Guy
Published 6 months agoSun, 13 Jan 2019 04:17:44 -0800
Last Reply
dhcpd.conf
Should be located at:
/etc/dhcp/dhcpd.conf
August R. Garcia,
dhcpd.conf
How to split cells in Google Sheets?
Answers in Spreadsheets | By Some Guy
Published 7 months agoSun, 16 Dec 2018 09:33:30 -0800
Last Reply
In Google Sheets, paste your data into a column. You’ll see a little clipboard icon appear in the lower right-hand corner of your data. Click on...
Univa,
In Google Sheets, paste y...
[Python] Help with "ValueError: too many values to unpack (expected 2)?"
Answers in Scripting and Automation | By Some Guy
Published 6 months agoSun, 13 Jan 2019 06:10:34 -0800
Last Reply
Before posting any codes try using the formatting tools, sometimes it solves the problem.
You can also try pasting this code:
a_str,...
Univa,
Before posting any codes...
[Python] Fix for "TypeError: 'bool' object is not iterable?"
Answers in Scripting and Automation | By Some Guy
Published 6 months agoSun, 13 Jan 2019 05:39:20 -0800
Last Reply
You probably have your code set up where some value can either be:
An array (or whatever) or
FALSE (for when there are no values)
Th...
August R. Garcia,
You probably have your&nb...
How to find and replace in Excel?
Answers in Spreadsheets | By Some Guy
Published 7 months agoSun, 16 Dec 2018 09:43:56 -0800
Last Reply
Go to the Home tab on the ribbon. Here, click on the Find and Select button. In the drop-down that appears, choose Replace.
Find and Replace was al...
roxblade,
Go to the Home tab on the...
A good Gauss-Jordan calculator?
Answers in Scripting and Automation | By Some Guy
Published 5 months agoWed, 06 Feb 2019 13:47:58 -0800
Last Reply
Not sure if you want to carry an actual calculator around with you on the job but if you're interested in the Gauss-Jordan calculator app from Amazon...
Vrawler119,
Not sure if you want to c...
How to install RetroArch on SNES Classic?
Answers in Machine Learning | By Some Guy
Published 5 months agoWed, 06 Feb 2019 16:08:41 -0800
Last Reply
I looked at different pages trying to figure out which one was best to send you too. The following page should answer your questions and get RetroArch...
thegstocersson,
I looked at different pag...
How to copy formulas in Google Sheets?
Answers in Spreadsheets | By Some Guy
Published 5 months agoWed, 06 Feb 2019 14:50:14 -0800
Last Reply
Select the cell you would want to copy from the formula and select edit on the toolbar. Once selected navigate to copy and you can then paste the form...
KacssPL,
Select the cell you would...
How to use xrange in Python and what's the difference between xrange and range?
Answers in Scripting and Automation | By Some Guy
Published 5 months agoWed, 06 Feb 2019 13:47:38 -0800
Last Reply
Range () returns the values in a limited list, and is an iterable. Xrange is a generator. Xrange can handle a huge list and uses the process of 'yield...
masshoIe3,
Range () returns the valu...