256 Kilobytes

Scripting and Automation

Type All Category Scripting and AutomationInformation and discussion of scripting of various types. Tag All

Profile Photo - August R. Garcia

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 📌

Profile Photo - Hash Brown

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...

Mon, 27 May 2019 07:59:54 -0700 1 month ago
🗨
2
🐏
2
👁
1,553
Profile Photo - Hash Brown

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 📌

Profile Photo - August R. Garcia

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...

Wed, 09 Jan 2019 03:16:31 -0800 6 months ago
🗨
1
🐏
1
👁
1,220
Profile Photo - August R. Garcia

[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

Profile Photo - August R. Garcia

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....
🗨
0
🐏
0
👁
5
Profile Photo - August R. Garcia

[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

Profile Photo - August R. Garcia

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...
🗨
0
🐏
1
👁
69
Profile Photo - August R. Garcia

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

Profile Photo - August R. Garcia

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...

Thu, 04 Jul 2019 12:56:36 -0700 2 weeks ago
🗨
2
🐏
0
👁
2,465
Profile Photo - August R. Garcia

[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

Profile Photo - August R. Garcia

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...
🗨
0
🐏
0
👁
131
Profile Photo - August R. Garcia

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

Profile Photo - August R. Garcia

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...

Mon, 01 Jul 2019 15:56:40 -0700 2 weeks ago
🗨
3
🐏
2
👁
405
Profile Photo - Some Guy

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

Profile Photo - August R. Garcia

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...

Sun, 30 Jun 2019 14:54:58 -0700 2 weeks ago
🗨
2
🐏
0
👁
113
Profile Photo - Some Guy
Profile Photo - Univa

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...

Sat, 01 Jun 2019 09:14:49 -0700 1 month ago
🗨
1
🐏
0
👁
147
Profile Photo - Some Guy

[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

Profile Photo - Univa

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...

Fri, 31 May 2019 10:47:38 -0700 1 month ago
🗨
2
🐏
0
👁
142
Profile Photo - Some Guy
Profile Photo - Univa

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...

Sun, 26 May 2019 10:46:17 -0700 1 month ago
🗨
1
🐏
0
👁
133
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

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...
🗨
0
🐏
0
👁
200
Profile Photo - Whisky Fren
Profile Photo - Whisky Fren

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...
🗨
0
🐏
0
👁
101
Profile Photo - Some Guy
Profile Photo - Univa

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...

Thu, 16 May 2019 08:10:10 -0700 2 months ago
🗨
1
🐏
0
👁
129
Profile Photo - Some Guy
Profile Photo - Univa

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,

Sun, 05 May 2019 03:19:56 -0700 2 months ago
🗨
1
🐏
0
👁
171
Profile Photo - August R. Garcia

[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

Profile Photo - August R. Garcia

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...
🗨
0
🐏
0
👁
137
Profile Photo - August R. Garcia

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

Profile Photo - August R. Garcia

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...

Mon, 29 Apr 2019 09:10:47 -0700 2 months ago
🗨
2
🐏
2
👁
263
Profile Photo - Some Guy
Profile Photo - Univa

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...

Fri, 26 Apr 2019 08:18:20 -0700 2 months ago
🗨
1
🐏
0
👁
139
Profile Photo - Some Guy

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

Profile Photo - Univa

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,

Mon, 22 Apr 2019 08:09:47 -0700 2 months ago
🗨
1
🐏
0
👁
144
Profile Photo - Some Guy

Finding outliers in Excel?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:37:00 -0800

Profile Photo - Univa

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...

Mon, 22 Apr 2019 07:37:10 -0700 2 months ago
🗨
1
🐏
0
👁
116
Profile Photo - Some Guy

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

Profile Photo - Univa

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...

Sat, 20 Apr 2019 09:03:37 -0700 3 months ago
🗨
1
🐏
0
👁
137
Profile Photo - Some Guy
Profile Photo - August R. Garcia

Last Reply dhcpd.conf Should be located at: /etc/dhcp/dhcpd.conf August R. Garcia,

dhcpd.conf

Wed, 17 Apr 2019 17:25:05 -0700 3 months ago
🗨
1
🐏
0
👁
137
Profile Photo - Some Guy

How to split cells in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:33:30 -0800

Profile Photo - Univa

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...

Tue, 16 Apr 2019 07:58:40 -0700 3 months ago
🗨
1
🐏
0
👁
120
Profile Photo - Some Guy
Profile Photo - Univa

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...

Sun, 14 Apr 2019 03:06:36 -0700 3 months ago
🗨
1
🐏
0
👁
188
Profile Photo - Some Guy

[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

Profile Photo - August R. Garcia

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...

Sun, 07 Apr 2019 12:14:43 -0700 3 months ago
🗨
1
🐏
0
👁
557
Profile Photo - Some Guy

How to find and replace in Excel?

Answers in Spreadsheets | By Some Guy

Published 7 months agoSun, 16 Dec 2018 09:43:56 -0800

Profile Photo - roxblade

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...

Thu, 04 Apr 2019 04:37:24 -0700 3 months ago
🗨
1
🐏
0
👁
134
Profile Photo - Some Guy

A good Gauss-Jordan calculator?

Answers in Scripting and Automation | By Some Guy

Published 5 months agoWed, 06 Feb 2019 13:47:58 -0800

Profile Photo - Vrawler119

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...

Sat, 30 Mar 2019 15:52:58 -0700 3 months ago
🗨
1
🐏
0
👁
113
Profile Photo - Some Guy

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

Profile Photo - thegstocersson

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...

Sat, 30 Mar 2019 14:55:55 -0700 3 months ago
🗨
1
🐏
0
👁
149
Profile Photo - Some Guy

How to copy formulas in Google Sheets?

Answers in Spreadsheets | By Some Guy

Published 5 months agoWed, 06 Feb 2019 14:50:14 -0800

Profile Photo - KacssPL

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...

Sat, 30 Mar 2019 14:37:55 -0700 3 months ago
🗨
1
🐏
0
👁
129
Profile Photo - Some Guy
Profile Photo - masshoIe3

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...

Sat, 30 Mar 2019 14:25:29 -0700 3 months ago
🗨
1
🐏
0
👁
102