Category "pandas"

polars dataframe TypeError: must be real number, not str

so bascially i changed panda.frame to polars.frame for better speed in yolov5 but when i run the code, it works fine till some point (i dont exactly know when e

How to append row from itertuples to dataframe withouth losing the index in Python?

I have the following problem: I have a DataFrame df which looks like this: eqpid recpid queuetime trackintime trackouttime 3723

Using complex operations in query method of pandas

Let say I have below code, import pandas as pd dat = pd.DataFrame({'col1' : [1,2,3,4,5,6,7,8,9,10], 'col2' : ['A', 'X', 'D', 'Y', 'A', 'D', 'Y', 'X', 'D', 'A']}

How to delete empty spaces from pandas DataFrame rows until first populated field?

Lets say I imported a really messy data from a PFD and I´m cleaning it. I have something like this: Name Type Date other1 other2 other3 Name1 '' '' Type1

ModuleNotFoundError: No Module name 'pandasql'

I am trying to import pandasql. I am running the following code in a jupyter notebook running python: !pip install pandasql from pandasql import sqldf import

Pandas pivot table. Getting modes and relevant percentage

Here is the problem. While creating a pivot table in pandas data frame, I need to aggregate the column values for their modes as well as their relevant percenta

Create multiple boolean columns in pandas dataframe based on multiple conditions

I have a dataset, where authors are ranked by the order of authorship (1, 2, 3, etc). Authorid Author Article Articleid Rank 1 John article 1

Pandas: Writing Dataframe to an open Excel File

I am trying to call this python script from VBA in Excel with the click of a button, it will read the data but it will not write if the Excel file is open.. Eve

Pandas: Writing Dataframe to an open Excel File

I am trying to call this python script from VBA in Excel with the click of a button, it will read the data but it will not write if the Excel file is open.. Eve

How to keep columns header on excel without change after export data to excel file?

I work on sql server 2017 I run script depend on python language v 3.10 . I need to export data to excel fileStudentExport.xlsx already exist, and keep header w

Create a column for each first directory of a path and fill the column with each last directory of the same path

This dataset represents a collection of image information. Each image has some tags that are stored very badly. In particular I have a dataframe with a column (

Stacked bars are unexpectedly annotated with the sum of bar heights

My data: names_col = ['Count','Freq'] dat = [['Matching', 56935],['Mismatching', 100587]] plot_df = pd.DataFrame(data=dat,columns=names_col) I trying plot stac

Exception occurring just in PyCharm

I get 'NoneType' object is not callable' when I try to debug the following code in PyCharm IDE. I don't get the same error when debbuging at Visual Studio Code

pandas- label firm panel

I have a panel of firms, and I want to do the following. Based on some conditions, I want to create a column with labels for each firm. See an example: I want

Transforming data using Python Pandas (or M) in Power Query for PowerBi

I have some data about projects I would like to transform in a way that makes it easier to analyse with PowerBi. The data looks like this: Project Number Proje

Hungarian Algorithm Constraint using Python

I have dataframe of job and employee, with the duration each employee can finish each job. I want to use Hungarian algorithm to assign each job to 1 employee, a

creating new column in dataframe with the values from another column in the same dataframe [duplicate]

As a scientific researcher I am a beginner in Python. I am trying to make a new column in the following dataframe:

PySpark read data into Dataframe, transform in sql, then save to dataframe

New to Spark and Synapse....Need to do some transformation including adding a columns, changing datatypes, etc. I am reading a csv into a dataframe. I'd like t

pandas: declare a pandas dataframe as a constant

I would like to declare my dataframe as constant, so no matter what operations are happening in a modeule it's values or column names do not change. I know that

Apply change to timedelta to columns containing a given string

Be the following DataFrame in python pandas: date time_SEL time_02_SEL_01 time_03_SEL_05 other 2022-01-01 34756 233232 3432423 756 2022-01-03 23322 4343 3334 3