How to speed up work with pandas index?

Thread Rating:

Thread Modes

How to speed up work with pandas index?

AlekseyPython
Lumberjack

Posts: 109

Threads: 52

Joined: Oct 2018

Reputation: 3

Oct-16-2019, 02:06 PM (This post was last modified: Oct-16-2019, 02:09 PM by AlekseyPython.)

When I create an index, its type independently changes to uint64 (from uint8):

periods_clients.set_index(['Client'], inplace=True)

and when I add the first value:

periods_clients.loc[Client] = [current_date, current_date, current_price, current_price]

to float64. Client is equal 0, which type I tried change to: int, int8, int64, uint8, uint64. Why?

Messages In This Thread

RE: How to speed up work with pandas index? - by AlekseyPython - Oct-16-2019, 02:06 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Grouping in pandas/multi-index data frame	Aleqsie	3	688	Jan-06-2024, 03:55 PM Last Post: deanhystad
	How to further boost the data read write speed using pandas	tjk9501	1	1,269	Nov-14-2022, 01:46 PM Last Post: jefsummers
	[split] Getting Index Error - list index out of range	krishna	2	2,617	Jan-09-2021, 08:29 AM Last Post: buran
	Getting Index Error - list index out of range	RahulSingh	2	6,159	Feb-03-2020, 07:17 AM Last Post: RahulSingh
	pandas.read_sas with chunksize: IndexError list index out of range	axelle	0	2,590	Jan-28-2020, 09:30 AM Last Post: axelle
	Applying operation to a pandas multi index dataframe subgroup	Nuovoq	1	2,657	Sep-04-2019, 10:04 PM Last Post: Nuovoq
	pandas: can we look for the index of a string	paul18fr	2	2,214	Jul-31-2019, 08:25 AM Last Post: paul18fr
	How to get first and last row index of each unique names in pandas dataframe	SriRajesh	1	4,522	Oct-13-2018, 07:04 AM Last Post: perfringo
	Select in Multi Index Pandas	diego_last	0	2,344	Aug-01-2018, 12:56 PM Last Post: diego_last
	Using pandas, index error	fyec	1	4,691	Aug-01-2018, 09:25 AM Last Post: volcano63

Users browsing this thread: 2 Guest(s)