For example in the following dataframe the column 'b' is calculated based on the last time column 'a' was True: a b 0 True 0 1 False ...

I have a Pandas Series with the names of cities and districts: London:Alpha London London:Beta London:Delta Paris I want to add "_sub" at the end of e...

I have scoured this forum, and have yet to find a solution to my problem. I am using pandas dataframes, and I need to order this column, which of type...

I want to reshape my dataset from this: Date Item A B 1 1 a1 b1 1 2 a2 b2 1 3 a3 b3 to this Date Letter Item 1 Item 2 Item 3 1...

I have a table with data for who viewed a page and who clicked on it. The following code gets me the pivot table below: # users who clicked, by hour a...

I have a CSV file that looks like time Col_A Col_B Col_C Col_D Price 123 A1 B1 C2 D6 23.43 124 A5 B3 C7 D1 14.63 125 A3 B2 C3 D2 343.43 ...

I have two dataframes, one with the current estimate and one with the previous estimate. I want to create a new dataframe that shows the lines that ha...

I have a data that looks like this: In bytes literal form data b'[{"Name":"USA Stocks","Code":"US","OperatingMIC":"XNAS, XNYS","Country":"USA","Curre...

I'm looking for a kdb like left join (left inner join) in pandas(seems like pandas merge and join method provide left outer join support) Toy example ...

I would like to compute a distance distance between all elements of two series: import pandas as pd a = pd.Series([1,2,3], ['a', 'b', 'c'] ) b = pd.Se...

I want to write a code (with few lines) that runs t-test on Product and Purchase_cost,warranty_years and service_cost at the same time. # dataset im...

I made this code that allows me to create a table in an excel file. Only I wanted to add at the beginning of the column a string and then afterwards a...

I created a document-term matrix from multiple txt files. The result is a dataframe with each column being a word, and each row being a file (my final...

SELECT a.year, a.country, b.amount FROM table_a a LEFT JOIN table_b b ON a.country=b.country AND (CASE WHEN b.country = 'Europe' THEN b.year = 2022 EL...

Certainly! Here is a draft of your Stack Overflow question with proper code formatting: Title: How to calculate time between sessions for each ID in a...

I am currently working on a project where I need to validate that some dates in a python dataframe are respecting a specific format such as days[any d...

Imagine that I have a dataset df with one column containing a dictionary with two list types (list_A and list_B) as value: data = [{"list_A": [2.93, 4...

I have two Data Frames df and df1, based on the date range from df i want to sum the Distance column in df1 from io import StringIO data = """IGN,Ex...

I have dataframe with column that contains lists with id of objects and objects alias in other dataframe. I want to replace id in column with lists in...

I have a pandas dataframe as below and I would like to transpose the df based on the column Names I want transpose all the coumns that has _1,_2,_3 & ...

I have the following sample input table below. The Time column is in the format of hh:mm:ss or hours, minutes, and seconds. Name Time Jim 1:3...

I have this function in pandas: def rolling_pd( dataf: pd.DataFrame, groupby_cols: Union[str, list], column: str, function: str = "mea...

For instance, I create a pandas dataframe: data = [['nick', 3, '2023/11/22 10:05:00', 'A'], ['tom', 3, '2023/11/22 9:25:00','A'], ['juli', 2, '2023/11...

I have a csv file that I am importing to a pandas dataframe. Here is an example of the data in one of the columns. Each value between the delimiters i...

I have a pandas dataframe where the column names are capital and snake case. I want to convert them into camel case with first world starting letter t...