I want to create a dummy variable for a specific value in a column. Let's say my database looks like this : I want a dummy variable just for the museums. pd.ge
Let us assume that a DataFrame df has the following columns: ['c1', 'c2', 'c3', 'c4', 'c5', 'c6', 'c7'] We can use a slice or a list to select some columns: Wit
Be the following DataFrames in python pandas: | date | counter | |-----------------------------|------------------| | 2022-01-0
I have a dataframe that looks like this: df = pd.DataFrame({'col1': [[[1,5,3],[0,0,0]], [[1,2,3],[0,0,0], [1,2,3]]]}) # which looks like this: col1 0 [[1
I have a data frame with 100's of column and would like to investigate the proportion of missing values by plotting graph. I'm able to get the proportion using
I'm trying to remove 1 column from .csv but I'm receiving an error. import pandas as pd df.drop("First Invoice #", axis = 1, inplace= True) KeyError: "['First
I have set of columns need to be merged into single column where some columns have data and some don't have where it should be joined with the data to single co
I have a tuple that has data for several categories. Now I want to extract small dataframes from this tuple for each category based on a list I created. I want
I have 4 variables of which 2 variables are nominal (dtype=object) and 2 are numeric(dtypes=int and float). df.head(1) OUT: OS_type|Week_day|clicks|avg_app_s
I have pandas DataFrame df and three arrays columns_list, lower_boarder and upper_boarder all have the same shape. I want to find array with shape as input arra
I'm trying to make a simple FastAPI api. Let's suppose these routes: The POST Route @api.post('/user', name='Get list of users') def get_user(user: User):
Please see my code below: import pandas df = pandas.read_excel('cat.xlsx') After running that, it gives me the following error: Traceback (most recent call las
I have a data frame that looks like this: Tag 0 skip_1 1 run 2 skip_1 3 run 4 skip_1 5
What this kind of error? Traceback error C:\Users\DELL\PycharmProjects\MyNew\venv\Scripts\python.exe C:/Users/DELL/PycharmProjects/MyNew/agaaaaain.py Traceba
I'm having trouble resolving an encoding error when reading a csv file using the pandas library. import pandas as pd filepath = "D:\Datasets\2019HighwayBridgeIn
I have a well-known Titanic dataset and I am trying to find the survival probability of a person, based on their age and sex. The input I am given is the number
If I have a NumPy array of float64 values. I know these values represent dates in format of datetime64[ns]. I try to convert them with pandas. But I get an Valu
I have the table in file and it looks like that: +-------------+-----------------+---------------+---------------+--------------+ |number |name
I've been looking for other similar issues on this ValueError, but none of them has the same code as I have. So here it is. As I am still very new at this, I am
In a pandas dataframe, I have a column of mixed data types, such as text, integers and datetimes. I need to find columns where datetimes match: (1) exact values