MATLAB Answers

How to specify a default fill value for adding to table

80 views (last 30 days)
Greg
Greg on 31 Oct 2016
Commented: Greg on 20 Feb 2017
I have a table and want to add data to it iteratively. My data is sparse. Most of it is doubles. When I add a column with not all rows specified, the unspecified rows are filled in with 0, which is an unfortunately valid number. It would be better if they had NaN by default. How can I change this default table fill parameter? I currently loop through the newly added columns and look for blocks of zeros immediately after adding, but this is failing in the more complex data manipulations I'm doing.

  0 Comments

Sign in to comment.

Answers (2)

Peter Perkins
Peter Perkins on 2 Nov 2016
Greg, it's really the double type that's doing the in-filling with zeros, not the table. In general, things in a table behave the same way they would if they were directly in the workspace.
I imagine you're doing an assignment something like
t.NewVar(someRows) = values
You might be better off "preallocating" with NaN before your assignment, with something like
t.NewVar = NaN(height(t),1)
t.(someRows) = values
Hope this helps.

  0 Comments

Sign in to comment.


Kevin Gleason
Kevin Gleason on 2 Nov 2016
Perhaps you are mixing data types in these arrays?
Default values should be as follows: 0 for durations, NaN for numbers, NaT for dates, undefined for categorical arrays etc. I am not aware of any way to customize these defaults.
Regardless, there are many functions that can help you clean up or fix missing data. Refer to the following documentation page to see some of them in action:

  1 Comment

Greg
Greg on 20 Feb 2017
I am mixing data types, which is why I am using a table, and why this is complicated.
All of the functions I've found to handle missing data require that I be able to identify it. But some of my data is validly 0, and some of it is missing-data 0, so there's no way to use these functions.

Sign in to comment.

Products

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by