Category "pandas"

How to make a loop of random column combinations without repeating the combination in pandas dataframe?

I have a pandas dataframe that has 4 columns (A,B,D,E,F,G). I want to randomize each combination into 4 combinations (e.g. ABDE, ADEF, AEFG). And then add the c

How to save the Pandas dataframe from pd.crosstab as a figure (with render_mpl_table)?

I'm trying to save output from crosstab as an image. I found a great solution here How to save the Pandas dataframe/series data as a figure?. However, I am not

How to combine multi excel workbook into single workbook with multiple worksheets

I have 3 workboooks with single sheets.I need to combine all workbooks into single workbook with 3 sheets. I tried the below code : from pandas import ExcelWrit

Extracting specific number of rows from dataframe

I have a csv file having two columns i.e. imagename and ID. There are multiple image names for same ID as shown in picture. Number of image names against id is

Importing a data frame from CSV file using Pandas with column name having spaces

I am trying to import a data frame from a .csv file which contains Per Capita Income. Moreover, in the above mentioned file the column name is Per Capita Income

tag occurrences of a value multiple times inn column based on dates using pandas [duplicate]

Below is my dataframe: df = pd.DataFrame({'ID':[1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1], 'date': ['2020-12-1', '2020-12-2', '20

How to plot Dataframe for many rows?

I have a dataset where each row plots an ECG, with 50k rows, 181 columns and has 4 classes, represented in the last column (0, 1, 2, 3). So, I need to "convert"

How to combine multiple set of columns in a dataframe to single one? [duplicate]

I have a dataframe as follows Cycle A_0 A_1 A_2 A_3 B_0 B_1 B_2 B_3 1 3 4 5 6 1 4 5 1 8 5 3 1 0 8 6 4 2 7 9 1 6 1 0 2 3 3 5 9 1 0 3 8 3 th

Last word delete but keep if it is only one

I have a series of texts that has either one word or a combination of words. I need to delete the last word its greater than 1, if not leave the last word. Ha

Multiple Subplots & Multiple Colors in Plotly Express

I am having trouble creating subplots in plotly given a pandas data frame with multiple colors. Here is an incomplete example creating the individual plots: imp

Dataframe new columns to tell if the row contains column's header text

2 columns dataframe as the first screenshot. I want to add new columns (by the contents in the Note column from the original dataframe) to tell if the Note colu

Issue converting object to int in Python for OLS regression

I'm trying to run a multiple linear regression in Python. One of my columns "member_total" is an object and I can't figure out how to convert it into an int. Ri

Apply formula on a column conditional to another column

import requests from geopy.geocoders import Nominatim import streamlit as st import numpy as np import pandas as pd import random, string print('ville :') code

Generate multiple new pandas dataframes using lists and for loops

I have the following dataframe: import pandas as pd import numpy as np from numpy import rec, nan df1=pd.DataFrame.from_records(rec.array([(202001L, 2020L, 'app

RankWarning: Polyfit may be poorly conditioned

I am trying to find the rolling price slope of btc trading data (minute data) using pandas. When I run the script, the following error / warning pops up sys:1:

RankWarning: Polyfit may be poorly conditioned

I am trying to find the rolling price slope of btc trading data (minute data) using pandas. When I run the script, the following error / warning pops up sys:1:

Update django model objects from editable dash data-table

I want to update my models by an editable plotly dash-table (populated by a dataframe, himself populated by sqlconnection with models) in Django but I don't kno

String Into Integer while sorting

Curious if there is a way to convert a string into an integer, only during the sort_values() process, or if it's easier to convert the variable to an integer pr

DataFrame is highly fragmented

I have the following code, but when I run it I receive the error: PerformanceWarning: DataFrame is highly fragmented. This is usually the result of calling fra

Using multi character delimiter while exporting SQL table as text file using python

I am trying to export SQL table as multi-character delimited text file in python. I have tried using Pandas, but it is only supporting single character as delim