Tag: multiple-columns

How can I find a word and print it along with his next word in Python

loops multiple-columns pandas python string

I have the following list: From dataframe column I want to find texts that have the words of the list in order to generate a new column that can print these words along with the next word, for example, in a column cell there is the following text WOULD NOT PRIME CORRECTLY DURING VIRECTOMY., I want a new column that

Reorder subset of columns in pandas dataframe with natural sorting

dataframe multiple-columns pandas python

I have the following dataframe: and I would like to sort only the columns with the F in this way: How could I do? (edit) The columns with the “F” can vary both in quantity and in the values that follow the F (in my case I have about 100 columns like those) The columns with F are always grouped

Process columns based on column names in another column

dynamic multiple-columns pandas python

I like to select cells for processing by choosing column names contained in a different column. For clarity, input and output are given below. Column ‘a’ contains the column names for setting the value to None for each row. I tried to code as below but keep getting errors. Input Output Answer Check with mask and numpy boardcast Or we

Shifting depending on different columns and begining the shift depending on changes in columns

multiple-columns pandas python shift

I have a dataframe (here an example) Date UnitId ServiceDomineId Interval ServiceTime 01/01/2021 1 1 8:00 30 01/01/2021 1 1 8:30 20 01/01/2021 1 1 9:00 10 01/01/2021 2 1 8:00 50 01/01/2021 2 1 9:00 10 01/01/2021 1 2 8:30 25 01/01/2021 1 2 9:00 15 01/01/2021 1 2 9:30 30 01/01/2021 2 2 8:00 45 01/01/2021 2 2

Get the first and last value of a column of dataframe respect another column

dataframe format multiple-columns python unique-values

I’m a beginner on python and I would like to get the first and last value of the column date always that the mac_address be the same, for example: I’ve ordered my dataframe by mac_address, date with the next line: And the data are: NOTE: the date column has the format “2021-01-01 05:50:54” and the differents mac address that appears

What is the best way to filter rows of one dataframe based on column entries of another dataframe

dataframe isin multiple-columns pandas python

I have two dataframes in python, one called DayList, with these columns: OrderNr Powder Variant Quantity DueDate, and another one called Planning, with these columns: Order Start End Day Powder Variant Task. Both dataframes will have multiple lines with specific combinations, the column entries for Powder and Variant will be an integer, I want to filter the dataframe DayList into

Check column for variable and get value from another column in matched row

csv loops multiple-columns python

How can I get the values of one column in a csv-file by matching attributes in another column? CSV-file would look like that: I only want to get the values of column 3, if they have the value “car” in column 2. I also do not want them to be added but rather have them printed in a list, or

Calculating the sum of the quantities of one dataframe based on dates in another dataframe (Python)

date multiple-columns python

Suppose I have a first df like this: df1: I also have a second df (df2) with the items, a date and a quantity df2: Now I want to sum the quantities from df2 where the date is between the columns date1 and date2. So my result would look like: df3: I’ve been starring at it for a while now

extract new columns and fill values based on categorical values data frame in python

categorical-data dataframe multiple-columns pivot python

I have a data frame where one column is categorical strings and the next one is the values corresponding to it: I want to create new columns based on df.status column, and fill empty ones with np.nan, requires pivot on multiple columns: I am looking for an efficient solution that works for large data frames. Answer You want: