Questions tagged as 'pandas'

Tagged questions
1
answer

Pandas: How to make a Serial fragment in the field (Column) of the DataFrame

I have this excel below: NÚMERO "URL NÚMERO 16571 SICAN" "URL DECRETOS 2011 PRINCIPAL" 1 CCIVIL_03/Atos/decretos/1991/D00001.html CCIVIL_03/decreto/1990-1994/D0001.htm 4 CCIVIL_03/Atos/decretos/1889/D00004.html CCIVIL_03/dec...
asked by 10.06.2018 / 21:09
1
answer

Joining twodata frames by the axes

I am a beginner in the study of programming and I have a question: I need to merge two dataframes into the date column. A data frame shows information about a company that rents bikes and other weather information for the day. The company...
asked by 24.04.2018 / 02:05
1
answer

In pandas and unidecode, how to avoid warning messages - copy of a slice from a DataFrame?

In Python3 and pandas I'm reading CSV files to create dataframes. In some columns I need to remove the accent (Portuguese). I do this with unidecode But in some files a warning message appears import pandas as pd import unidecode def f(str...
asked by 02.03.2018 / 15:03
1
answer

DataFrame date column

I have this DataFrame and would like to separate the column from the date how do I do this? Data e Hora Consumo(litros) Valor Acumulado 0 2017-08-21 20:00:00 65 65 1 2017-08-21 21:00:00...
asked by 24.06.2018 / 02:21
1
answer

How to make a frequency distribution table in Python? [closed]

Good afternoon, One question: Could anyone clarify me how I can make a frequency distribution table: classes; absolute and relative frequency; cumulatively; average values of each class.     
asked by 19.01.2018 / 20:31
1
answer

How to select codes with different sizes in pandas?

In Python 3, with pandas, I have this dataframe with several codes in the columns "CPF_CNPJ_doador" and "CPF_CNPJ_doador_originario" cand_doacoes = pd.read_csv("doacoes_csv.csv",sep=';',encoding = 'latin_1', decimal = ",") cand_doacoes.info(...
asked by 21.11.2017 / 13:09
1
answer

How to sum a column of a file and view it with .plot (kind = 'bar')?

I'm trying to sum the duration column, and display using plot() trip_data['duration'].value_counts().plot(kind = 'bar') trip_data['duration'].count_data().plot(kind = 'bar') trip_data['duration'].size().plot(kind = 'bar') But everyth...
asked by 15.09.2017 / 03:58
1
answer

How to remove special character and column point string from a data frame?

raw_data = {'NAME': ['José L. da Silva', 'Ricardo Proença', 'Antônio de Morais']} df = pd.DataFrame(raw_data, columns = ['NAME']) How to make NAME column names into: Jose L da Silva (no point...
asked by 04.07.2017 / 15:32
1
answer

keep only the rows of a column with the value with Pandas

Hello, I am a beginner in the field and one of the exercises I am having difficulty responding to is the following. there is a multi-column file. In one of these columns, there are several zipcode (zipcode), and may or may not repeat. For eac...
asked by 18.07.2017 / 21:20
1
answer

Division between row and column values using pandas

I created a pivot table containing some values, but I do not know if it is necessary to use pivot table in this case below a sample of the results: Valor ajuste \ Data posicao 2017-05-3...
asked by 29.06.2017 / 22:58