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

Split dataframe with all values in one row

I got the following dataframe which is created dynamically but saves all the relevant values into one row: df +—————-+—————-+—————-+—————-+ | 1 | 2 | 3 | 4 | +—————-+—————-+—————-+—————-+ | a1, b1, c1, d1 | a2, b2, c2, d2 | a3, b3, c3, d3 | a4, b4, c4, d4 | +—————-+—————-+—————-+—————-+ I need to […]

Categories
Mastering Development

Grouping Nodes by hardcoding node values in XSLT

<root> <Entry> <ID>1</ID> <Details> <Code>A1</Code> <Value>1000</Value> </Details> </Entry> <Entry> <ID>2</ID> <Details> <Code>A2</Code> <Value>2000</Value> </Details> </Entry> <Entry> <ID>3</ID> <Details> <Code>B1</Code> <Value>3000</Value> </Details> </Entry> <Entry> <ID>4</ID> <Details> <Code>B2</Code> <Value>4000</Value> </Details> </Entry> </root> I have this input XML which I am looking to group via XSLT wherein the grouping happens by hardcoding node values. Let me explain that […]

Categories
Mastering Development

Filter dataframe by logic

I have this dataframe: MAT MAT_IN SER D8 0 X A1 Yes – 1 X A2 No X 2 X A3 No X 3 X A4 Yes X 4 Y B1 No – 5 Y B2 No – 6 Y B3 No – 7 Y B4 No – 8 Y B5 No – Where I […]

Categories
Mastering Development

Compare two list dataframe columns and get duplicate elements using pandas

I have a two list columns in a dataframe. One column have unique list elements and another column have duplicate list elements. How can i compare two columns and exact occurrences of the list elements including duplicates into a new dataframe column. Example: df = pd.DataFrame({‘A’:[[‘1’, ‘2’],[‘3’, ‘4’],[‘8′,’9’]], ‘B’:[[‘1’, ‘1’, ‘2’],[‘3’, ‘3’, ‘3’, ‘4’, ‘4’, […]

Categories
Mastering Development

How can I check if I have written a number or a letter in c++?

This is my first time on stackoverflow. I can not figure out how I can check if I have written a number or a letter. If i have written a letter I want the program to say that I neat to write a correct number. Everything is working except the part where the program asks […]

Categories
Mastering Development

How can I split a row into multiple rows depending on multiple columns?

I have the following row (I use the character "|" to separate columns): A, B|1, 2, 3|0, 1, 2 and I want to obtain the following rows in a separate sheet: A|1|0 A|1|1 A|1|2 A|2|0 A|2|1 A|2|2 A|3|0 A|3|1 A|3|2 B|1|0 B|1|1 B|1|2 B|2|0 B|2|1 B|2|2 B|3|0 B|3|1 B|3|2 I tried the following (row is […]

Categories
Mastering Development

Include rows for which values in col b1 is not present in row b2 and vice versa

I have a dataframe, and from this I would like a new dataframe, which includes all rows for which the values in row b1 are not present in row b2 and vice versa. Anyone who has a good idea? I have four coloumns (a1, b1, a2, b2), and they have different lenghts, but have just […]

Categories
Linux Mastering Development

Running a code on a set of files in mac terminal

I have a script which modifies .txt files This is my script awk ‘BEGIN{FS=OFS="\t"}{split($1,a,"_"); split(a[3],b,"/"); print a[1],a[2],b[1],b[2],$0}’ file.txt | awk ‘BEGIN{FS=OFS="\t"}{split($18,a,";"); split(a[2],b,"="); print b[2],$0}’ > out_file.txt I have a bunch of files in a folder I want to run this script on my files and return each output bythe name of original file I tried […]

Categories
Mastering Development

Function from script editor works fine but not from sheets -Google apps sctipt/calendar/sheets

I wrote a function that adds an all day event. When the function running from script editor it’s works fine, the all day event is insert to the calendar. But when I’m running the function in the active spreadsheet =addevent(a1,b1,c1,d1) I’m getting an error saying : Exception: The script does not have permission to perform […]