python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - indexing

Azure Congnitive Seach index int64 does not accept string value

I'm using a Python Azure App Function to copy data from a SQLServer database to a Azure Cognitive Search index. The problem I'm seeing is that there are some nvarchar fields that contain numeric data...
test-img

Mark Faulkner

azure

search

indexing

azure-cognitive-search

Votes: 0

Answers: 1

Latest Answer

You're getting the error since you're trying to convert from a varchar to a Edm.int32 index field and that is not supported. As per https://learn.microsoft.com/rest/api/searchservice/data-type-map-for...
test-img

Gia Mondragon - MSFT

Problems with replacing NaT in pandas correctly

I have a dataframe that contains some NaT values. Date Value 6312957 2012-01-01 23:58:00 -49 6312958 2012-01-01 23:59:00 -49 6312959 NaT -48 6312960 2012-0...
test-img

AkariYukari

python

pandas

datetime

indexing

Votes: 0

Answers: 2

Latest Answer

Use Series.fillna with shifted values with add 1 minute: df['Date'] = df['Date'].fillna(df['Date'].shift() + pd.Timedelta(minutes=1)) Or with forward filling missing values with add 1 minute: df['Dat...
test-img

jezrael

eIteration over pandas dataframe index

I want to iterate over a list (tokens), and if a specific token is contained within the list tokens, then I want to assign a value on a pandas dataframe column. My task can be seen in the following li...
test-img

Aggelos Tamvakis

pandas

loops

for-loop

indexing

Votes: 0

Answers: 0

SQL Match Against Fulltext Index is slow when searching common terms

Simple PHP search page with three fields querying a MySQL database with millions of rows. The data consists of profiles, mostly USA. Fulltext indexing increases speed by a factor of 9.6 when the searc...
test-img

Ned Hulton

mysql

sql

indexing

query-optimization

fulltext-index

Votes: 0

Answers: 2

Latest Answer

If you could know that the search is on a country name and that you need to look only in the country column, then this would be much faster than any of the above: ... WHERE country = 'canada' What we...
test-img

Rick James

Posts

Questions

Blogs

Jobs