2,112 questions
1
vote
1
answer
53
views
Grouping landmak vectors by similarity (Python or R) - which is the simplest solution?
Pardon my verbosity but I think that I've much to explain. My English leaves something to desire. I'm 66 years old, from Italy, with some experience in programming, but I never ventured in the realm ...
-1
votes
1
answer
80
views
Spectral Leakage in Resampled FFT (and how to fix it)
I have a 10 second signal of a pure 50 Hz sine wave sampled at 40.96 kSa/s (409,600 samples). I apply a Hanning window and the magnitude plot of my (numpy) FFT shows (ignoring negative image ...
- 1
Advice
0
votes
1
replies
60
views
How can I truncate the 15 lkh data set which is unfiltered to filter then upload on MySQL
I want that the data will arrange in a proper manner firstly the data have clear and remove duplicate and missing values then I write a my code in pandas to upload and process the same thing again ...
0
votes
2
answers
69
views
How can I structure my sapflow data to analyze using "TREX" package in R?
I have continuous sapflow data (averaged for every 10 minutes) in degree celsius recorded by heat-dissipation sensors for 30 trees (30 sapflow average value columns). But for proper analysis and ...
- 3
0
votes
0
answers
29
views
iminuit not converging results
I am using Iminuit to find the sensitivities of parameters. I have signal and background which depends to energy. Before launching IMINUIT, we have to define the energy range and the number binning. ...
1
vote
0
answers
25
views
SSAS Cube measure IIF issue
I am working on creating a new cube measure QTD, in an SSAS cube.
The requirement is to display the Measure YTD directly when the current month is January, February, or March (Q1). The initial code I ...
- 11
1
vote
2
answers
66
views
Is there an efficient way (or a package) to dynamically filter a dataset by time between dates?
Say there is a dataset with duplicated PersonIDs, and multiple dates.
PersonID
Date
1
2024-01-01
1
2024-01-02
1
2024-01-09
1
2024-01-15
2
2024-08-05
2
2024-08-06
3
2024-01-07
3
2024-01-08
3
2024-01-15
...
- 53
1
vote
0
answers
68
views
Using VLD to get the bytecode for php files
I'm currently working on a project that involves analysis of the bytecode for PHP files. I'm still working on the underlying framework and concept and was hoping to find an easy way to export PHP ...
0
votes
0
answers
64
views
Automatically collapsing intermediate variables in a python function
I have many hundreds of python functions I'm evaluating for memory usage, and many of them differ simply by the usage of intermediate variable assignments. I would like a way, if possible, to ...
- 1
-1
votes
1
answer
89
views
What is the worst-case runtime of this algorithm (in big-oh notation)? [closed]
The input is an N by N matrix of numbers. Each individual row is increasing from left to right. Each individual column is increasing from top to bottom. The example of a matrix is given below with N = ...
- 1
0
votes
1
answer
119
views
Windows kernel dump analysis: find all occurrences of any threads call stacks that involve a specific driver module
I'm doing a Windows kernel dump analysis in Windbg and would like to write script that can find all occurrences of any threads call stacks from any processes that involve a specific driver module name,...
- 31
1
vote
1
answer
402
views
When to use PCA(n_components=0.95) and when to use PCA(n_components=2), what is the difference between them?
For the Principal Component Analysis (PCA) model training
when to pass variance as PCA(n_components=0.95) and when to use PCA(n_components=2) with pipeline having Standardscaler for standardizes the ...
- 1,277
0
votes
1
answer
589
views
Automate Analysis for Excel Prompts using VBA
I am trying to update the prompts in Analysis - which I do currently manually every month - for Excel; however, despite I am getting the value from technical name (which I guess is correct though), I ...
0
votes
0
answers
114
views
Power BI: How to create cards with calc'd value using two other separate card visualizations
I am currently stuck with an issue on Power BI.
My desire is for the "Incidents Up/Down" and "Responses Up/Down" cards (bottom left) to be able to dynamically update as I alter the ...
- 9
0
votes
1
answer
132
views
Is there a way to apply R formula to whole excel sheet
I have the following code to apply in R:
qnorm(0.975)*sqrt(p*(1-p)/n)
Typically, I would enter the individual p and n values to get the output. However, I have a lot of data in Excel format, and to ...
- 21
0
votes
1
answer
85
views
How to modify large amounts of data using pandas
As shown in this code, I need to use certain data in one table as a basis to modify another table and add some information. When this kind of table information scale is large, this violent traversal ...
- 25
0
votes
1
answer
1k
views
How to Create a new Calculated Card Visualization that displays a value derived from these two cards in my dashboard in Power BI?
How to Create a Calculated Card Visualization in Power BI?
I have two card visualizations in Power BI, and I want to create a third card visualization that displays a value derived from these two ...
- 133
0
votes
0
answers
95
views
Is there any difference between the terms asymptotic analysis and complexity analysis?
I've read some articles about algorithms analysis and sometimes they seem to use two terms interchangeably and sometimes there seems to be a subtle difference. So I'd like to know about it explicitly, ...
- 63
0
votes
1
answer
230
views
SPSS analysis for mixed design moderation model
I have the following conceptual model:
IV: Personality trait (measured on likert scale)
Moderator: low trust vs high trust
DV: initial price offer in a negotiation ( values can be between 5-15)
I have ...
- 1
2
votes
0
answers
1k
views
Is there a way to quickly find all the REST API backend endpoints used on the frontend of the same application? [closed]
In order to secure access to some endpoints (on Java back-end) I need to find all the endpoints used by a particular module of the UI (Angular JS frontend to be more specific), is there some tool to ...
1
vote
1
answer
55
views
Restructuring data with occurrences of factors into data for network analysis based on co-occurrence
I am trying to restructure my data based on co-occurrence of some factors (the purpose is network analysis with nodes and edges). In my dataset I have the value ‘1’ whenever a patient with an ID has ...
- 107
0
votes
0
answers
52
views
What to do if inverse of Leontief matrix is filled with #DIV/0! error? MRIO analysis
I was doing IO table analysis with EORA26 database. When I try to get an inverse Leontief matrix, excel yields #DIV/0! error in the whole matrix. I think I am doing every step right. I checked the ...
0
votes
1
answer
93
views
DAX query for average time taken per hour
I would like to find the average time taken for each hour, where the status is 200 using a DAX query.
So between 20:00 and 21:00, the average time taken is X seconds
- 31
0
votes
1
answer
153
views
Check if this code uses a data sliding window
I want help to check if the following code (from https://github.com/jsh4887/ConvLSTM/blob/main/1.%20Make_dataset.py):
import os
import numpy as np
import pandas as pd
import pickle
from sklearn....
- 242
0
votes
1
answer
110
views
Having trouble reading a csv file with embedded commas in some values
I am using clean dataset from this kaggle, for a school project and i have to write code in c++ that sorts the data and allows me to run statistical analysis on the data.
https://www.kaggle.com/...
- 15
0
votes
0
answers
126
views
Teradata SQL - How to use the value from previous rows
I am having a rather simple problem, however making it complicated by overthinking. I am hoping someone can help me here.
I am having a data which have a row for each day in a month and data is for n ...
0
votes
1
answer
52
views
Finding the corresponding X-axis value from graph
Please check my code from the internet. I am trying to find the X-axis values at 10, 50 and 90 Y-axis values from the chart. But np.intercep() is not working.
I have tried the Y-Intercept and other ...
0
votes
1
answer
48
views
Dynamically assigning CSVs to objects in a for loop in R
I am trying to analyse monthly statements from last year which are in the form of CSV files. My attempted code is below. I want to import them all in one go, assign each to an object, and then filter ...
- 1
0
votes
2
answers
235
views
Missing values were incorrectly entered as zeroes
How do I change 0 values to null?
Missing values were incorrectly entered as zeroes, and you need to change them to null values before you look for trends. The code you’re using to do this is ...
0
votes
0
answers
75
views
Python - Writing code for probability of choosing 7 pairs in a dominoes game?
So I am trying to write a code to determine the odds of getting 7 dominoes with the same number on both sides (7/7).
The dominoes set has double 9 as the highest number on a side. (0/9, 1/9, 2/9, 3/9, ...
5
votes
1
answer
906
views
Performing Fourier Analysis using Python for image reconstruction
I'm trying to perform a Fourier analysis on some shapes I produced using Python. I managed to obtain a 2D Fourier transform on the images as well as applying a Gaussian filter, however the inverse of ...
- 51
-1
votes
1
answer
253
views
Can Android Studio be setup as an environment for malware analysis?
As the topic suggests, how exactly can we use android emulators like Android studio to create a sandbox-like environment(or can we?) (in this context: detection of malicious files). I've heard of ...
-3
votes
1
answer
64
views
Why does my subquery logic give me a different result?
I got a different answer(4434.21) than the supposed result(4721.14)(ERD and can't figure out what went wrong, question below:
Q: What is the lifetime average amount spent in terms of total_amt_usd, ...
0
votes
1
answer
94
views
Design and Analysis of Algorithms Time Complexity Analysis of Dependent loops
I want to know how we derive O(n3). Of course outerloop is 2 + 3(n+1) + 4n; middle loop is sum of all n starting from i =1 of ( 2 + 3( i + 1) + 4i ), but what is the time complexity of the innermost ...
- 1
0
votes
0
answers
31
views
I have survey data with responses are encoded in numbers and the actual datamap file where the code number & actual value is present in another file
I have survey data with responses are encoded in numbers and the actual datamap file where the code number & actual value is present in another file. I want to analyse this data how to combine ...
2
votes
1
answer
427
views
Fitting a power law
I'm trying to recreate an analysis from the article: "From time series to complex networks: The visibility graph". Here is the link to the article: https://www.pnas.org/doi/10.1073/pnas....
- 47
0
votes
0
answers
26
views
How to identify new users who fulfil the criteria
I have a table with user_id,spend and order_date. I will be sending communications to users with spend greater than 200 based on 31 days from any day. I want to see how many new users will fulfil the ...
- 1
1
vote
1
answer
206
views
Extract duplicate row based on three columns power query
Hi i want extract the duplicated row based on three columns in power bi (power query).
If all column are same with other row then extract.
In this case the column are name, surname and phone1.
I show ...
0
votes
0
answers
63
views
How can I analyze .pcd files with abnormal structures?
First things first, I am new to Python and programming in general so bear with me.
For a college project I have been tasked with carrying out analysis on .pcd files captured during 3D printing using ...
- 1
0
votes
2
answers
480
views
expo: how can I track user interaction inside my application without relaying on third party dashboards
I have applications deployed on Play Store, and I want to track users' interactions with the applications so I can make the application more user-friendly
things I need to keep track of:
screen time: ...
- 977
0
votes
0
answers
137
views
How to run QucsStudio at the command line?
I am trying to run QucsStudio from a command line.
I am using this line
"C:\Programs1\QucsStudio\bin\qucs.exe" -n -i "Klopfenstein_taper_OK.sch" -o "Klopfenstein_taper_OK.net&...
0
votes
1
answer
68
views
Some NAs produced during rda analysis in the contrained variables section
I am running a RDA analysis (vegan package) following the next script:
env: The "env" dataframe has 9 variables: HIX, SR, FI, BIX, perC1, perC2, perC3, perC4, CDOM_S.
This dataframe is ...
- 13
0
votes
0
answers
43
views
How can I do a matching between two datasets with different amount of rows?
I have a dataset (PRUEBAsummary_NO2_2019_ID) with 16 ID categories. I want to match this 16 categories to the corresponding district codes (21). I want the rows corresponding to IDs to repeat when ...
- 3
1
vote
1
answer
77
views
Prices in my Category column - Using RStudio
j_dataset
Hi! Very new to R language. I have a dataset where there are some prices in my category_alias column. The issue cells are where the data is misplaced have null cells for where the data is ...
- 21
0
votes
0
answers
35
views
How to assign variable sample names to an object based on the number of sample replicates in R?
I am trying to automate the analysis of an output from a new piece of equipment. The equipment has 6 wells (A1, A2, A3, B1, B2, B3), and for my purposes lets say each well is a sample. So if I have 2 ...
user11641357
0
votes
0
answers
47
views
Pandas pd.cut with pd.groupby not matching loop aggregation
I am calculating some statistics (mean value from binned data) for a heat map. I am somewhat skeptical of the results using the pandorable method so I tried recalculating using a nested for loop and ...
- 95
0
votes
1
answer
69
views
What is the Name of this Process Analysis Software / What Type of Software is it?
As the title describes, does anyone know any information on this specific piece of software? I would like to find the literal software in the image. But could suffice with type of software for the ...
- 41
0
votes
0
answers
40
views
Consolidating Columns in Dataframe [duplicate]
I have a huge dataset and I want to sum the rows of multiple columns so I can combine them into a single summed column. I am working in R. I have successfully summed the rows up, but am not sure how ...
0
votes
0
answers
29
views
why am receiving the message pandas not defined even if I already import it?
hi am trying to do some data analysis to my excel sheet using anaconda JupyterLab so I imported pandas but when am trying to use it it's keep telling me name 'pod's not defined
I tried to look over ...
- 1
0
votes
0
answers
97
views
How Innodb Concurrency Tickets working in sorting by mysql?
Innodb concurrency tickets how reduced when the sorting performing query running? is tickets applied for sorting or not? If applied how it was calculated by mysql and is there any performance issue ...
- 1