So what I want is to randomly chose a given amount of elements on my dataframe, and to those elements, apply an operation (which will be a multiplication by a number which will also be randomly chosen between a range) to an ‘eta’ column. I’m stuck on achieving this. atm I’ve randomly gotten a list… Read More Apply a multiplication to random elements on my dataframe [Solved]
I’m looking to count how many people are below a given user of the data frame. Employee Manager A – B A C A D A E A F B G B H C I C I would like to get in the output: I, H, G, F, E and D have no employees below… Read More How to count people who are below a position
I’m taking a course and I need to solve the following assignment: "In this part, you should write a for loop, updating the df_users dataframe. Go through each user, and update their zip code, to Safe Harbor specifications: If the user is from a zip code for the which the “Geographic Subdivision” is less than… Read More Masking the Zip Codes
I have a dataframe that is structured like so (similar to a pivot table): A B December 2022 January 2023 A1 B1 100 200 A1 B2 101 201 I’d like to and transpose my dataframe in a way so it reads: Month A B Value December 2022 A1 B1 100 December 2022 A1 B2 101… Read More Reshaping Multi Indexed DF
I currently have a dataframe like this Person Analysis Dexterity Skills 174 3.76 4.12 1.20 239 4.10 3.78 3.77 557 5.00 2.00 4.40 674 2.23 2.40 2.80 122 3.33 4.80 4.10 I want to add an column to compile all this information like below Person Analysis Dexterity Skills new_column 174 3.76 4.12 1.20 {"Analysis":"3.76", "Dexterity":"4.12",… Read More Create a custom column in a dict format
I have a csv file which has 3 columns. The first one is session_id, second one is item_id and last one is date. I am trying to delete the rows which does NOT have 2020 as date. Because I want to work on only 2020 dated data. I did some research but I couldn’t find… Read More How to delete the elements with the date except 2020 from csv file with Python?
I have a list with few items and I need to compare Consecutive items of them. e.g: ‘item_1’ ‘item_2’ ‘item_2’ ‘item_3’ ‘item_3’, ‘item_4’ ‘item_4’, ‘item_5’ ‘item_5’, ‘item_6’ ‘item_6’, ‘item_7’ I tried with some coding part like this. But it unsuccessfully ! my_list = [‘item_1’, ‘item_2’, ‘item_3’, ‘item_4’, ‘item_5’, ‘item_6’, ‘item_7’] for (a, b) in zip(my_list… Read More How to compare list items
From my understanding, dropna for pandas in python drops rows with an empty entry. import pandas as pd the_data = pd.read_csv("EnzymeTrainingData.csv") the_data.dropna(inplace = True) seqs = the_data["protein_sequence"] amino_numeros = seqs.apply(len) hands = amino_numeros.apply(lambda n : float(n*(n + 1))/2) the_pH = the_data["pH"] additive = 14 x_train = [] for i in range(len(the_pH)): print(i) print(the_pH[i]) But for… Read More Why does dropna not drop na?
Consider the dataset “USArrests.csv”. This data set contains statistics, in arrests per 100,000 residents for assault, murder, and rape in each of the 50 US states in 1973. Also given is the percent of the population living in urban areas. Variables Description States:: The state where the incident occurred Murder: No. of arrests for murder… Read More Find the sum of squares for each cluster? in data using scale function and build the K-means
I just started learning matplotlib. The code I used is here below: import matplotlib.pyplot as plt x = [1,2,3] y = [2,4,6] plt.plot([x, y]) The graph doesn’t show up. It just gets stuck. Is there a way to fix it? I am a beginner matplotlibber, so I’m just following a tutorial, but this doesn’t work… Read More Matplotlib – The graph does not show in Pycharm