Categories
Mastering Development

Group by and update value based on another column using python

I have a data frame with below columns, using which need to create new columns by grouping Name. Status should be updated as active to entire group if it is active for any one St. data = {‘Name’:[‘Tom’, ‘Tom’, ‘krish’, ‘jack’,’jack’,’Nam’,’sue’], ‘St’:[‘S-123’, ‘S-290’, ‘S-123’, ‘S-147′,’S-98′,’S-123′,’S-38’], ‘Status’:[‘Inactive’,’active’,’active’,’inactive’,’active’,’Inactive’,’Inactive’]} df = pd.DataFrame(data) The desired output is Name St […]

Categories
Database Development

Designing User & its Sub User Database Diagram Problem

There are some business category e.g. Travel Agency, Hotel, Car Rental etc. Roles: Management rolesSuper Admin, Staff Customer side roles are Owner, admin and sales counter May be etc. customer side roles will be added Status i.e. On-Hold, Active, In-Active, Blocked, Deleted etc. Scenario: Each user in the database has its role and status with […]

Categories
Linux Mastering Development Ubuntu

Raspberry Pi 4 ISCSI problem

I have an 8Gig rpi 4b running Ubuntu 20.04.2 LTS that started from image ubuntu-20.04.1-preinstalled-server-arm64+raspi.img downloaded from the web site, and blown onto a microSD via Etcher. No problems booting or accessing. For comparison, I have an amd64 20.04.2 LTS install in a VM on my NAS server. My goal is to boot the rpi […]

Categories
Database Development

JOIN bug in MariaDB 10.2

This is less a question than just a "beware." Thankfully MariaDB 10.2 is an old version, but it does some funky things when joining to nested derived tables. I updated my database from MariaDB 10.0.35 to 10.2.12 and this bug popped up. I tested the same setup and query on 10.0.35, 10.2.12, and 10.4.17 and […]

Categories
Apple User Help

Connecting to a device console using screen shows no output

I am trying to access a network device console from my mac using a Prolific Technology USB-serial adapter to the device’s console. After installing the relevant driver, the adapter is correctly shown: $ ioreg -p IOUSB -l … +-o USB-Serial Controller@14200000 <class AppleUSBDevice, id 0x10000034a, registered, matched, active, busy 0 (101 ms), retain 11> | […]

Categories
User Help

Windows 10 won’t boot after removing data-only hard drive

I’m running Windows 10 on "C". All my data has been stored on "E". I duplicated my files to a new, larger data drive "Z", and removed "E", the old data drive. Suddenly Windows 10 wouldn’t boot: "The boot selection failed because a required device is inaccessible." Once I reconnected "E", Windows 10 booted. Windows […]

Categories
User Help

Windows 10 won’t boot after removing data-only hard drive

"C": Windows 10 SSD "E": Old data HDD (with previous Windows 7 install) "Z": New data HDD I’m running Windows 10 on "C". All my data has been stored on "E". I duplicated my files to "Z", the new data drive, and removed "E", the old data drive. After removing "E", Windows 10 wouldn’t boot: […]

Categories
Mastering Development

merging 3 files in awk based on common keys

3 files: n.txt id-3a,oc-ctrl-jr-0,ACTIVE,-,Running,cp=172.31.0.7 id-5e,oc-ctrl-jr-1,ACTIVE,-,Running,cp=172.31.0.6 id-5f,oc-ctrl-jr-2,ACTIVE,-,Running,cp=172.31.0.5 id-0,oc-comp-jr-0,ACTIVE,-,Running,cp=172.31.0.9 id-77,oc-comp-jr-1,ACTIVE,-,Running,cp=172.31.0.8 bm.txt server-10,id-77,power on,active,False server-2,id-5f,power on,active,False server-32,id-3a,power on,active,False server-11,id-5e,power on,active,False server-25,id-0,power on,active,False The 3rd file consists of sections for each row from bm.txt: hosts.yaml [..] – arch: x86_64 zone: foo cpu: 1 disk: 10 hw_model_type: – bar-8 mac: – aa:aa:aa:aa:aa:aa:aa memory: 4096 name: server-32 desc: ‘my host’ ip_addr: […]

Categories
Mastering Development

Material-ui: Reset slider to default values of min and max

I have a double sided slider component, that I created using @material-ui/core/Slider based on their documentation on customized slider This is what the slider looks like when it first renders When I slide the slider the numbers change, these numbers are are stored in redux and are passed to the text components, but not the […]

Categories
Cryptocurrency Ethereum Mastering Development

web3-react does not appear to be exposing Ethers.js instance

I’ve configured the web3-react package in my project (set up with the React Truffle box) but I don’t seem to be getting an ethers.js instance in the context. According to the package page, the web3-react context provides "library: An instantiated ethers.js or web3.js instance (or the low-level provider object)". It seems that I am getting […]