Categories
Linux Mastering Development

need to validate 2 files and write 3rd file

File1 — Only Column1 Data Other columns are only Header,. Column1, column55, column56, column57, column58, column59, column60,column61, column62 123 124 221 225 333 432 File2: Column1,Column2,Column3,Column4,…………column55, column59, column58, column54, column62, column61 xxx,123,yyy,zzz…….bbb,ccc,ddd,eee,fff,ggg,hhh,c:\a\b\c\ddd,ggg,hhh,c:\a\b\c\dsada,c:\a\b\c\kkja,c:\a\b\c\dsada,c:\a\b\c\kada xxx,124,xxx,yyy………111,222,333,444,555,vvv,ddd,c:\a\b\c\uuu,ggg,hhh,c:\a\b\c\adada,c:\a\b\c\daa,c:\a\b\c\dsada,c:\a\b\c\kkjj xxx,221,xxx,yyy………zzz,ddd,333,fff,ccc,ddd,333,c:\a\b\c\vvv,ggg,hhh,c:\a\b\c\dads,c:\a\b\c\adaa,c:\a\b\c\dsada,c:\a\b\c\kkjakjjsa xxx,333,xxx,yyy………kkk,444,www,333,fff,223,323,c:\a\b\c\xxx,ggg,hhh,c:\a\b\c\dddjj,c:\a\b\c\adaad,c:\a\b\c\dsada,c:\a\b\c\kki2 xxx,787,xxx,yyy………zzz,ddd,333,fff,ccc,ddd,213,c:\a\b\c\yyy,ggg,hhh,c:\a\b\c\dddkf,c:\a\b\c\fasd,c:\a\b\c\dsada,c:\a\b\c\kku3 xxx,827,xxx,yyy………kkk,444,www,333,fff,sda,sda,c:\a\b\c\zzz,ggg,hhh,c:\a\b\c\ddyu,c:\a\b\c\fsssfs,c:\a\b\c\dsada,c:\a\b\c\k233 IF file1’s column1 = file2’s column2 then. — comparing header and data And (file1.column55 = file2.column55. — Comparing […]

Categories
CMS Development Magento

“Could not receive Stock Item data” Line Appear Instead of Admin Product Grid – Magento 2

“Could not receive Stock Item data” line appear instead of product grid in admin side. I have recently imported other db to my Cloud local setup. When I am doing indexing,I am getting error like this. SQLSTATE[HY000]: General error: 1449 The user specified as a definer (”@’%’) do es not exist, query was: DELETE price_index […]

Categories
Development Game Creation

What is the use case of long range? [closed]

What is the use of setting value to long -9 quintillion (-9,223,372,036,854,775,808) to 9 quintilion (9,223,372,036,854,775,807) and with unsigned ulong 0 to 18 quintillion (18,446,744,073,709,551,615) What is the use case of these ranges in gamedev? I see one application: when the value exceeds the int range so use long so when it exceeds 2 billion […]

Categories
Development

finding the closest value in a list

I’m trying to take a value from a list and find the closest value from another list, and sort it so it’s the same.. I’m not good at explaining.. here’s my code: list1 = [[111, 111], [222, 222], [333, 333]] list2 = [[223, 223], [112, 112], [334, 334]] #I need to find the closest value, […]

Categories
Development

Two-Way Repeated Measures ANOVA: Error in lm.fit()… 0 non-na cases (rstatix)

I am trying to run a Two-Way Repeated Measures ANOVA using the R Statix package based on the description from here however I am running into the subject error with my dataset. The data consist of 10 replicate biomass measurements recorded at each of 8 Locations across 5 months (10 reps x 8 locations x […]

Categories
CMS Development Magento

Magento 1.9 – After Export Products, Category few columns values like 000,000,000

After export products, category few columns like 12,223,234,544,348,000,000,000 what is mean 000. How to view what category it is? FYI – few products assigned to more than one category like 6 or 7 categories. Screenshot : https://imgur.com/xKK9Tzi File : https://we.tl/t-F2HsGD2bma

Categories
Development

At a certain point, does adding a large integer to a long integer well below its limit in Java cause problems?

For example, adding 4.0E16 or *4*Math.pow(10, 16)* to: 5,390,195,186,705,543 The result should be: 45,390,195,186,705,543 but the following code returns 45,390,195,186,705,544 adding 1 to the least significant digit (which shouldn’t be happening). From what I’ve researched online the upper limit of long is: 9,223,372,036,854,775,807 but the example I’ve given has not exceeded that limit yet. Relevant […]

Categories
Development

How to conditionally set values at a particular position along a particular axis of a numpy ndarray

I’m looking for an efficient, pythonic way to set the nth value along a single axis in an ndarray according to a conditional test. Here’s an example. Initial ndarray: array([[[111, 112, 113, 114], [121, 122, 123, 124]], [[211, 212, 213, 214], [221, 222, 223, 224]], [[311, 312, 313, 314], [321, 322, 323, 324]]]) I would […]

Categories
Development

Finding percentile_cont

Hope I can express this clearly. I am using the pgAdmin 4 tool in PostgreSQL 12. I am going through end of chapter (6) exercises in the book “Practical SQL” by Anthony DeBarros and am having problem getting my query to run. There are two tables with (total) population per county per state and I […]

Categories
Development

How to minimize the sum of the elements in the final array after performing k number of operation

This question is asked in my interview coding and there were 12 test cases and i am only able to pass 8 of them. minSum(List values, int k) method need to complete. Example : nums = [10,20,7] and k=4 ans answer for this array is 5+5+4=14. Each operation consists of removing element from the array, […]