Categories
Database Development

What C# type is the correct representation for DB2 UDB boolean?

The project that I work on uses IBM.Data.DB2 nuget package for its data layer. I need to call into utl_mail.send_attach_varchar2 stored procedure on the DB2 side. It has a boolean parameter att_inline for which I initially tried to supply DB2Type.Boolean data type. This does not work due to this error when adding it: {"Specified argument […]

Categories
User Help

OneDrive Screw Up (How to Repair)

Long, weird, story. We ordered a laptop. It has a short: shocks us, completely crashes, and reboots. We’re sending it back. We ordered an AIO as a replacement. Works fine. Wife had stuff on the laptop. She hand moved most of it to the AIO. OneDrive synced everything it had from the problem laptop to […]

Categories
Mastering Development

create 1D array from data frame column

I am looking for a way to get class label from my dataframe containing rows of features. For instance, in this example: df = pd.DataFrame([ [‘1’, ‘a’, ‘bb’, ‘0’], [‘1’, ‘a’, ‘cc’, ‘0’], [‘2’, ‘a’, ‘dd’, ‘1’], [‘2’, ‘a’, ‘ee’, ‘1’], [‘3’, ‘a’, ‘ff’, ‘2’], [‘3’, ‘a’, ‘gg’, ‘2’], [‘3’, ‘a’, ‘hh’, ‘2’]], columns = […]

Categories
Ask Engineering

Connecting 2P2S Battery Pack to BMS and Charging Controller

Im trying to design home project for hobby. This project supposed to keep a micro-controller up and running as much as possible with solar cell and batteries. The micro-controller (needs 5v and about 250mA) and the solar cell is up to 9v In order to backup the solar cell and get more voltage and current, […]

Categories
Mastering Development

WOE in a magrittr Pipe

How can I get the weight of evidence code below into a magrittr pipeline (df %>%)? Nothing I’ve tried seems to work. df: library(Information) library(magrittr) #df a = c("aa", "bb", "cc", "aa", "aa", "aa", "bb", "cc", "bb", "bb") b = c("aa", "bb", "cc", "aa", "aa", "aa", "bb", "cc", "bb", "bb") c = c("aa", "bb", "cc", […]

Categories
Mastering Development

create nested JSON from Pandas DataFrame with grouped rows as attributes inside deepest nest

I’m looking for a solution to build a nested dict / JSON with the last three columns "name", "color", "amount" as attributes inside a "products" list. The values from the cat1-cat3 columns should be the keys. The provided DataFrame looks like this: import pandas as pd df = pd.DataFrame({ ‘cat1’: [‘A’, ‘A’, ‘A’, ‘B’, ‘B’, […]

Categories
Mastering Development

Find and group elements on tape of data?

I have got sequence of stings like: "aa", "lot", "bb", "obj", "obj", "obj", "cc", "lot", "obj", "gg", "lot", "obj", "obj" I need to calculate how much every lot have obj. Something like: [lot 3 obj] [lot 1 obj] [lot 2 obj] Or sometinkg like this. String have some crap – any other symbols except lot […]

Categories
Linux Mastering Development

awk – , extract dynamic fields and output into fixed format with combination of other fields

Input column 1 & 2 (first 2 col) and last 2 fields are fixed, while column 3-12 are dynamic, and it will be printed with fixed format, 10 columns with delimited by |. Column 3,5,7,9,11 (CA,CB,CC,CD,CE) are index key and column 4,6,8,10,12 are the value. intput: 10|100|C_A|val_18|C_D|val_20|50|60 40|200|C_A|val_5|C_B|val_10|C_C|val_30|C_D|val_90|C_E|val_83|40|45 80|100|C_E|val_90|50|60 eg. 10|100 => first 2 col, […]

Categories
Linux Mastering Development

Extract information between double quotes on .csv

I’m having some problems with a script parsing a .csv file Information on .csv: #1,13/8/2020,somedude@hotmail.com,otherdude@hotmail.com,,Subject,"Dear Dude, Information have been updated. Please login to APP to review by 30th August 2020. Thank you. Best regards, Mr. Mack",Pending,13/8/2020 12:35 This is how information should be partioned: MsgID,Date,To,CC,BCC,Subject,Body,Status,Timestamp MsgID=#1 Date=13/8/2020 To=somedude@hotmail.com CC=otherdude@hotmail.com BCC= Subject=Subject Body=Dear Dude, Information have […]

Categories
User Help Web Apps

Gmail is not suggesting suggest addresses from my previous emails Ids during email composing

When I type first few letter of an address in the ~To~, ~Cc~, or ~Bcc~ field during email composing, Gmail is not suggesting suggest addresses from my previous emails IDs. For example, before, when I need to type the ID ~xyz2050@gmail.com~ during mailcompose, when I just used to type first few letters, say, ~xyx~, a […]