Trying to add a Row to a nested table

I have been playing with data storage and was playing with a crypto API to try and figure out a good data storage method. I have a table that has tables within it it for each individual line item and am having trouble figureing out how to append a new row to each of the individual tables inside the overall table.
basically, what I want is to add a new row to each table such that the next iteration of the table each of those tables would be 2X26 tables instead of the 1X26 tables shown below.
To test this out im just trying to append each table with a duplicate of the row that exists in the file.
Ive attached the test matrix. Any help would be appreciated.

6 commentaires

"Trying to add a Row to a table within a cell"
What cell array? Your data consists of tables nested inside a table:
S = load('CryptoData.mat');
C = S.Out
C = 100×1 table
T __________ bitcoin 1×26 table ethereum 1×26 table tether 1×26 table binancecoin 1×26 table usd-coin 1×26 table ripple 1×26 table binance-usd 1×26 table cardano 1×26 table solana 1×26 table dogecoin 1×26 table polkadot 1×26 table matic-network 1×26 table shiba-inu 1×26 table staked-ether 1×26 table dai 1×26 table tron 1×26 table
I doubt that your approach is a good use of tables. Most likely you should use one table and add a column/variable that specifies the crypto name, then use the various inbuilt tools for grouping and processing data:
Xymbu
Xymbu le 22 Oct 2022
This doesnt seem like it would solve the problem. This is essentially a 3d table one for the crypto name, another dimension for the variable entry, and the last one for the timestamp.
Stephen23
Stephen23 le 22 Oct 2022
"This doesnt seem like it would solve the problem."
So far you have not stated what the problem is.
"This is essentially a 3d table one for the crypto name, another dimension for the variable entry, and the last one for the timestamp."
Which can be trivially represented in one table: each "dimension" is represented by one column/variable, the rest of the columns are whatever data you have. Do not make your data design more complex than it needs to be.
Xymbu
Xymbu le 22 Oct 2022
It's a 100x26xn table. it can't be done just by placing it into a single table and using the method you provided.
dpb
dpb le 22 Oct 2022
Not convinced. But it's too big to mess with as is...cut it down to a manageable size for development purposes and then show specifically what you're after that you think can't be done by flattening the table.
Xymbu
Xymbu le 23 Oct 2022
This is pretty much as simple as it gets. There are 100 currencies each with 26 metrics at discrete time steps. every iteration will add another set of the 26 metric values to each curreny. it can be tested on a single currency but that doesnt make the mechanics any simpiler.
I ended up doing it as nested structures instead of tables and connecting it to a cloud database. It works fine for anyone else seeing this that may have simliar questions.

Connectez-vous pour commenter.

Réponses (0)

Catégories

Produits

Version

R2021b

Question posée :

le 22 Oct 2022

Commenté :

le 23 Oct 2022

Community Treasure Hunt

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

Start Hunting!

Translated by