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