Questions tagged [indexing]

0 votes
0 replies
SumIfs Formula Issue
I have a monthly spreadsheet that has a link taking you to another spreadsheet with totals, could be one total by vendor, could be several accord...
asked 1 month ago
0 votes
0 replies
What is the most efficient way to extract variables from a dataframe?
I have two data frames: df1 and df2. df1 provides the rank for all integers within a sequence given start and end coordinates, for a given catego...
asked 1 month ago
1 votes
1 replies
how to create index to speed up data retrieval
I have this query below it gets 6000+ row of items from the server the downloaded data is only 317KB but it takes almost 25 seconds or the IIS se...
asked 1 month ago
-4 votes
0 replies
Getting “Key Error: not in index” when trying to run a regression with Python using pandas
My code with error: https://ibb.co/W0TkxQv My column titles include Number_Homes and Median_Income so I don't know how they aren't in the index....
asked 1 month ago
0 votes
0 replies
Can a Sitecore Lucene index be programmatically built?
When using Lucene indexing in Sitecore, is it possible to add items to an index based on the content of an item? Indexes can be built based on t...
asked 1 month ago
0 votes
1 replies
Threads indexing out of bounds in CUDA kernel
I am running a CUDA kernel which seems to be indexing out of bounds and I can not figure out why. I get error 8 write-of-size in cuda-memcheck....
-2 votes
0 replies
Calculate index with negative values in R
i have to calculate an index for different values. The values should be between 0 and 100. This works fine, as long as the numbers in the vector...
asked 1 month ago
0 votes
1 replies
How to Store Index of an Element from 2D Array into a 1D Array then Swap those Values
I'm having trouble on finding how to store the row and column index of one element from a 2D array into a 1D array. Once those indexes are stored...
asked 1 month ago
0 votes
1 replies
Python index with s, d, b, c, o, x, X, n, etc… what are they?
I did not realize that Python indexes can have characters and not just integers. I was looking at this Tensorflow tutorial for RNN text generati...
asked 1 month ago
1 votes
2 replies
Why use B tree for database index other than AVL tree
I heard some statements like, consider the height of the AVL tree and the maximum keys that an AVL tree node can contain, the search of AVL tree...
asked 1 month ago
1 votes
1 replies
argmax for multidimensional array along some axis
I have a multidimension array that looks like this: my_array = np.arange(2)[:,None,None] *np.arange(4)[:, None]*np.arange(8) I am looking for...
0 votes
0 replies
Mongodb get detailed index info
Can somebody tell me please if is possible to get detailed info about indexes in Mongodb? I need to show the time when index was created. But com...
asked 1 month ago
0 votes
1 replies
How to get the index of targeted element in this code?
I'm trying to get the index of targeted element inside of the forEach - addEventListener method. But it is not easy to get those as I thought bef...
asked 1 month ago
-1 votes
0 replies
Integer-array indexing functionality in numpy
Could someone please explain the below logic - what's happening with rows, cols and y? Thanks in advance. import numpy as np x = np.arr...
asked 1 month ago
1 votes
1 replies
Index out of bounds exception with indexof
def toLowerCase(str: String): String = { val lowerCase = "abcdefghijklmnopqrstuvwxyz".split("") val upperCase = "ABCDEFGHIJKLMNOP...
asked 1 month ago
0 votes
1 replies
How to specify order during np.reshape
I have a numpy ndarray of shape (t, n, h, w, c). I want to partially flatten it to get an ndarray of shape (t*n, h, w, c). However, I want to be...
0 votes
1 replies
Count with subselect really slow in postgres
I have this query: SELECT c.name, COUNT(t.id) FROM Cinema c JOIN CinemaMovie cm ON cm.cinema_id = c.id JOIN Ticket t ON cm.id = cinema_movie_id...
asked 1 month ago
2 votes
0 replies
Column values A1, A1, A1, how to convert to A1-1, A1-2, A1-3 [duplicate]
I have a Pandas DataFrame that has unique records, but I need to create a unique key based on one of the columns. Below is sample data and my att...
asked 1 month ago
3 votes
2 replies
Magento 2 products are not showing frontend
In our magento 2 store,products are not showing in frontend but they are in the backend. Every day we are importing products using api and at som...
asked 1 month ago
1 votes
0 replies
Firebase realtime .indexOn
after reading quite some about .indexOn I thought I understood how it worked but it seems I am still a bit lost for one case. My trouble is tha...
asked 1 month ago
0 votes
1 replies
Mongodb compound index is not in use with query
Hi can somebody explain me please how to make compound index for this simple query? find({ "userId":{"$in":["5c778c4f52732c06d3384269","5b27...
asked 1 month ago
0 votes
1 replies
Windowing values from numpy 2D array
I have an a 2D array of values,A. I want to window the values within this array around the index given by a 1D array,b. import numpy as np A =...
asked 1 month ago
1 votes
0 replies
Exporting Oracle schema with DBMS_DATAPUMP does not export ctx_ddl preference and does not create ctxsys.context index type
We implemented a procedure to export a database schema using DBMS_DATAPUMP. In the schema, we have a CTX_PREFERENCES to use SUBSTRING_INDEX attri...
asked 1 month ago
0 votes
1 replies
Primary key vs foreign key when fetching a entity and it's related data in Entity Framework
If I have four tables RecordProducts, Records, Products, and Defendants with RecordProducts having these values as ids to the other three tables....
asked 1 month ago
1 votes
1 replies
Improve query speed suggestions
For self education I am developing an invoicing system for an electricity company. I have multiple time series tables, with different intervals....
asked 1 month ago