Questions tagged as 'pandas'

Tagged questions
0
answers

Change the limit of x on a seaborn graph

I'm having problems changing the x limit of a large dispersion chart. g = sns.distplot(df['growth_rate']) I would like to see the distribution of the following graph, in the range of x = (-10 to 10) Thank you very much     
asked by 22.03.2018 / 19:01
0
answers

conditional according to previous panda column

I have a Panda DataFrame, and I want that according to the value of the previous column to execute a condition. that is, if the value of column A is equal to 1, execute enter conditional i if it is 0 not enter the conditional. A B C 1 1...
asked by 13.03.2018 / 23:58
0
answers

How to change in Python Pandas the type of numerical data in one or more columns?

Using Python 3.4 and pandas = 0.19.2, perform a script in which you change the data type to a data column in the dataFrame. Using this version of pandas had a line of code with pd.lib.infer_dtype In my previous question I was recommended to...
asked by 19.01.2018 / 01:21
0
answers

ModuleNotFoundError: No module named 'pandas_datareader'

In Windows10, I have Anaconda3 5.0.1 installed. This package does not seem to include pandas-datareader . I have verified, running the same script in Linux with the same version of Anaconda3 and installing this package, that the script works co...
asked by 07.01.2018 / 18:29
0
answers

Convert a list of two columns into a DataFrame

I have a list with two columns, with this structure: ....'2011-10-18', '99,610000', '', '2011-10-17', '99,680000', '', '2011-10-14', '99,870000', '', '2011-10-13', '100,000000', ''] To try to convert it into a DataFrame I execute this code...
asked by 07.11.2017 / 20:59
1
answer

Error when plotting date values with matplotlib [closed]

I'm testing with Pandas and matplotlib. The first column of the Excel are dates, format (dd / mm / yy). Reading the Excel sheet with Pandas presents me: 0 Fecha Valor 1 2017-09-11 00:00:00 44.42 2 2017-09-08 00:00:00...
asked by 17.09.2017 / 19:37
0
answers

Django queryset without models

I need to make queries to the database ( postgresql ) but the tables I want to consult were created by pandas so I do not have a model to refer to, how do I do queries without models?     
asked by 14.09.2017 / 20:22
1
answer

PANDAS: Can I fill NAN values in just one column of my dataframe?

I have a dataframe of 3 columns all numeric. Within the data there are missing values NAN and I have no problems in filling them with fillna(method=pad) all except NAN of the first column that require fillna(mean()...
asked by 04.08.2017 / 21:47
2
answers

Error loading CSV file Pandas Python 3

To load a file using Pandas column 14 when adding it generates me an error, I believe because it has very long elements. The charge of the following way: df4 = pd.read_csv('MAPI.csv', header=0, sep=';',usecols=[1,3,9,14,19],parse_dates...
asked by 27.07.2017 / 17:06
1
answer

How to group grouped values by different date by a single value per hour

Good, I need to show the number of calls that are made every hour in a whole month. So far I was able to do a resample of the CSV so that I stayed as follows: Cantidad Fecha 2017-03-01 00:00:00 5 2017-03-01 01:00:0...
asked by 05.05.2017 / 01:25