pandas tag

pandas is a software library written for the Python programming language for data manipulation and analysis. In particular, it offers data structures and operations for manipulating numerical tables and time series. It is free software released under the three-clause BSD license. The name is derived from the term "panel data", an econometrics term for data sets that include observations over multiple time periods for the same individuals. Its name is a play on the phrase "Python data analysis" itself. Wes McKinney started building what would become pandas at AQR Capital while he was a researcher there from 2007 to 2010.

Reference: WIKIPEDIA

271 questions


1 answers
40 views
0
Pandas series mean value becomes nan value

We are complementing the missing value of application_{train|test}.csv in the kaggle Home Credit Default Risk.I would like to fill the following two characteristics with the average value, but mean() ...

2 years ago

1 answers
41 views
0
Use Python to transfer the contents of the list to Excel

filename = File name.xlsxbook = openpyxl.load_workbook(filename)# sheet extractionsheet = book.worksheets[0]# Enter datadata = []data_value = datafor row in sheet.rows: data.append([ row[0].value, r...

2 years ago

2 answers
43 views
0
How can I insert the contents of Excel 2 into Excel 1 in Python?

For example, df1 and You have df2.How should I access the code to insert the contents of df2 into the blank of df1?I've used the merge or concat function, but I can't write it neatly, and it doesn't c...

2 years ago

1 answers
159 views
0
I'd like to know how to change the column name in Pandas.

I'm working on a diagram in the Pandas module, and the column name comes with $ in front of it.['$a', '$b', '$c', '$d', '$e', ...] -> ['a', 'b', 'c', 'd', 'e', ..].I want to remove all the $ before...

2 years ago

1 answers
43 views
0
I have a question about Python pivot_table

After reading Excel data for Dep, Name, Sales, and X Sales values as shown below,Add the ratio of X Sales by Sales (X Sales/Sales*100) as 'rate' coulmn, When pivot_table was applied based on Dep in th...

2 years ago

1 answers
80 views
0
I want to paste the list value into a specific part of the multi index dataframe. (Python)

I want to paste the list value into a specific part of the multi index dataframe.The code below is the data frame that I am currently practicing. I want to put list1 and list2 in the specific column a...

2 years ago

1 answers
42 views
0
Error in sum with individual data collected by Python Pandas???

We put the combined values from column 1 to column 200 of the data collected by Pandas into column 201 and created a code to save them as a csv file.(How to add column 1 values to column 201 and accum...

2 years ago

2 answers
73 views
0
Questions about Python Pandas dataframe

colum 1, colum2a,b,c 30b,c,f 40a,g,z 50...In this data frame, I would like to construct column4 by adding the value of column2 corresponding to a.column3, column4a 80b 70c 70f 40g 50z 50I wou...


1 answers
40 views
0
Python pd.read_csv Execution Error

import pandas as pdfec = pd.read_csv('‪‪‪D:/Moon Hyun Jae/P00000001-ALL.csv')This error appears when you do so.FileNotFoundError: File b'\xe2\x80\xaa\xe2\x80\xaa\xe2\x80\xaaD:/Moon Hyun Jae/P00000001-...

2 years ago

1 answers
112 views
0
I have a question about data range using Python Pandas module.

In the Seoul Metropolitan Government's public data, we wanted to analyze how the number of students per teacher changes in time series by district.http://data.seoul.go.kr/openinf/linkview.jsp?infId=OA...

2 years ago
« - 18 - »

© 2024 OneMinuteCode. All rights reserved.