Category "pandas"

Basic Trading strategy with python

I am trying to code a basic trading strategy call sell the winner and buy the loser. I have listed the three conditions I want to code in python. I am a newbie

Limit writing of pandas to_excel to 1 million rows per sheet

I have a dataFrame with around 28 millions rows (5 columns) and I'm struggling to write that to an excel, which is limited to 1,048,576 rows, I can't have that

Placeholder for DataFrame in pd.query

I use pd.query and pd.eval a lot. However, sometimes I find myself in situations where I would like to filter an unnamed DataFrame with pd.query and it would be

Issue when selecting desired elements from dict_keys in Python

I have a list of disctionary keys ['A_report1', 'A_report2', ..., 'A_report10','B_report1', 'B_report2', ..., 'B_report10',]. I want to extract all 'report1' fr

ValueError: 18 columns passed, passed data had 1 columnss

#pip install sqlalchemy #from Google import Create_Service # link to source code is in the description import pyodbc as odbc # pip install pypyodbc

Python SUMIF with one condition across dataframes

I'm working with two dataframes MRP: Material Description Septiembre 1208181 ADSV,NA,MX,ADH HOTMET 814433PM 630.2888856 1206500 SHWP,NA,MX,WRAP M-WRAP 18' 459.

How can I get last value of STOCHRSI with Ta-Lib?

I implemented it but it prints all. print(ta.STOCHRSI(df["close"], 14, 5, 3, 0)[-1]) 2022-04-20 17:00:00 NaN 2022-04-20 18:00:00 NaN 2022-04-

How to sample a python df on daily rate when it is greater than 500 yrs

I need to sample a dataframe that has a date range of 100 years at a daily rate because I want to get yearly totals (so I thought resample at daily rate then su

pandas df.to_parquet write to multiple smaller files

Is it possible to use Pandas' DataFrame.to_parquet functionality to split writing into multiple files of some approximate desired size? I have a very large Data

Replacing ID values of polygons in a geodataframe to values of polygons from another geodataframe

I have polygons inside another bigger single polygon and I want to be able to replace the ID values (for example) of the former polygon to that of the latter. S

Pandas: Sampling from a DataFrame according to a target distribution

I have a Pandas DataFrame containing a dataset D of instances which all have some continuous value x. x is distributed in a certain way, say uniform, could be a

Plotly chart is a mess of lines after index converted to pandas datetime

My plotly chart is just a mess of zig-zagging lines (see chart here). This only happens after I use df['Date'] = pd.to_datetime(df.index) to convert the index t

Convert pandas data frame column, which has values of vectors, into tensors

My question is how to convert a vector on pandas data frame into tensors. The data frame has a resume column which has a vector representations of each resume d

Write to an existing .xlsm using pandas and XlsxWriter

I would like to write a dataframe to an existing .xlsm file which already has content. Write pandas dataframe to xlsm file (Excel with Macros enabled) describes

Display count on top of seaborn barplot

I have a dataframe that looks like: User A B C ABC 100 121 OPEN BCD 200 255 CLOSE BCD 500 134 OPEN DEF 600 1

Im getting a different output than expected when using df.loc to change some values of the df

I have a data frame, and I want to assign a quartile number based on the quartile variable, which gives me the ranges that I later use in the for. The problem i

How to add a new row after every unique entries in pandas dataframe

I have to add a new row at the end of each person information. In the new row which we will add all the information will be same as last row like name, last_upd

Why does pandas.json_normalize(json_results) raise a NotImplementedError?

I have a json variable named json_results and I am running pandas.json_normalize(json_results). It raises the following error: in _json_normalize raise NotI

Save image with fig.write_image in Python Plotly

I would like to save images within plotly fig.write_image using a forloop, where each image name include a customised id and Timestamp value with a string forma

median in pandas dropping center value

I am working in pandas and want to implement an algorithm that requires I assess a modified centered median on a window, but omitting the middle value. So for i