i have a first dataframe : id ; name ; job AAA1; reacher; doctor ZZZ2; pete; nurse SSS3; wilson; prof and second dataframe : pk ; name ; job AAA1; reacher; Doctor MOIU8; pete; Nurse HYA1; wilson; Prof we suppose that code = pk = id i want to identify code which exist in dataframe1 ..
Category : pandas
I have the following code: import streamlit as st import pandas as pd #define data d = {‘id’: [‘a’, ‘b’, ‘c’], ‘data’: [3, 4,6]} df = pd.DataFrame(data=d) #create sidebar input with st.sidebar.form("my_form"): a = st.slider(‘sidebar for testing’, 5, 10, 9) calculate = st.form_submit_button(‘Calculate’) if calculate: df[‘result’] = df[‘data’] + a st.write(df) #no issues up to ..
This code is working properly, and I am able to print the users I Scrapped. However, my goal here is to split the list with all the names and put just the first one in the users_involved(which later will be a column) and the second in the users_involved2(also a column). So the final result would ..
I’m still getting to grips with working in pandas. What I’d like to do is convert a column’s type (from string to integer). The column is encoded as string data but includes mostly integer values. I’d like the whole column to be of type integer. On the few occasions where conversion is not possible, I’d ..
I am trying to create a function to create multiple dataframes (which later to be converted into numpy array for image creation). I have 2 dataframes, the first one I call it as allnorm, allnorm as the first df and the second one as intervals. intervals as the second df I used the min_depth and ..
I am trying to remove the "edge color" from a stacked area chart in python, as the plots tend to get "overlaid" by the "last" column: import pandas as pd, numpy as np df = pd.DataFrame(np.random.randint(0, 10000, size=(10000, 4)), columns=list(‘ABCD’)) import matplotlib.pyplot as plt, seaborn as sns def myplot(df): fig, ax = plt.subplots(figsize=(4, 4)) df.plot.area(ax=ax) ..
I am new to Python and I am tasked with comparing a PDF to a CSV file. I have an excel file that goes through Power Bi which creates a data-visual. From there I export a PDF from that visual. I then need to compare that exported PDF to the original excel file to make ..
i want the sum of all subcounts printed in a pivot table. table = pd.pivot_table(df, index = [‘value1’, ‘value2’], values = [‘value3’], aggfunc = [np.count_nonzero]) Output of print(table.loc[value1example]): count_nonzero value3 value2 value2examplea 766 value2exampleb 265 value2examplec 19 I want the following: count_nonzero value3 value2 950 value2examplea 766 value2exampleb 265 value2examplec 19 Do you have an ..
I have two csv files with data, I am querying 6 part numbers from file1 against file2 to retrieve stock figures. End goal being to create a new csv. I am trying to do this using Python and pandas but struggling with how tor eference certain values. Everything i can find in the pandas document ..
I have a pandas dataframe, with 10 columns and thousands of rows. The first column is the name of website users, for example: Name … 0 Alex 1 Fred 2 John 3 Chloe … I want to change this first column into this: Name … 0 Hi! Alex, mind calling me at 8 p.m.? 1 ..
Recent Comments