5j: @SSKrSSKJrJrJr SSKJr SSKJ r \"S5r \"S5r \(a SS K J r SS KJr \S rS S S\SS 4SjrSS S S\S\S\SS 4 SjjrSS S S\\S\S\4SjjrS S S\R.SS 4SjrS\S\ 4SjrS SjrSSS\4Sjrg)!N)ListUnion TYPE_CHECKING)load)TimestampOrNaTnumpypandas)Series)ExtensionDtype)znp.dtyper df pd.DataFramelocreturncr[US5(aURX5 U$X RSS2U4'U$)a6 Set the given value in the column with position 'loc'. Library pandas changed `iloc` property and recommends using `isetitem` from 1.5.0 version. More details: https://pandas.pydata.org/docs/whatsnew/v1.5.0.html Link for isetitem method: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.isetitem.html Parameters ---------- df : pd.DataFrame Pandas dataframe to convert. loc : int Index for current column, when we need update value. value : scalar or arraylike New value for column. Returns ------- pd.DataFrame Modified dataframe isetitemN)hasattrriloc)rrvalues Z/root/lseg-credit/backend/venv/lib/python3.13/site-packages/lseg/data/_tools/_dataframe.pyset_df_column_valuers:6r: C I 3 Ientryutc delete_tzc [URR5VVs/sH+upVUR5UR5;dM)UPM- nnn[ XX#40UD6$s snnf)aConverts particular dataframe columns to datetime according the pattern. Converts particular dataframe column or columns if one of more columns matches the pattern, returns same dataframe otherwise. Parameters ---------- df : pd.DataFrame Pandas dataframe to convert. entry: str Pattern to find a column to convert. utc : bool Convert to UTC if True. delete_tz : bool Convert to timezone-unaware if True. Returns ------- pd.DataFrame Converted dataframe ) enumeratecolumnsvalueslower%convert_df_columns_to_datetime_by_idx)rrrrkwargsindexnamecolumns_indexess rconvert_df_columns_to_datetimer'4s_01:"**:K:K0Ln0LPUP[P[P]aeakakamPmu0LOn 0c _X^ __os (A%A%r&c UH|n[R"URSS2U44USS.UD6n[ XU5 U(dMDURSS2U4R R S5n[ XU5 M~ U$![a6n[R"URSS2U44USSS.UD6nSnANSnAff=f)aOConvert dataframe columns to datetime by index. Parameters ---------- df : pd.Dataframe Pandas dataframe to convert. columns_indexes : List[int] List of indexes of columns to convert. utc : bool Convert to UTC if True. delete_tz : bool Convert to timezone-unaware if True. Returns ------- df Converted dataframe. NcoercererrorsF)rr+cache)pd to_datetimer TypeErrorrdt tz_localize)rr&rrr#idx date_valuees rr"r"Qs* j3\S\U[\J BZ0 9C++77=J  4 I j 3iSY^ibhiJ  js+B C,CCpatternc [URR5VVs/sHup4URU5(dMUPM! nnn[ X4SSS.UD6$s snnf)aConvert dataframe columns to datetime using regular expression pattern. Parameters ---------- df : pd.Dataframe Pandas dataframe to convert. pattern : re.compile Regular expression pattern to check columns. Returns ------- df Converted dataframe T)rr)rrr searchr")rr5r#r$r%column_indexess r!convert_df_columns_to_datetime_rer9ysV099J9J/Kd/K w~~^bOce/KNd 0 hY] hag hhes AAscR[RUSSS9nURS5nU$)NTr)r*)r-r.r1)r: timestamp localizeds rconvert_str_to_timestampr>s,qd8 2020-12-31 00:00:00+00:00 Correct convert None, np.nan, pd.NA, pd.NaN to pd.NA, see official docs: https://pandas.pydata.org/pandas-docs/stable/user_guide/missing_data.html#missing-data-na Correct convert big int from Linux, Windows platform. Parameters ---------- df: pd.DataFrame Returns ------- pd.DataFrame r)is_object_dtypeis_datetime64_any_dtypeF)copyNobjectT)inplace)emptypandas.core.dtypes.commonr@rAfillnanpnan infer_objectsrrr rdtyperB_get_inferred_dtypestrr!replaceastyperr-NA) rr@rAr$_r&seriesinferred_dtype new_seriesresults rconvert_dtypesrWsY2 xx R 266  ( (e ( 4B-6rzz7H7H-IJ-Iu-IOJ E" "6<< 0 0 %%' 6 " "[[]F,V4 ~  $ $ &( 2J#++B7EE5EQJ0"((*h6#~.Bv.'!*IIbeeTI" I1Ks*F+rSr cSSKJn SSKJn U"UR5nS[ U5R 5;a2URS5S-S:HR5(aU"S5$U$)Nr)rW) pandas_dtypefloatirInt64) pandas.core.dtypes.castrWrGrYr rNr!rHall)rSpandas_covert_dtypesrYrTs rrMrMs^N6)&--8N#n%++--6==3G!3Kq3P2U2U2W2WG$$ r)NF)rrrr)retypingrrr _lazy_loaderr lazy_load_typesr rIr-pandas.core.seriesr pandas.core.dtypes.baser DtypeObjintrrNboolr'r"compiler9r>rWrMrrrks --+#wx)6 - . N   HIN``"`)-`AE``<Y^%%)-c%9=%QU%Pi.i2::i\ji( 7tXr