Stack Overflow
Stack Overflow

Questions tagged [reindex]

459 questions
2
votes
1 answer

IntelliJ IDEA constantly reindexing

I am working on a very large project in IntelliJ IDEA (currently version Ultimate 2020.1.4) - with over 100,000 java files, close to 50,000 resource files, dozens of modules, several gigabytes of external libraries - you get the idea. When I first…
Aleks G
  • 56,435
  • 29
  • 168
  • 265
2
votes
1 answer

How to replace the current dimension of an xarray object with two new ones

I am a Pandas user migrating to Xarray because I work with geospatial 3D data. Some stuff I only know how to do using Pandas and many times doesn't make any sense to convert to a Pandas DataFrame and then reconvert it to Xarray Dataset object. What…
iury simoes-sousa
  • 1,440
  • 3
  • 20
  • 37
2
votes
2 answers

Index size after autovacuum

Good day. I was reading Postgres official documentation related to Vacuum process and Reindex routine. Some sentences were unclear for me so I want to clarify them.(Postgres documentation for version 12) First of all. I did understand that…
Almas Abdrazak
  • 3,209
  • 5
  • 36
  • 80
2
votes
0 answers

reindex doesn't fill with NaN

I have a series. index = pd.MultiIndex.from_tuples([('bar', 'one'), ('bar', 'two'), ('baz', 'one'), ('baz', 'two'), ('foo', 'one'), ('foo', 'two'), ('qux', 'one'), …
Ch3steR
  • 20,090
  • 4
  • 28
  • 58
2
votes
2 answers

Pandas insert rows based on value and fill with 0

I have the following dataframe, with the following values. I want to insert rows in order to have a row for every person (Toby, Jane, David), and for every month in 2020. If there is no value for x or y, then fill with 0. ID Name Date …
Louis GRIMALDI
  • 101
  • 1
  • 12
2
votes
1 answer

Reindexing provides values instead of NaN for missing values

I want to complete my time serie of % humidity with missing records (or rows). Sensors are designed to record a mean value each 15min, so that is my target frequency. Here an example for one station (not the best in terms of gaps...) but I have 36…
Emilie REDON
  • 21
  • 2
2
votes
1 answer

Pandas Multiindex Series Level Reindex

I have the ser_apl pandas.Series with 2-level MultiIndex: Date Team 2013-01-31 Man Utd 11 2013-02-28 Man Utd 12 2013-03-29 Man Utd 13 2013-04-30 Man Utd 14 2013-05-31 Man Utd 15 2013-06-28 Man Utd …
igharok
  • 95
  • 3
2
votes
3 answers

Reindexing Pandas Dataframe with specific datetime indexes

I have a simple question best described with an example. I am trying to render output_df based on current_df and parent_df. current_df: simple time series df with datetime index Index Val '10-1-2010 08:00:00' …
BeardedDork
  • 162
  • 2
  • 13
2
votes
2 answers

How to "stretch" my dataframe and interpolate in between existing values

I'm stuck with a simple DataFrame.reindex().interpolate() problem because the dataframes I am using don't have a datetime index. I have DataFrame1: t that looks like this: In[1]: import pandas as pd t = pd.DataFrame({'D18O': [-0.47, -0.12, 0.55, …
flurble
  • 1,086
  • 7
  • 21
2
votes
0 answers

Getting “DDL statements are not allowed in transactions ” error when re-index programmatically in magento 2.2.X

I am working on Magento 2.2.6. As per requirement I need to do re-index on sales_order_save_after event. It is working well in Magento 2.1.X but I am getting following error on Magento 2.2.X. Error: CRITICAL: User Error: DDL statements are not…
David Coder
  • 1,138
  • 2
  • 14
  • 48
2
votes
1 answer

How can i reindex a monthly pandas series to mins, having the values corresponding to the month in every day of the resulting days of thats months?

i have a pandas series of this form: 1950-01-31 2.0 1950-02-28 2.0 1950-03-31 1.0 1950-04-30 2.0 1950-05-31 0.0 1950-06-30 0.0 i would like to reindex passin from monthly to mins likes this: 1950-01-31 00:00:00 …
jorge
  • 23
  • 4
2
votes
2 answers

how does pandas DataFrame use groupby() to split and combine data

I have data like this: (a smaller version of actual DataFrame structure ) week day val 1 0 8 1 1 9 1 2 6 1 3 3 1 4 4 1 5 2 1 6 6 1 7 9 2 0 3 2 1 1 2 2 2 2 3 6 2 4 8 2 5 9 2 6 6 2 7…
user10025959
  • 55
  • 1
  • 7
2
votes
2 answers

Pandas: filling the gap in time with certain value

I have the following data frame: timestamp value 2018-02-26 09:13:00 0.972198 2018-02-26 09:14:00 1.008504 2018-02-26 09:15:00 1.011961 2018-02-26 09:18:00 1.018950 2018-02-26 09:19:00 1.008538 2018-02-26…
Edamame
  • 23,718
  • 73
  • 186
  • 320
2
votes
2 answers

Add an index column and reindex dataframe by matching partial index lables

I have a multiindex df s: arrays = [['bar', 'bar', 'baz', 'baz', 'foo', 'foo', 'qux', 'qux'], ['one', 'two', 'one', 'two', 'one', 'two', 'one', 'two']] tuples = list(zip(*arrays)) index = pd.MultiIndex.from_tuples(tuples, names=['first',…
xiaoshir
  • 215
  • 4
  • 17
2
votes
1 answer

How to Set Up a Cronjob to Reindex Magento 2 inside Docker

I'd like to know how to set up a cron job to reindex Magento 2. I have installed crontab in my docker by running apt-get install cron inside my php container, then I run crontab -e and I'm able to see and edit my cronjob file. So I set up a…
Rafael Padovani
  • 95
  • 1
  • 10
1 2 3
…
30 31