dti | : electron : command-line electron devtools installer | DevOps library

I have a monthly dataset and want to resample it to seasonal by adding monthly data.

I have the following df:

I would like to group a Pandas series based on values and then perform an aggregating operation on the index of the series. Pandas isn't recognizing me passing ser.index.

I have some of the host names as provided below, i am looking to extract only last three names after dot .

Is there a way to compare a column with a list of expressions? This is my current code:

I am trying to calculate the perc change occurring between two dates of the values for each id in my df:

I have two pairs of columns I want to merge into one. I am a beginner in R, so I do not know, if what I ask is considered simple or not, but I didn't manage to find what I search for on the Internet.

The first pair of columns are "issue_d" (month and year of loan issue) and "earliest_cr_line" (month and year of earliest credit line being opened by the borrower). They are both filled with values that look this way "Dec-2011". I want to create a new joint column to replace them both by subtracting the date of "earliest_cr_line" from "issue_d" for each row, so that my new column "credit_history_length" represents how much time passed since each borrower opened their first credit before issuing their respective loan. How can I do that? By the way, str(dataframe) shows that the values in both columns are "chr", which stands for "character", I believe; I was somewhat confused by the whole factor/character problem in several posts I have seen here, so I thought I better provide this piece of information just in case.

Additionaly, I have a second pair of columns "fico_range_high" and "fico_range_low", they both contain "int" values like "600" and "608", I want to replace them with a single column that shows the arithmetic means for each row like "604" for the example above.

How can I create the two desired columns?

Edit: As MrSmithGoesToWashington kindly advised, I put a reproducible sample in here:

The connection guide is here. I track the guide and do a lot of stuff. The connection between PLC and SQL server is ok, I've login successfully to SQL.
I can insert to tables, update, and execute store procedures.

But when I run a select query I don't know how to retrieve data and read the values.

I use TIA PORTAL v16.

PLC: S7 1200 siemens

I have a simple table, I wanna simply read an integer, first with one row! then expand my work.

This is my table structure:

I have multiple directories like: