Questions tagged [reindex]
459 questions
3
votes
3 answers
Filling missing time values in a multi-indexed dataframe
Problem and what I want
I have a data file that comprises time series read asynchronously from multiple sensors. Basically for every data element in my file, I have a sensor ID and time at which it was read, but I do not always have all sensors for…

Engineero
- 12,340
- 5
- 53
- 75
3
votes
1 answer
How can I remove json element by sub json value?
My json like this :
[{"id": 1, "name": "xkCT0QUAK7alZkYkbrLUfxoYyn9aXMh2kyCZeYFW.jpeg"},
{"id": 2, "name": "9Tg1QLJGiHPC39KP20iOgy3cYQSXOllJTEBGPcF7.jpeg"},
{"id": 3, "name": "fWEfhpRkfy44lqC3Ro1etJKmOOkMXnLJLT4ncS6x.png"}]
I have variable $id
if…

moses toh
- 12,344
- 71
- 243
- 443
3
votes
1 answer
Python Pandas DateTimeIndex
Below a DateTimeIndex from a DataFrame. The Summer/Winter timezone is 'US/Eastern', however the recorded time stamps are 'Europe/London'. I am trying to re-index which will achieve a full time sequence.
DatetimeIndex(['1993-10-24 21:00:00',…

James
- 796
- 1
- 8
- 19
3
votes
2 answers
Pandas reindex and fill missing values: "Index must be monotonic"
In answering this stackoverflow question, I found some interesting behavior when using a fill method while reindexing a dataframe.
This old bug report in pandas says that df.reindex(newIndex,method='ffill') should be equivalent to…

michael_j_ward
- 4,369
- 1
- 24
- 25
3
votes
1 answer
How to align indexes of many dataframes and fill in respective missing values in Pandas?
I have 4 dataframes with data of similar datetime indexes, however in each of them there are few missing lines and I know that the gaps can be filled using previous known data.
I would like to 'align' these dataframes so that they have union of…

danilam
- 75
- 2
- 5
3
votes
4 answers
run PHP script from cli : php.ini memory_size not taken into account
I am trying to run a php script (magento reindexer script) from the command line. The script consumes a lot of memory so I am getting the following error: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 72…

fkoessler
- 6,932
- 11
- 60
- 92
3
votes
3 answers
How to reindex Postgres 9.1.3 from the command line
I have a series of deletes and updates on a few tables in a Postgres database I manage. It has been suggested to schedule a reindex after the series of deletes as a solution to the 10 minute next-step update freezing infinitely (as it randomly…

Phoenix14830
- 360
- 1
- 8
- 24
3
votes
1 answer
Update an Elasticsearch mapping by updating an Index Template
I am currently using the config templates to store mappings for my indexes in ES and was wondering... If I updated my mapping in a template file, how would I go about propagating that mapping to already indexed documents? Is there currently a way to…

Eric Uldall
- 2,282
- 1
- 17
- 30
3
votes
1 answer
Magento Upgrade Script - Reindexing Catalog Url Rewrites
I would like to truncate magento core_url_rewrite table and reindex catalog url rewrites via an upgrade script. The table is truncated but the reindexing catalog url is not working. any help please..
//truncate magento core_url_rewrite…

vishant
- 55
- 8
3
votes
3 answers
Recursively call array_values() to re-index variable depth menu array
I have a multi-dimensional array and was able to successfully re-index the level keys (they were indexed at 1 and JSON was treating it like an object instead of an array) using array_values().
However, I need the subNavigationItems subarrays to be…

ryanpitts1
- 862
- 1
- 16
- 33
3
votes
2 answers
rake sunspot:reindex rake aborted! RSolr::Error::Http - 404 Not Found
I can no longer reindex and cannot resolve this issue.
Spend several hours digging the web for this issue. ** *regarding production environment * development goes ok. :( How would one fix this?
rake sunspot:reindex
rake aborted!
RSolr::Error::Http -…

Rubytastic
- 15,001
- 18
- 87
- 175
3
votes
3 answers
Magento Reindexing Data - Risks
I have a Magento site in which the cross-selling products do not seem to be appearing.
After looking on Stack and Google it seems that 'reindexing the data' has solved this issue for a lot of individuals.
My question is, are there any risks…

djnetherton
- 757
- 1
- 7
- 19
3
votes
2 answers
Solr full reindexing without downtime
We got the following problem at hand. We want to do a full reindex with 100 % read availability during the process. The problem arises when deleting old documents from the index. At the moment we´re doing sth. like this:
1) fetch all data from db…

chris
- 600
- 7
- 21
3
votes
2 answers
Solr exception: undefined field error with re-indexing
hoping you can help me. I've got a problem with an application I've just started maintaining. The application uses SOLR for indexing and is supposed to fill two cores with data from a database.
I keep getting the following error when…

sn0r
- 544
- 9
- 16
3
votes
1 answer
Pandas, Data Frame set_index & reindexing
I want read in weekday data and then reindex the data to fill the weekend with Friday's data. I have tried the following code but it will not reindex the data. Set_index produces a length error message.
import pandas as pd
def…

Dick Eshelman
- 1,103
- 2
- 12
- 17