2,110 questions
Advice
0
votes
1
replies
54
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
0
answers
28
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
2
answers
65
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
...
0
votes
0
answers
62
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 ...
0
votes
1
answer
118
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,...
0
votes
1
answer
567
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
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 ...
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 ...
0
votes
1
answer
226
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
vote
1
answer
48
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 ...
0
votes
1
answer
85
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
0
votes
1
answer
108
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/...
0
votes
1
answer
49
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
2
answers
227
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 ...
5
votes
1
answer
888
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 ...
-3
votes
1
answer
57
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
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 ...
0
votes
0
answers
21
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 ...
0
votes
0
answers
58
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 ...
0
votes
0
answers
129
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
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 ...
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 ...
0
votes
1
answer
63
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 ...
0
votes
0
answers
25
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 ...
2
votes
1
answer
134
views
algorithms to detect and break down arithmetic or geometric sequence
If a sequence is pure arithmetic (1,3,5,7,9...) or pure geometric (3,9,27,81...), its easy to detect.
How about a "mixed" arithmetic/geometric sequence ?
e.g. 2 3 5 6 7 9 10 14
it contain 3 ...