Categories
Mastering Development

Matplotlib | Change in plot representation when applying logarithmic scale

Given a set of points to be represented on a 3D plot (as scatter plot) I thought it would be interesting to plot the same data in 2D instead of 3D thanks to hist2d and using weights. This data has low and high values (some orders of magnitud apart) so when represented as a hist2d […]

Categories
Mastering Development

duplicate checking with form text box in excel vba

I am storing data from EXCEL user form to excel sheet. i have problem with duplicate checking. my data in A column like these… 300, 304, 305, 306, 307, 308, 309, 310 so on… for example user entered 306 on respective textbox then message box will display that “duplicate data entered”. i wrote following code […]

Categories
Mastering Development User Help

In ffmpeg, why does rotate of 90 cause rotate of 270 to be listed?

I have a file ggg.mp4 with no rotational metadata. C:\vidz>dir ggg.mp4 12/03/2020 17:50 9,304,867 ggg.mp4 C:\vidz>mediainfo ggg.mp4 | find “Rot” C:\vidz>ffmpeg -i ggg.mp4 2>&1 | find “rotate” I then try to create a file from that, with rotational metadata of 90 degrees C:\vidz>ffmpeg -i ggg.mp4 -c copy -metadata:s:v:0 rotate=90 ggg2.mp4 C:\vidz>ffmpeg -i ggg2.mp4 2>&1 | […]

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
Development

How to cycle through permutations of a list of 88 elements?

I’m trying to assign a single variable each permutation of a list of 88 elements one after another. This means the variable would be re-assigned a new permutation 88! times. I have tried making 88 nested for-loops but apparently there is a limit to how many for-loops you can nest. I am using Python. elements […]

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, […]

Categories
Development

I want to retrieve which scheduler is scheduled for a particular day

+—–+————————————————–+——–+——————–+—————+—————+—————+————————————–+————————-+——————-+——————————————————————————————————–+————————–+——–+—————-+————————————–+———+ | ID | Name | Action | Created By Use Rid | Created Date | Days | Enterprise ID | Job ID | Last Updated By Use Rid | Last Updated Date | Relays | Sch Time | Status | Timezone | Trigger ID | User ID | +—–+————————————————–+——–+——————–+—————+—————+—————+————————————–+————————-+——————-+——————————————————————————————————–+————————–+——–+—————-+————————————–+———+ | 30 | ios | […]

Categories
Development

how to solve this problem in R: In while (t 1 and only the first element will be used

big thank you and warm regards for the answer Mr. Tom, for the detail problem may you can help me the following step : I have a problem with R Program, first, I make a trendlinier (At+B) from this data set timedelay<-c(76.77,65.88,60.96,51.61,48.72,39.86,35.43,33.36,30.32,23.96,16.95,3.564) timedelayts<-ts(timedelay,start=c(2011,1),freq=12) plot(timedelayts,ylab=”Time Delay”,col=”blue”) time=ts(1:length(timedelayts),start=c(2011,1),freq=12) trendlinier<-lm(timedelayts~time) trendlinier Call: Coefficients: (Intercept) time 78.38 -5.81 Avalue<-(-5.81) […]

Categories
Development Python

Parsing a .pdb file in Python and creating a dictionary for specific record types

First, let me start by saying that I’m doing this as a Python exercise and I’m not allowed to use Biopython. I am writing a script that will help me parse any .pdb file generated from a trajectory. I am trying to create a dictionary that would link the chain variable with the resNumber variable. […]