home
4 minutes ago

errors with data format

I am new to this forum and also new to Python. I would be very grateful if you can help me with...
I have a dataframe as follows: import pandas as pd data = { 'Num' : ['1','2',...
I have the following dataframe: d = {'Postcode': ['M3A','M4A','M5A','M6A','M9A','M1B'], 'Borough':...
Problem : I have a csv file where I need to replace bunch of pids with new pids and add a column to...
Consider the following list of tuples: some_strings = [('Name1', 'ABCD', 'DEFG', 'Score=12'), ...
>>> df = pd.DataFrame({'a': [1,1,1,2,2,3,3,3,3,4,4,5,5], 'b':...
I am experiencing strange behavior when trying to create a dataframe. I have a list of dicts I am...
I have an encrypted xls-file that I copy to be readable, convert to csv and read in pandas. After...
This is the head of my dataframe (immigration): nan 1850.0 1851.0 1852.0 1853.0 1854.0 ...
I don't understand the behaviour of Pandas in this situation. Obviously, problem is in row 3 where...
My question is just below the code snippet, below: I have raw sensor time series data that .. is...
I tried to use the math.sin() function in fillna but I failed: data['Sensor...
I'm trying to filter dataframe columns based on whether the subsc_type column value is 'Registered'...
I've a pandas dataframe and i'm trying to plot the data to make a bett wave mean ...
I have a pandas data frame that is structured something like this: ID TEXT 1 Start of document 1 ...
I'm working with some geospatial data, df_geo and am have a CSV of values I'd like to join to the...
I have a dataset of all categorical columns from where I need to find the proportions of the...
I'm working on an html email that will provide the on-call coverage for a number of different...
I have a Pandas dataframe and I do this: foo = pd.pivot_table(bw, index= ['by', 'bm', 'prop'],...
I am using the sqlalchemy module to import a .sqlite3 sheet and create an engine to form a...
This question already has an answer here: How to pivot a dataframe ...
This question already has an answer here: How to pivot a dataframe ...
This question already has an answer here: how to replace multiple...
code: import pandas as pd def dummy(): df=pd.read_csv('DF.csv',header=0) df['North']=0 ...
I am working on some data mining self-learning from a free online resource I found. Basically I got...
pandas I have two data frames and want to do a nested loop. I want to iterate of each row from...
I'm applying the bag-of-words algorithm to a bunch of documents and, after the data preprocessing I...
I have a multi-index based on dates and times (grouped by times). Data looks like this: ...
I am using this script to geocode addresses. The script works fine, however the output file...
This question already has an answer here: How can I replace all the...