How can I add a new column to dataframe that has the same name as values in another column? My dataframe is: import pandas as pd df = pd.DataFrame({ ‘Col1’: [2, 74, 37, 36, 95], ‘Col2’: [36, 80, 9, 26, 16], ‘Col3’: [20, 4, 7, 55, 91], ‘Col4’: [‘Col2′,’Col2′,’Col2′,’Col2′,’Col2’] }) So I need to add… Read More Pandas new column based on value from another column
I am working with a bucketload of data that has the form: import pandas as pd import numpy as np lat = np.array([80.589, 80.592, 80.595]) lon = np.array([50.268, 50.264, 50.260]) wav = np.array([[486, 605, 666, 821, 777, 719], [ 65, 60, 68, 67, 72, 64], [866, 946, 882, 855, 999, 1195]]) print("lat shape:",lat.shape) print("lon shape:",lon.shape)… Read More How do you mix 1d and 2d variables in a pandas dataframe?
I am trying to go over a loop to add columns into a empty dataframe. each column might have a different length. Look like the final number of rows are defined by lenght of first column added. The columns with a Longer length will be cut values. How to always keep all the values of… Read More how to add a new column with different length into a existing dataframe
I have pandas multi-index dataframe that like this. I need to remove rows where bnds equals to 1.0. I’ve tried to do df_f.drop(‘1.0′, level=bnds, axis=0, inplace=True) as per documentation, but getting error NameError: name ‘bnds’ is not defined Honolulu time_bnds Seattle bnds time 1.0 2015-01-01 12:00:00 70.277412 2015-01-01 00:00:00 13.346752 2015-01-02 12:00:00 69.948593 2015-01-02 00:00:00… Read More How to remove rows from MultiIndex Dataframe
I have a csv file, which has couple of columns. The one I’m interested is ‘Date’ column and more specifically I’m interested by the first row of that column, the first date that appears. So i have a file that i read as a csv using pandas: FILE = pd.read_csv(FILENAME) # doesnt work last_scraped_date =… Read More Get the first element of a column using pandas
I am working on a dataframe df in python. I need to query and sort the results multiple times, but on different columns: for x in X: # query the dataframe and sort the result query_result = df.query(f"column_name == ‘{x}’").sort_values(by="other_column") # … use query_result … I am wondering if I can factorize the sorting operation,… Read More Is a pandas.DataFrame still sorted after using the method `query`?
I have a data frame of multiple columns. I want to select the first column and produce 7 more by multiplying the first column in multiples of 2. Help out, please I tried creating more columns, but the data is not transferred to the new columns. >Solution : Assuming such an input: import pandas as… Read More Creating new columns by generating a multiples of 2
My data frame is similar to below: Name Col1 Col2 Col3 Col4 Col5 Col6 A Y Y Y B Y Y Y Y C Y Y Y D Y I want to add a column that counts the other columns containing a value similar to: Name Col1 Col2 Col3 Col4 Col5 Col6 Score A Y… Read More Add Column with a count of other columns that have any value in
I am trying to merge two dataframes such that i end up with one with same number of columns but but an increased row count. import pandas as pd, numpy as np data1 = [[‘date’ , ‘symbol’, ‘value’], [‘1999-01-10’, ‘AAA’, 101], [‘1999-01-11’, ‘AAA’, 201]] I am trying to merge two dataframes such that i end… Read More Pandas merge complaining about non unique labels when key is a composite and unique
Consider the following piece of python code, which is essentially copied from the first code insert in the Transformation section of pandas‘ user guide’s Group by: split-apply-combine chapter. import pandas as pd import numpy as np speeds = pd.DataFrame( data = {‘class’: [‘bird’, ‘bird’, ‘mammal’, ‘mammal’, ‘mammal’], ‘order’: [‘Falconiformes’, ‘Psittaciformes’, ‘Carnivora’, ‘Primates’, ‘Carnivora’], ‘max_speed’: [389.0,… Read More Unexpected output from pandas' DataFrameGroupBy.diff function