dataframe tag

Pandas is mainly used for data analysis and associated manipulation of tabular data in Dataframes. Pandas allows importing data from various file formats such as comma-separated values, JSON, Parquet, SQL database tables or queries, and Microsoft Excel. Pandas allows various data manipulation operations such as merging, reshaping, selecting, as well as data cleaning, and data wrangling features. The development of pandas introduced into Python many comparable features of working with DataFrames that were established in the R programming language. The pandas library is built upon another library NumPy, which is oriented to efficiently working with arrays instead of the features of working on DataFrames.

Reference: WIKIPEDIA

63 questions


1 answers
57 views
0
I want to extract only certain rows from the data frame

In the data frame, 1, 2, and 3 overlap in the id column, and I want to pull out only the top row.I want to make it so that the results come out The result will also come out as a data frame,,

2 years ago

1 answers
78 views
0
I'm asking you a string separation question in Python dataframe.

I want to know how to separate strings from Python data frames.You can use the split method in the list, but I don't know in the dataframe.Specifically, I would like to leave only a part of the string...


1 answers
77 views
0
[pandas] When the indexing is not good?

I have data. It's in the form of a pandas data frame.I'm going to bring it in and do something, but it's not indexing well.I can't get all the original data.For example, df = np.random.randint(1, 15, ...

2 years ago

1 answers
58 views
0
I want to know how to index the date with a specific value of Python data frame.

Hello, I'm a beginner at ^.How do I reversely index an index or a date index with a specific value in a Python data frame?^df1 = pdDataFrame({'A': [1,4,7]}, index=[2019-04-07,2019-04-08,2019-04-09]...

2 years ago

1 answers
127 views
0
It's a question to load Python data

I loaded raw data and did pd.read_csv() through Pandas.However, the data that was retrieved (500rows x 1 columns) was recognized like this. So I have two questions.First of all, how many times can we ...

2 years ago

1 answers
56 views
0
Python List -> How to Create Data Frames

en = ['a', 'b', 'c']ko = [Ga, Na, Da]df = pd.DataFrame (data = [[ko, en]], columns = ['Hangul', 'English'])dfI want to put a list in one column, but [] brackets go in together. Is there a way to get r...

2 years ago

2 answers
59 views
0
Python specific sheet price data resample

import panda as pdimport numpy as npimport datetimeimport sysfrom openpyxl import load_workbook sys.path.append(C:\\pytest)df= pd.read_excel('C:\\pytest\\dailyprice.xlsx', sheet_name='dprice')No_List ...

2 years ago

1 answers
123 views
0
Dataframe Two csv column dict conversion questions.

I wrote the title like that, but I didn't know how to express it, so I wrote it over and over.There are two csv files.For example, the subject code with code and test subjects (Korean, English, math) ...

2 years ago

1 answers
62 views
0
When you save JSON files in a data frame format in Python, you want to create them sorted by the values in a specific column

Hi, how are you?I downloaded the company's financial statements in Json format using the Open API of the electronic disclosure system DART.You can find more information about this API in the link belo...

2 years ago

1 answers
91 views
0
How can I output multiple lines of json in Python in the form of a data frame?

Types stored in json files # test.json{key_a1:value_a1, key_a2:value_a2, key_a2:value_a3}\n{key_a1:value_b1, key_a2:value_b2, key_a2:value_b3}\n{key_a1:value_c1, key_a2:value_c2, key_a2:value_c3}\n{ke...

« - 3 - »

© 2024 OneMinuteCode. All rights reserved.