All Questions
Tagged with missing-data excel
34 questions
3
votes
1
answer
1k
views
Missing Method when importing
Imports ClosedXML.Excel
Sub import()
'Open the Excel file using ClosedXML.
Using workBook As New XLWorkbook(file_pr)
'Read the first Sheet from Excel file.
Dim workSheet As ...
- 35
0
votes
1
answer
30
views
Fill in the missing values if rows in other columns are the same
I have a table which looks the following way:
Name
Region
Id
Name1
US
123
Name1
US
Name2
US
122
Name3
US
124
Name1
UK
Name1
UK
135
Name2
UK
140
Name3
US
As you can see there are empty values in the ID ...
- 107
1
vote
2
answers
1k
views
pandas.read_excel() na_values not working correctly
As title states, after reviewing docs
I am reading an .xlsx file, with a column 'HOUR' which has many values, when an instance has value 99, i want to convert to None
I have tried the na_values param ...
0
votes
1
answer
146
views
replacing missing values in r
I need help in replacing missing values in the following dummy file. The following rule need to be followed when replacing a missing value.
If the value is the same on both sides of the column where ...
- 107
1
vote
2
answers
580
views
Losing the last 4 numbers when saving dataframe to csv in python
I am trying to save twitter data is being organized in an excel file (CSV file). To do this, I've written the following code:
df.to_csv(r'C:\Users\path\tweets.csv')
This code works fine and through ...
- 47
0
votes
1
answer
2k
views
Data missing when importing a text file into excel
i'm trying to import a text file of csv data into excel. The data contains mostly integers but there's one column with strings. I'm using the Data tab of excel professional plus 2019. However, when I ...
- 19
0
votes
1
answer
355
views
how to fill missing values with a specific set on string values
This is my DB,
its got too many missing cases for me to do it manually, and I can not use flash fill in this case,
so I want to randomlly fill these case with a specific set of strings :"TCS&...
- 164
0
votes
0
answers
26
views
Filling in missing inbetween values with known two values in excel or python
I used known x and y values to do scatter plots but how can I find a y value based on x values. For instance, the data below is a small part of the scatter plot but how do I find the all depth values ...
1
vote
1
answer
94
views
How can you compare two excel workbooks in python?
I have an excel workbook - sheet1 with values:
Names
--------
Aaron |
Bob |
Carl |
Daron |
Elle |
I have another excel workbook - sheet2 with values:
Names Marks
-------------------
...
- 33
0
votes
2
answers
943
views
Excel- Filling missing values based on other values on same row
I need to deal with missing data present in almost every row. Sample of data is as follows:
Col1 Col2 Col3 Col4 Col5
10 12 - 14 12
- 8 10 14 -
14 ...
- 21
0
votes
1
answer
2k
views
VBA: remove rows from array that have more than X empty values
I have a dynamic array(n,m) that gets values assigned from a range.
As the range contains entries that do not have all necessary values (if complete entry then 5 or 6 values per row). Now I want to ...
- 755
0
votes
1
answer
1k
views
OData Feed / Power Query in Excel 2016 Not Retrieving All / Duplicating Some Records
In Excel, I successfully connected to an OData feed from Data.Medicare.gov (the website is https://data.medicare.gov/Hospital-Compare/Healthcare-Associated-Infections-Hospital/77hc-ibv8/data and the ...
- 135
0
votes
2
answers
48
views
Code executing on only a few entries and missing entries that pass the rule?
Good Morning,
I have a database of safety data sheets for the benefit of COSHH, i am trying to create a function in which the user can enter a date into "H7" and any entried with dates less than ...
1
vote
2
answers
329
views
Import from Excel with panda but missing the index header
I would like to use this data from xlsx :
Fe Mg Al Si P S K Ca Ti
5 0.80 2.09 3.49 7.05 0.19 0.07 0.13 84.28 1.90
5 0.75 ...
2
votes
3
answers
21k
views
Ignore zeros (or blanks) in Excel LINEST function with multiple independent variables
I would like to run a multiple (!) factor analysis through linest, again excluding all rows that contain zeros (or if that’s easier blank cells). Is there a way I can do this using the linest ...
- 21