Open fracorallo opened 4 years ago
Hello capellino, I don't have a definitive answer to your trouble, but maybe I have some clue.
Myself, I am not using the append() function because:
To give you an example, in my case, I have for instance:
Well, after all this blabla, the question is: on which equality is based pystore append() function?
You can have a look in the source of collection.py:
combined = dd.concat([current.data, new]).drop_duplicates(keep="last")
If you have a look to 'drop_duplicates' documentation (well, I only checked out that of pandas, not dask, but I understand dask simulates pandas), you will see it identifies duplicates purely on values in columns, not index.
So you can have different index, but same value, it won't bother, it will purely suppress the 'duplicateed rows'.
Back to your ewample, maybe this can be the why. You generate a string dataframe based on 3 letters, abc as far as I understand. I am not that surprised it keeps only 3 rows. With float, I guess no value is ever the same.
To finish. in my own case, I only use the write() function, and operate the appending in few lines: To give you an idea of what is my 'appending' strategy, here it is (for financial data) ` # Only removes duplicates based on key columns for given data type
# Do not keep last row of DataFrame currently in base (empty row)
# Do not keep last row of new DataFrame either (empty row)
combined = pd.concat([current[:-1].reset_index(), df[:-1].reset_index()])
combined.sort_values('Timestamp', inplace = True)
combined.drop_duplicates(subset = AC.DataTypes[cde.data_type], inplace = True)
combined.set_index(keys='Timestamp', inplace = True)
# Re-add as last row the latest timestamp
# We don't know if added data is newest data or earliest data, so let's check
if current.index[-1] > df.index[-1]:
last_row = current.iloc[-1]
else:
last_row = df.iloc[-1]
combined = combined.append(last_row, sort=False)
my_collection.write(item_ID, combined, overwrite=True) `
Hope this can give you some clues. Bests
Thank you very much for your suggestions. I solved not using at all the append() function as you said!
just a naive question: why are you using remove_duplicates ? or maybe better question, should we use remove_duplicates when the index is part of the data (e.g. a datetimeindex for a timeseries) ?
Hi,
there is a problem with the append function:
The line:
combined = dd.concat([current.data, new]).drop_duplicates(keep="last")**
in the file collection.py should be subtituted by:
idx_name = current.data.index.name combined = dd.concat([current.data, new]).reset_index().drop_duplicates(subset=idx_name, keep="first").set_index(idx_name)**
For further explanation, please refer to:
just a naive question: why are you using remove_duplicates ? or maybe better question, should we use remove_duplicates when the index is part of the data (e.g. a datetimeindex for a timeseries) ?
In general, pandas indexes are not unique and you can have repeated values. Therefore you need to remove duplicated indexes if unique ids are needed.
In the SO post you link, they suggest the simpler and more efficient alternative to remove duplicate indices;
df = df[~df.index.duplicated(keep='first')]
In the SO post you link, they suggest the simpler and more efficient alternative to remove duplicate indices;
df = df[~df.index.duplicated(keep='first')]
You are right. The method I mentioned is easier to understand for me, but less efficient and compact.
Yet I see that there is already the logic to avoid duplicates values in DatetimeIndex a bit above in the code. So the drop_duplicates should probably only be applied when the index is not a DatetimeIndex
On Thu, Dec 3, 2020, 14:43 cstocker73 notifications@github.com wrote:
In the SO post you link, they suggest the simpler and more efficient alternative to remove duplicate indices; df = df[~df.index.duplicated(keep='first')]
You are right. The method I mentioned is easier to understand for me, but less efficient and compact.
— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/ranaroussi/pystore/issues/38#issuecomment-738001622, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJ6S5WBNOHOOX2GXQXZRE3SS6IWRANCNFSM4LMZP53A .
Hi everyone. I'm using the useful pystore library to store also very long timeseries with string values. I noticed a very strange behaviour when I try to append to an existing string Timeseries item, as in the following example code. In particular when appending to an item in the database, the resulting dataframe in the databases loses many of its values.
Instead it works perfectly if I replace strings with floats:
Is pystore library able to store also string values? Thank you