Categories
Mastering Development

How do I map through an array A to check if particular values from array A exist in array B using .some()?

Does cityWithMostRoads form a pair with filteredCityList[i][0] that exists in array roads? i can be any number that is less than filteredCityList.length. Using cityWithMostRoads and filteredCityList[i][0], an example of a pair would be [0 , 1] or [1, 0]. const roads = [[0,1],[0,3],[1,2],[1,3]]; const cityWithMostRoads = 1; let filteredCityList = [["0", 2],["3", 2]]; This is […]

Categories
Mastering Development

Breaking a wide dataframe to two uneven column dataframe and change it to long formate

I have a wide table with more than 22 columns. This table is the result of fuzzymatch and that’s why it’s in wide format. The column names are shown below (in order) (I will try to create a sample data frame for better demonstration): [1] "shift_date.x" "shift" "ageyrs" "site" "level" [6] "crowded_shift" "time" "dd" "AE" […]

Categories
Linux Mastering Development

Output from Bonnie++ doesn’t match up

I just ran bonnie++ ten times to test the performance of a file server. After removing the verbose output this is what remains: format_version,bonnie_version,name,concurrency,seed,file_size,io_chunk_size,putc,putc_cpu,put_block,put_block_cpu,rewrite,rewrite_cpu,getc,getc_cpu,get_block,get_block_cpu,seeks,seeks_cpu,num_files,max_size,min_size,num_dirs,file_chunk_size,seq_create,seq_create_cpu,seq_stat,seq_stat_cpu,seq_del,seq_del_cpu,ran_create,ran_create_cpu,ran_stat,ran_stat_cpu,ran_del,ran_del_cpu,putc_latency,put_block_latency,rewrite_latency,getc_latency,get_block_latency,seeks_latency,seq_create_latency,seq_stat_latency,seq_del_latency,ran_create_latency,ran_stat_latency,ran_del_latency 1.98,1.98,15.local,1,1602631781,8G,,8192,5,901,93,45205,13,23092,10,1162,90,66262,8,369.7,16,1,,,,100,18,1,360,4,21,0,18,1,542,4,20,0,12295us,665ms,1903ms,48384us,1944ms,5397ms,1652ms,13917us,2866ms,507ms,4953us,803ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,891,93,46620,14,23701,10,1177,90,66461,8,674.0,15,1,,,,100,18,1,406,4,22,0,18,1,559,4,23,0,12010us,1415ms,1264ms,52618us,496ms,69643us,1267ms,10064us,515ms,958ms,4650us,829ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,909,93,47824,14,21431,9,1147,88,67050,8,754.3,17,1,,,,100,20,1,400,4,19,0,14,1,530,3,20,0,11888us,1177ms,2710ms,45197us,1021ms,127ms,398ms,4562us,2874ms,1317ms,4810us,1006ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,890,91,37540,12,21765,9,1183,90,66822,8,1419,22,1,,,,100,19,1,461,3,23,0,19,1,547,3,19,0,11992us,548ms,864ms,46664us,480ms,25566us,760ms,44844us,1036ms,704ms,4778us,6449ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,795,83,43425,13,23066,10,1218,93,938042,27,1282,17,1,,,,100,19,1,406,4,21,0,18,1,560,4,23,0,53141us,14308ms,2786ms,39855us,71572us,6216ms,1761ms,6592us,1224ms,511ms,4654us,504ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,870,91,37339,11,21559,9,1187,91,924835,26,1499,19,1,,,,100,20,1,401,5,25,1,19,1,545,4,20,0,11615us,907ms,1870ms,44530us,352ms,1694us,626ms,4660us,359ms,659ms,5166us,972ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,881,93,37399,11,22194,9,1199,92,66756,8,1341,21,1,,,,100,17,1,409,4,20,0,17,1,557,4,23,0,11831us,1334ms,1113ms,45929us,579ms,29992us,4185ms,4348us,985ms,521ms,4889us,442ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,879,92,37592,12,21603,9,1208,93,4320730,99,1485,18,1,,,,100,17,1,403,4,22,0,16,1,570,3,19,0,11683us,665ms,1118ms,23421us,158us,5495ms,1623ms,4401us,592ms,863ms,10107us,1072ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,879,92,37386,11,21728,9,1168,90,554500,18,1516,19,1,,,,100,19,1,410,4,25,1,18,1,553,3,27,1,11325us,1617ms,1546ms,42335us,476ms,1812us,681ms,4294us,357ms,870ms,4776us,261ms 1.98,1.98,15.local,1,1602631781,8G,,8192,5,850,92,37915,11,21600,9,1159,88,141678,10,1513,20,1,,,,100,20,1,403,5,22,0,16,1,604,3,22,0,12674us,1461ms,1496ms,62742us,382ms,123ms,786ms,5874us,690ms,956ms,5011us,795ms but pasting this into a spread sheet results in missing columns (there are two header columns fewer than there are data […]

Categories
Mastering Development

How do I check if pairs of ints exist in array X, then remove the specific values that form the pairs from array Y?

How do I check if j, k[0][0] or j, k[1][0] pairs exist in array roads, then filter out specific values that form the pairs from k? The pairs can be flipped as k[0][0], j or k[1][0], j. For example, do [1, 0] and [1, 3] exist in roads? Or [0, 1] and [3, 1]. const […]

Categories
Mastering Development

Fastest Algorithm to Find the Minimum Sum of Absolute Differences through List Rotation

By rotating 2 lists either from left to right, Find the smallest possible sum of the absolute value of the differences between each corresponding item in the two lists given they’re the same length. Rotation Sample: List [0, 1, 2, 3, 4, 5] rotated to the left = [1, 2, 3, 4, 5, 0] List […]

Categories
Database Development

How to assign day of the week to different tills

Just wondering if someone would be able to please help me with a problem that I am trying to solve using T-SQL. I have a table for till numbers assigned to 2 members of staff as seen below: CREATE TABLE [dbo].[TillNumbersAssignedtoStaff]( [AssignedWeek] [date] NULL, [StaffID] [int] NULL, [TillNumbers] [varchar](3) NOT NULL, ) ON [PRIMARY] GO […]

Categories
Cryptocurrency Ethereum Mastering Development

Test execution error: ‘The contract code couldn’t be stored, please check your gas limit.’

When I was coding the unitary tests for my smart contract on Remix, I encountered a problem of gas limit: contract deployment failed after trying twice: The contract code couldn’t be stored, please check your gas limit. So I greatly increased the gas limit of the contract, however the problem was not resolved. The problem […]

Categories
User Help

Start an Excel Axis at uneven value (e.g. 3) compared to labels (e.g. 5/10/15)

When I use an interval on an Excel x-axis for the labels of 5, Excel will use 0, 5, 10 for the labels. When the start value is 3, Excel will use 3, 8, 13 for the labels. How can I continue to use 5, 10, 15?

Categories
User Help

What is the best date format for a CSV file so that Excel doesn’t mess it up upon loading?

this is an example of CSV file: timestamp,datetime,price,volume,is_buy,cycle,realized_pnl,unrealized_pnl,fees_paid,margin_use,volume_traded,average_price,position_price,order_long_price,order_short_price 1596112043043,2020-07-30 12:27:23.043,319.5,5,false,0,0,0.0,0,0,0,319.5,0,271.58,-367.42 1596112045045,2020-07-30 12:27:25.045,319.5,0.269,false,0,0,0.0,0,0,0,319.5,0,271.58,-367.42 1596112045045,2020-07-30 12:27:25.045,319.49,3.645,false,0,0,0.00,0,0,0,319.50,0,271.58,-367.42 the timestamp is a Unix timestamp and is what is really used by the code. The datetime column is a ‘human readable’ date string. But when Excel loads that CSV, it looks like that: I tried to use ‘/’ and ‘-‘ […]

Categories
User Help

Start an Excel Axis at uneven value (e.g. 3) compared to labels (e.g. 5/10/15)

When I use an interval on an Excel x-axis for the labels of 5, Excel will use 0, 5, 10 for the labels. When the start value is 3, Excel will use 3, 8, 13 for the labels. How can I continue to use 5, 10, 15?