Questions tagged [excel]
The excel tag has no usage guidance.
1
vote
1answer
35 views
Calculate weighted mean for two columns and hundreds of rows?
I'm trying to teach myself basics of R and I couldn't find the answer:
Say, I have a csv file and I want to calculate weighted mean for each subject such that I have a mean mu = 0.015*1030+0.16*26930+...
1
vote
1answer
30 views
Problem when exporting scored labels to excel
I have done a regression using Azure ML Studio and it ok. The r squared is 95% on the test sample.
When predicting, the results look ok when visualizing the data.
The results appear as expected, with ...
-1
votes
1answer
35 views
How to add values to new row to a csv in python
So what I'm trying to do is iterate over a (grayscale?) image and look at each pixel and write that pixel's grayscale value to the second row(the first row is the pixel number). Code isn't doing ...
7
votes
1answer
132 views
How far can one go with excel? [closed]
in my business we handle all analytics through Excel. This includes mostly scheduling, production planning and accounting operations. We currently are looking into adding a bit of predictive modelling ...
1
vote
1answer
38 views
How can discard “peaks” values from a chart?
I have this chart
where you can see that some points are far away from the "trend" of the curve. The chart represents $5,000$ values where each value corresponds to a specific hour of a day, month ...
0
votes
2answers
5k views
Search and Replace in specific column of csv with python
I created a program that search and replaces over an entire csv file but I need to make so it is column specific. Is there a way to only search via a column. Here is my code, I am pretty new to python ...
2
votes
0answers
28 views
Orange “Scatter plot” widget to excel, best way
So I have chosen "Orange" for my research as a main app for clustering ant it's analysis.
Excel 2016 is primary app used for dashboard (via "pivot table").
Problem - how to add graphs from "scatter ...
0
votes
0answers
31 views
User friendly ETL tool for wrangling Excel docs?
Have been working on wrangling data for predictive analytics project I’m working on. I am consistently pulling reports in Excel format from CapIQ (www.capitaliq.com) that will have 10,000 rows and 45 ...
0
votes
1answer
81 views
How can I transpose a high dimensional dataset?
I have a (.csv) file with more than 35,000 rows and 100 columns, where the rows represent the attributes and columns represent the instances. In Excel the maximum number of columns is 16,384. ...
1
vote
1answer
40 views
How to manipulate this column of less than/greater than?
I have a dataset in which one column is as given in the picture.
What will be the best way to handle such a column?
0
votes
1answer
667 views
Compound Annual Growth Rate Function in R Statistics
I need to calculate the compound annual growth rate for two periods of time: 2014 & 2009. I'm currently working with Excel, I have two columns with data for each year (One column with only data of ...
1
vote
2answers
44 views
Find value and return row in excel spreadsheet with over 1 mil rows [closed]
I have an excel spreadsheet that has over 1 million rows and about 120 columns. I frequently need to find a value or a part of a value (value is name or number) and return the row where the value is ...
0
votes
1answer
186 views
No result for scored labels in Azure ML Web Service
I am trying to predict scored labels using regression. But when I am about to get the result from Azure ML Web Service in Excel 2016, there is no result appeared in the scored label column. How should ...
1
vote
2answers
69 views
Discovering cross category sales using transactions history (Clustering?)
I have a set of sales transaction data containing more than 1 item purchased. Every item sold has a category. I would like figure out which categories are most commonly ordered together.
The data is ...
2
votes
1answer
32 views
MS Access issue [closed]
I have a database that I send to an excel sheet that auto populates some field in a report with calculations that I need. There are several users and the excel sheet cannot be open at multiple times ...
1
vote
1answer
68 views
Excel file merge with different headers but same data
I need to merge data from 1000s of excel files provided by different operations managers on productivity and other reports. The excel files have similarity of data but the headers are all custom since ...
4
votes
1answer
197 views
logistic regression coefs to excel formulation
I have done a Logistic regression in r with 3 variables involving 1 interation:
lm(predicthead~vol+weekday*head, mydata)
weekday is a factor - 7 days of the week....
12
votes
6answers
1k views
Is Excel sufficient for data science?
I'm in the process of preparing to teach
an introductory course on data science using the R programming language.
My audience is undergraduate students majoring in business subjects.
A typical ...
-1
votes
1answer
46 views
Excel formula question
I have a rather complex formula that I need to build. Basically I get a list of data every month, and there is a metric for the first operator of the day. The first column comes in the date and time ...
5
votes
1answer
97 views
How to generate bulk graphics using R
I have a dataset of Key Performance Indicator (KPI) and for each KPI I have a current level of achivement and 2 targets : Target1 and Target2.
How can I automatically generate one graphic for each ...
1
vote
2answers
685 views
What are recommended ways\tools for processing large data from Excel Files?
A Very Happy New Year! I'm currently working on an analytics project with large volumes of data stored in excel files (about 50GB in 1000 files). The files use a custom formatting to store date-time ...
1
vote
1answer
81 views
Best practice for computing week-over-week change in MAU metric
When we calculate week over week change for a metric like "Monthly active users", we often refer to a calculation of SUM(This week) - SUM(Last week)/SUM(Last week), which means we will run total of ...
1
vote
0answers
53 views
Creating Clusters in Excel office
I am trying to make group categories based on the similarity in attributes. For example;
Car1: blue, big tires, slow, comfortable
Car2: green, small tires, fast, comfortable
Car3: blue, big tires, ...
2
votes
1answer
93 views
Working with text files in Excel
I have an excel file containing a long text in column A. I am looking for the words starting by "popul" such as popular and populate . I can find these cells by the formula:
...
34
votes
11answers
19k views
Do data scientists use Excel?
I would consider myself a journeyman data scientist. Like most (I think), I made my first charts and did my first aggregations in high school and college, using Excel. As I went through college, ...
