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
41 views
0
How to Use the Binding Variable in pandas.io.sql.read_sql

I would like to use date as a variable in pandas.io.sql.read_sql('SELECT* FROM database as a where a.date=date). Is there a way?

2 years ago

1 answers
44 views
0
I want to delete non-numeric (character, blank line, etc.) lines from the Excel file.

I would like to delete non-numeric (letter, blank line, etc.) lines in the Excel file in Python.What should I do?I managed to delete the blank line with the code below, but It's hard to find a way to ...

2 years ago

2 answers
39 views
0
I want to remove rows from csv according to the conditions in pandas

I would like to read csv in Python's pandas, delete the line according to the conditions, and print it to a new file.If the csv file (list1.csv) is as follows, focus on time2 and delete three of the o...

2 years ago

1 answers
36 views
0
I want to add new columns using different rows of data in Pandas.

For DataFrame that you have already created, you would like to include the appropriate values under certain conditions in the new column that you are adding.This time, I brought the data of the game t...

2 years ago

4 answers
49 views
0
I want to extract the IDs that overlap for a period of time between the two Dataframes.

I use python3 and pandas.I'd like to compare the dates of people with the same ID among the two Dataframes, df1, df2, and take out the IDs of the rows with overlapping periods.There are actually about...

2 years ago

1 answers
82 views
0
ValueError on Python: I don't know what to do with Length mismatch.

The code below suddenly displays ValueError: Length mismatch, and I don't know how to deal with it.I thought it was because I got the same securities code over and over again, but it was working fine ...


2 answers
40 views
0
About CSV File Data Type Conversion: dtype does not change even if you type astype

I am trying to change the column TOPIxd data to String type with the code below.If you check the data type in data.dtypes, it will remain the object type as it was originally.I wonder why...import pan...

2 years ago

3 answers
56 views
0
If there is data in a list in one column, is there a way to divide each element in the list, increase the column, and make each element a dummy variable?

I'm a beginner at data analysis.I'm trying something like a simple competition for the first time.I didn't know what to start with, so I groped one by one, but I didn't know how to find the answer to ...

2 years ago

2 answers
35 views
0
Understanding Bandas Series Line-Direction Coupling

I would like to use the code below to combine date,p into the header, but it doesn't work.How can I do it?Also, the tick contains the date information, and we make the year and year information with s...

2 years ago

1 answers
36 views
0
Data cleaning using Pandas is not going well.

After loading the csv, I want to use pandas to delete the comma (,) in the specified column, but it doesn't work.Executed the following code:import pandas as pdimport numpy as npimport matplotlib.pypl...

2 years ago
« - 17 - »

© 2024 OneMinuteCode. All rights reserved.