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 7 months agoTue, 12 Feb 2019 07:53:13 -0800 | Last update 6 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 3 months ago
🗨
2
🐏
2
👁
1,842
Profile Photo - Hash Brown

An introduction to scraping with Python and BeautifulSoup

Articles in Web Scraping, Data Analysis | By Hash Brown

Published 8 months agoTue, 08 Jan 2019 22:34:09 -0800 | Last update 6 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.

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

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

[Solved] How to Get Random Punctuation in Python

Answers in Scripting and Automation | By August R. Garcia

Published 3 days agoMon, 16 Sep 2019 19:14:26 -0700

Profile Photo - August R. Garcia

Code:

MoreCode: # string.punctuation contains the following characters: # !"#$%&'()*+,-./:;<=>?@[\]^_`{|}~ import random, string print( rand...
🗨
0
🐏
0
👁
15
Profile Photo - August R. Garcia

[Solved] How to immediately kill all Python threads when working with multithreading

Answers in Scripting and Automation | By August R. Garcia

Published 4 days agoSun, 15 Sep 2019 17:06:46 -0700 | Last update 4 days agoSun, 15 Sep 2019 20:49:11 -0700

Profile Photo - August R. Garcia

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

[Solved] Color code HTTP status codes in Python

Answers in Web Scraping, Data Analysis | By August R. Garcia

Published 1 month agoMon, 29 Jul 2019 22:34:12 -0700

Profile Photo - August R. Garcia

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:

Mon, 09 Sep 2019 12:10:10 -0700 1 week ago
🗨
1
🐏
0
👁
118
Profile Photo - Some Guy

Solve "Typeerror: unhashable type: 'list'"?

Answers in Scripting and Automation | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:34:42 -0800

Profile Photo - August R. Garcia

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

Thu, 05 Sep 2019 07:50:44 -0700 2 weeks ago
🗨
2
🐏
0
👁
363
Profile Photo - August R. Garcia

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 weeks agoThu, 05 Sep 2019 04:39:30 -0700 | Last update 2 weeks agoThu, 05 Sep 2019 05:15:22 -0700

Profile Photo - Hash Brown

Last Reply Hell motherfucking yeah sir Hash Brown,

Hell motherfucking yeah s...

Thu, 05 Sep 2019 06:55:40 -0700 2 weeks ago
🗨
1
🐏
1
👁
136
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 2 months agoFri, 28 Jun 2019 09:02:04 -0700 | Last update 2 months agoTue, 02 Jul 2019 17:37:33 -0700

Profile Photo - August R. Garcia

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

Thu, 29 Aug 2019 18:31:09 -0700 3 weeks ago
🗨
4
🐏
2
👁
656
Profile Photo - August R. Garcia

[Solved] Basic progress bar functionality with Python

Answers in Scripting and Automation | By August R. Garcia

Published 3 weeks agoSun, 25 Aug 2019 12:04:00 -0700 | Last update 3 weeks agoSun, 25 Aug 2019 12:06:08 -0700

Profile Photo - August R. Garcia

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

[Solved] How to Show Number of Remaining Threads in Python

Answers in Scripting and Automation | By August R. Garcia

Published 1 month agoFri, 16 Aug 2019 06:38:19 -0700 | Last update 3 weeks agoMon, 26 Aug 2019 01:21:58 -0700

Profile Photo - August R. Garcia

Self explanatory, mostly.

MoreSelf explanatory, mostly. Original Code import Queue from threading import Thread, active_count import time que = Queue.Queue()...
🗨
0
🐏
0
👁
78
Profile Photo - August R. Garcia
Profile Photo - August R. Garcia

The answer is to fucking kill yourself.<...

MoreThe answer is to fucking kill yourself.
🗨
0
🐏
0
👁
100
Profile Photo - August R. Garcia

[Solved, Basically] Nautilus - Open Multiple Tabs from Command Line?

Answers in Shell Scripting | By August R. Garcia

Published 1 month agoSat, 20 Jul 2019 23:22:36 -0700 | Last update 1 month 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
🐏
2
👁
106
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 months agoFri, 05 Jul 2019 23:22:06 -0700 | Last update 2 months 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
👁
273
Profile Photo - August R. Garcia

Downloading Bulk Images: ThisPersonDoesNotExist with Python and urllib2

Articles in Web Scraping, Data Analysis | By August R. Garcia

Published 6 months agoThu, 14 Mar 2019 06:25:36 -0700 | Last update 6 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 months ago
🗨
2
🐏
0
👁
2,978
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 months agoTue, 02 Jul 2019 17:29:24 -0700 | Last update 2 months 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
👁
503
Profile Photo - Some Guy

The Easiest Way to Build a Reddit Bot?

Forum in Scripting and Automation | By Some Guy

Published 9 months agoSun, 16 Dec 2018 09:40:29 -0800 | Last update 2 months 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 months ago
🗨
2
🐏
0
👁
199
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 3 months ago
🗨
1
🐏
0
👁
229
Profile Photo - Some Guy

[Google Sheets] Dollar sign usage? What does it do?

Answers in Spreadsheets | By Some Guy

Published 7 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 3 months ago
🗨
2
🐏
0
👁
211
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 3 months ago
🗨
1
🐏
0
👁
196
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
👁
288
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
👁
152
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 4 months ago
🗨
1
🐏
0
👁
190
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 4 months ago
🗨
1
🐏
0
👁
229
Profile Photo - August R. Garcia

[Infographic] The Beginner's SQLite Cheat Sheet

Articles in Web Scraping, Data Analysis | By August R. Garcia

Published 4 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
👁
233
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 4 months agoWed, 24 Apr 2019 03:29:27 -0700 | Last update 4 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 4 months ago
🗨
2
🐏
2
👁
419
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 4 months ago
🗨
1
🐏
0
👁
203
Profile Photo - Some Guy

How to use the Quick Analysis tool in Excel 2016?

Answers in Spreadsheets | By Some Guy

Published 9 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 4 months ago
🗨
1
🐏
0
👁
201
Profile Photo - Some Guy

Finding outliers in Excel?

Answers in Spreadsheets | By Some Guy

Published 9 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 4 months ago
🗨
1
🐏
0
👁
175
Profile Photo - Some Guy

How to round number to nearest 5 in Excel?

Answers in Spreadsheets | By Some Guy

Published 9 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 4 months ago
🗨
1
🐏
0
👁
193