excelislife

1

votes
0

answer
178

views

Add Comments to Excel pivot slicer options

I have been trying out searching multiple forums before posting this question here. Issue: In one Excel pivot table slicer I have almost 50 options. I have given codes to each slicer option rather than writing entire description about the slicer option. I am looking for some VBA help where in I can...
excelislife
1

votes
1

answer
47

views

Rearranging headers in linregress python

I am using Linregress in Python to get slope, intercept, etc The output is a csv file. However, the data output does not have headers in columns. The data output is as: slope=5.562, intercept=223.5 etc An image is attached herewith with what I see in Jupyter notebook(left image) vs what I need to ha...
excelislife
1

votes
1

answer
158

views

Use 'groupby' on statistically processed R2 values- python

For my research I have a specific calculation for R2 values. It is not an R2 value directly calculated using Linregress function. The code I am using is for statistically processed R2 value (labelled as 'best R2). I get the R2 value for entire x and y axis. However, there are multiple 'Test Events'...
excelislife
1

votes
2

answer
84

views

Groupby function on dataset python

I have following dataset from which I am using for my research. Final output is slope. import numpy as np import pandas as pd from scipy import stats df=pd.read_excel('I:/Python/Data/Copy.xlsx') df_np=np.array(df) x=np.array(df_np[:,14],dtype=float) y=np.array(df_np[:,12],dtype=float) for i, pair in...
excelislife