Skip to main content
Data Science

Questions tagged [excel]

Ask Question

Excel is a spreadsheet based software, for numerical input, developed by Microsoft and part of the broader set of the Microsoft Office Suite.

78 questions
Newest Active Bountied Unanswered
3 votes
1 answer
69 views

I'm trying to use Excel to determine the outcomes of hockey games. In the game that I'm simulating, I have each team has a goals for and standard deviation which I call in this function: (NORM.INV(...
user183910's user avatar
  • 31
5 votes
1 answer
63 views

I'm trying to learn machine learning. I understood how to train a machine learning model when there are only two labels. But I can't understand how if there are more than two labels, like how to make ...
Martin Dendi's user avatar
  • 51
1 vote
1 answer
123 views

So, I downloaded this Ecommerce dataset from kaggle here: https://www.kaggle.com/datasets/kolawale/focusing-on-mobile-app-or-website After converting it to a csv file, there seems to be an issue. The ...
Majoka's user avatar
  • 11
0 votes
0 answers
36 views

I am not sure whether this is the right place, but I have my first project and don't know where to begin. I want to get into data science/ practical programming and a family friend gave me my first ...
Orange Pukeko's user avatar
  • 1
0 votes
0 answers
3k views

I have a bunch of excel files containing information of employee attendance. I want to use NLP-based search to ask questions like: Which employee has taken most leaves?; What dates witness a high ...
Apoorva's user avatar
  • 347
1 vote
1 answer
381 views

I'm quite new to this data-collecting bit of coding, just trying to make a process a bit more automated. Currently, I have this excel sheet that python can read just fine, however, I am trying to find ...
Fen's user avatar
  • 11
1 vote
1 answer
166 views

I have this data below. I want to convert temperature column into range of data like class interval and get the sum of sales in that range. How can I achieve that?
Mr Ak's user avatar
  • 13
1 vote
1 answer
1k views

I have a large data set similar to that in the screenshot below: and I want to visualise the whole data set like the diagram below (made with a lot of effort in PowerPoint!) Is there any way to do ...
Barry O'Keeffe's user avatar
  • 11
3 votes
3 answers
1k views

The problem I want to solve is my residential building's garage choices. There will be a random distribution of parking spaces. I thought that it would be better if each person writes down which ...
Heleno Paiva's user avatar
  • 131
4 votes
1 answer
348 views

I have some percentage values in my excel spreadsheet like: When i use the STDEV function to calculate the standard deviation with these values, i get ...
heresthebuzz's user avatar
  • 395
1 vote
1 answer
1k views

I would like to find some good courses but also a quick response on how to model transition matrix given the states. Imagine having 4 states and the following array [1,2,4,1,3,4,2 etc etc]. What ...
minattosama's user avatar
  • 244
0 votes
2 answers
1k views

I need to find all duplicate rows (string values) in "Name" column and then find out if two numerical values in "Amount" column sum up to a third value also in the "Amount&...
itsmenick212's user avatar
  • 3
0 votes
1 answer
6k views

I am trying to delete a column from my csv file (column 'A' called "Film Number") but have tried numerous variations of code and while it deletes the column in the dataFrame it doesn't do so ...
Nat's user avatar
  • 11
1 vote
1 answer
193 views

I am pretty new to Python and Pandas and I struggle with combining a messy dataframe from excel with a mapping. I have tried to find some solutions on the Internet, however with no success. My first ...
sianko's user avatar
  • 11
0 votes
1 answer
91 views

Consider an Excel sheet containing a matrix of correlations between individual stocks and the combined portfolio as a whole: How can I extract an optimized matrix such that most stocks have a low ...
Zesty's user avatar
  • 103

15 30 50 per page
1
2 3 4 5 6