256 Kilobytes

Scripting and Automation Comments

Type CommentsResponses to top-level threads. Category Scripting and AutomationInformation and discussion of scripting of various types. Tag All

Profile Photo - Univa
Profile Photo - Univa

Create sheets by clicking the "+" button...

MoreCreate sheets by clicking the "+" button at the bottom of your browser window. In Sheet1, type this formula into any cell in column A: =INDIRECT("...
🗨
1
🐏
0
👁
50
Profile Photo - Univa
Profile Photo - Univa

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

Reply to Analyzing the Web: Downloading the Majestic Million, Setting up SQLite, Crawling the Web, and Generating Reports

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

Published 2 weeks agoMon, 29 Apr 2019 09:10:47 -0700 | Last update 2 weeks agoMon, 29 Apr 2019 09:16:15 -0700

Profile Photo - August R. Garcia

The longest domain names in the Majestic...

MoreThe longest domain names in the Majestic Million, most of which are expired and basically all of which are terrible garbage: 255461  ...
🗨
2
🐏
2
👁
40
Profile Photo - Univa
Profile Photo - Univa

Typeerror This Constructor Takes No Argu...

MoreTypeerror This Constructor Takes No Arguments Python Error error codes are caused, in one way or another, by misconfigured system files in your Window...
🗨
1
🐏
0
👁
65
Profile Photo - Hash Brown
Profile Photo - Hash Brown

This is excellent!

MoreThis is excellent!
🗨
2
🐏
2
👁
40
Profile Photo - Univa

Reply to How to use the Quick Analysis tool in Excel 2016?

Comments in Spreadsheets | By Univa

Published 4 weeks agoMon, 22 Apr 2019 08:09:47 -0700

Profile Photo - Univa

More 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...
🗨
1
🐏
0
👁
74
Profile Photo - Univa

Reply to Finding outliers in Excel?

Comments in Spreadsheets | By Univa

Published 4 weeks agoMon, 22 Apr 2019 07:37:10 -0700

Profile Photo - Univa

By using Box and Whisker charts, you can...

MoreBy 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...
🗨
1
🐏
0
👁
60
Profile Photo - Univa

Reply to How to round number to nearest 5 in Excel?

Comments in Spreadsheets | By Univa

Published 1 month agoSat, 20 Apr 2019 09:03:37 -0700

Profile Photo - Univa

For rounding numbers to the nearest 5, y...

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

Reply to ‚Äčin Linux systems, what file contains the settings for the dhcp service?

Comments in Shell Scripting | By August R. Garcia

Published 1 month agoWed, 17 Apr 2019 17:25:05 -0700 | Last update 1 month agoWed, 17 Apr 2019 17:25:42 -0700

Profile Photo - August R. Garcia

dhcpd.conf

Moredhcpd.conf Should be located at: /etc/dhcp/dhcpd.conf
🗨
1
🐏
0
👁
80
Profile Photo - Univa

Reply to How to split cells in Google Sheets?

Comments in Spreadsheets | By Univa

Published 1 month agoTue, 16 Apr 2019 07:58:40 -0700

Profile Photo - Univa

In Google Sheets, paste your data into a...

MoreIn 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...
🗨
1
🐏
0
👁
70
Profile Photo - Univa
Profile Photo - Univa

Before posting any codes try using the f...

MoreBefore posting any codes try using the formatting tools, sometimes it solves the problem.  You can also try pasting this code:  a_str,...
🗨
1
🐏
0
👁
111
Profile Photo - August R. Garcia

Reply to [Python] Fix for "TypeError: 'bool' object is not iterable?"

Comments in Scripting and Automation | By August R. Garcia

Published 1 month agoSun, 07 Apr 2019 12:14:43 -0700 | Last update 1 month agoSun, 07 Apr 2019 12:14:55 -0700

Profile Photo - August R. Garcia

You probably have your code set up...

MoreYou 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...
🗨
1
🐏
0
👁
262
Profile Photo - roxblade

Reply to How to find and replace in Excel?

Comments in Spreadsheets | By roxblade

Published 1 month agoThu, 04 Apr 2019 04:37:24 -0700

Profile Photo - roxblade

Go to the Home tab on the ribbon. Here,...

MoreGo 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...
🗨
1
🐏
0
👁
75
Profile Photo - Vrawler119

Reply to A good Gauss-Jordan calculator?

Comments in Scripting and Automation | By Vrawler119

Published 1 month agoSat, 30 Mar 2019 15:52:58 -0700

Profile Photo - Vrawler119

Not sure if you want to carry an actual...

MoreNot 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...
🗨
1
🐏
0
👁
56
Profile Photo - thegstocersson

Reply to How to install RetroArch on SNES Classic?

Comments in Machine Learning | By thegstocersson

Published 1 month agoSat, 30 Mar 2019 14:55:55 -0700

Profile Photo - thegstocersson

I looked at different pages trying to fi...

MoreI 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...
🗨
1
🐏
0
👁
93
Profile Photo - KacssPL

Reply to How to copy formulas in Google Sheets?

Comments in Spreadsheets | By KacssPL

Published 1 month agoSat, 30 Mar 2019 14:37:55 -0700

Profile Photo - KacssPL

Select the cell you would want to copy f...

MoreSelect 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...
🗨
1
🐏
0
👁
74
Profile Photo - masshoIe3
Profile Photo - masshoIe3

Range () returns the values in a limited...

MoreRange () 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...
🗨
1
🐏
0
👁
47
Profile Photo - krobidson_3232
Profile Photo - krobidson_3232

There are multiple places that you can f...

MoreThere are multiple places that you can find a a good pool volume calculator. I found the best option with the most details is hosted at www.swimmingpo...
🗨
1
🐏
0
👁
48
Profile Photo - WTCMolybdenam4753

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

Comments in Spreadsheets | By WTCMolybdenam4753

Published 1 month agoSat, 30 Mar 2019 14:03:29 -0700

Profile Photo - WTCMolybdenam4753

After searching on the internet, I found...

MoreAfter searching on the internet, I found this helpful link which seems to explain in detail about the Dollar Sign in Google sheets. Here is the link:...
🗨
1
🐏
0
👁
74
Profile Photo - Zhaybib

Reply to How to fix content file locked?

Comments in Machine Learning | By Zhaybib

Published 1 month agoSat, 30 Mar 2019 13:59:47 -0700

Profile Photo - Zhaybib

Since you are trying to understand why t...

MoreSince you are trying to understand why the content file is locked, check out this Reddit discussion right here, https://www.reddit.com/r/Steam/comment...
🗨
1
🐏
0
👁
79
Profile Photo - -alxl_
Profile Photo - -alxl_

Having these error messages come up can...

MoreHaving these error messages come up can be frustrating to work with. Without seeing specifics/knowing more of the spreadsheet you deal with it can be...
🗨
1
🐏
0
👁
109
Profile Photo - Zhaybib

Reply to How to print without a newline in Python?

Comments in Scripting and Automation | By Zhaybib

Published 1 month agoSat, 30 Mar 2019 13:39:40 -0700

Profile Photo - Zhaybib

Since you say that you are curious as to...

MoreSince you say that you are curious as to how to print without a newline in Python, I suggest that you look here, https://stackoverflow.com/questions/4...
🗨
1
🐏
0
👁
35
Profile Photo - Univa

Reply to How to apply a formula to an entire column in Excel?

Comments in Spreadsheets | By Univa

Published 1 month agoWed, 27 Mar 2019 11:41:15 -0700

Profile Photo - Univa

Follow the steps below to apply the form...

MoreFollow the steps below to apply the formula quickly to entire rows or columns in Excel. METHOD 1: Drag the fill handle to copy the formula In...
🗨
1
🐏
0
👁
66
Profile Photo - roxblade

Reply to How to tab in Google Sheets?

Comments in Spreadsheets | By roxblade

Published 1 month agoThu, 21 Mar 2019 01:07:37 -0700

Profile Photo - roxblade

I believe you mean another sheet, right?...

MoreI believe you mean another sheet, right? On the bottom of the screen, you will find a bar that houses your sheet on the left. Further left and, in fac...
🗨
1
🐏
0
👁
74
Profile Photo - entrokamoI
Profile Photo - entrokamoI

ls isn't actually a built-in for Windows...

Morels isn't actually a built-in for Windows. It's a command meant to be used on Unix machines such as those running MacOS or Linux. If you want to achiev...
🗨
1
🐏
0
👁
43
Profile Photo - Japanese

Reply to Best PowerShell scripting tutorials?

Comments in Shell Scripting | By Japanese

Published 1 month agoWed, 20 Mar 2019 14:25:13 -0700

Profile Photo - Japanese

Since this was developed by Microsoft in...

MoreSince this was developed by Microsoft in 2003, it makes sense to start with Microsoft tutorials. Microsoft Virtual Academy (MVA) has many tutorials on...
🗨
1
🐏
0
👁
47
Profile Photo - Edgelady43069
Profile Photo - Edgelady43069

The Base scripting keyword that terminat...

MoreThe Base scripting keyword that terminates a case statement is esac to end a case statement. Which is actually case spelled backwards.
🗨
1
🐏
0
👁
38
Profile Photo - Zhaybib

Reply to How do you know whether a PowerShell tutorial is good or not?

Comments in Shell Scripting | By Zhaybib

Published 2 months agoWed, 20 Mar 2019 05:10:56 -0700

Profile Photo - Zhaybib

Many people who are interested in learni...

MoreMany people who are interested in learning PowerShell, will seek out a tutorial on the internet to help. Not all tutorials are created equal, but I wo...
🗨
1
🐏
0
👁
36
Profile Photo - Edgelady43069
Profile Photo - Edgelady43069

This is the easiest and quickest way: 1....

MoreThis is the easiest and quickest way: 1. Open File Explorer. 2. Browse to the folder that includes all the files you want to rename. 3. Select the fir...
🗨
1
🐏
0
👁
45
Profile Photo - August R. Garcia

Reply to Downloading Bulk "ThisPersonDoesNotExist" Images with Python and urllib2

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

Published 2 months agoThu, 14 Mar 2019 06:40:22 -0700 | Last update 2 months agoThu, 14 Mar 2019 06:41:03 -0700

Profile Photo - August R. Garcia

Also, this is a crime against God:

MoreAlso, this is a crime against God:
🗨
1
🐏
0
👁
31