The code I used to try and update the table view:
import pandas as pd
bar = syn.tableQuery("select foo from syn8001121")
df = bar.asDataFrame()
In [10]: df
Out[10]:
foo
7118159_1 NaN
7118160_1 NaN
7118161_1 NaN
7118162_1 NaN
7774921_1 NaN
7992366_3 bar
In [11]: df.ix[0,0] = 'whatever'
In [17]: syn.store(synapseclient.Table(bar.tableId, df))
Uploading [####################]100.00% 100.0bytes/100.0bytes (82.7bytes/s) table.csv Done...
But then it throws the error:
SynapseHTTPError: 400 Client Error: Bad Request
Expected response to be of type org.sagebionetworks.repo.model.table.UploadToTableResult
This error happens outside of the Python client as well.
What do you mean by that?
Proof of concept:
https://gist.github.com/kdaily/0db938589a08f0c7d8317d0cf2924167
Tested it on the dev branch and it works!