Recent questions tagged Pandas

0 votes

2.1k views

1 answer

I have a field for call length in my raw data which is listed as an object, such as: 00:10:30 meaning 10 ... with. (Timestamp * 24 * 60) See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

3.9k views

1 answer

pandas - Python: Unstacked DataFrame is too big, causing int32 overflow

I have a big dataset and when I try to run this code I get a memory error. user_by_movie = user_items.groupby([' ... ! how can I fix this error? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.4k views

1 answer

pandas - How to convert data from txt files to Excel files using python

I have a text file that contains data like this. It is is just a small example, but the real one is ... Excel Table" like this using Python? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - Filtering DataFrame by list of substrings

Building off this answer, is there a way to filter a Pandas dataframe by a list of substrings? Say I want to ... '].str.contains('spaghetti')] See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - How to read an excel file directly from a Server with Python

Scenario: I am trying to read a excel file from a server folder and after that read each worksheet of that ... the proper way to achieve this? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.0k views

1 answer

pandas - Arrange two plots horizontally

As an exercise, I'm reproducing a plot from The Economist with matplotlib So far, I can generate a random data and ... df2['usage']) plt.show() See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - Anonymizing data / replacing names

Normally I anonymize my data by using hashlib and using the .apply(hash) function. Now im trying a new approach, ... the number after 'person'. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.3k views

1 answer

pandas - How to build a Python function with a rolling total?

I am looking to build a function that creates a rolling total by code by day for the below DataFrames, where the In for ... 16/01/2019 A 7 """ See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.0k views

1 answer

pandas - Multicolor scatter plot legend in Python

I have some basic car engine size, horsepower and body type data (sample shown below) body-style engine-size ... engine-size") ax.legend() See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

pandas - How to find the start time and end time of an event in python?

I have a data frame consists of column 1 i.e event and column 2 is Datetime: Sample data Event Time 0 2020- ... or any other value or vice versa See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k views

1 answer

pandas - Find symmetrical entries dataframe, if not delete entry

I have the following data. ID1 ID2 Value 1 2 5.5 2 1 10 1 3 5 Expected output: ID1 ID2 Value 1 2 5.5 ... datarow. How can I do this with pandas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k views

1 answer

pandas - how to format specific cells in excel using xlsx package in python

I have a pandas df which I am formatting using xlsx package currently I have the option to format an entire row ... , tot_fmt) writer.save() See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.5k views

1 answer

pandas - How to concatenate all CSVs in a directory, adding CSV name as a column with Python

I have a folder with about 100 CSVs (Downloads/challenges). Each CSV has the same 50+ columns. Each CSV is ... . Any help would be appreciated! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.6k views

1 answer

pandas - Rolling percentage change in Python data frame

I have a dataframe like this (many rows): Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec a 34 24 47 30 ... I can do this in python? Thank you See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - How to check whether the content of Column A is contained in Column B using Python DataFrame?

I have two columns in a pandas DataFrame: authors and name. I want to create a third column: a cell's ... create the third column in Python? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

4.8k views

1 answer

pandas - Solving error "delimiter must be a 1-character string" while writing a dataframe to a csv file

Using this question: Pandas writing dataframe to CSV file as a model, I wrote the following code to make a csv ... , but got the same error. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.6k views

1 answer

pandas - Matplotlib:: Not Showing all x-axis data frame variable

I have a data frame with head as: m_srcaddr total_fwd_size total_rev_size 0 10.19.139.141 2479.335 175.000 ... failing as m_srcaddr not integer. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.0k views

1 answer

pandas - How to convert numbers represented as characters for short into numeric in Python

I have a column in my data frame which has values like '3.456B' which actually stands for 3.456 Billion (and ... there a better way to do it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - python - cannot make corr work

I'm struggling with getting a simple correlation done. I've tried all that was suggested under similar ... CCMP Index_close_px, dtype: object See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.7k views

1 answer

pandas - Knn give more weight to specific feature in distance

I'm using the Kobe Bryant Dataset. I wish to predict the shot_made_flag with KnnRegressor. I've used game_date to ... cv for finding optimal k. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.2k views

1 answer

pandas - Python - Get date from day of week, year, and week number

I have: a week number a day of week a year I want to find the date from that. How to do it in ... 2020 week1 Saturday Expected output 01/04/2020 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - If condition for comparison between two dataframes in Python

Am new to python programming. Can anyone pls check the below syntax for if condition- if df1[A]<= df2[B]): print("") ... ), a.any() or a.all(). See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.1k views

1 answer

pandas - Issue checking for missing datetime value in series

I'm trying to create a derived column based on two conditions being met for values in existing columns. One ... , this logic is correct. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

pandas - Slow loop python to search data in antoher data frame in python

I have two data frames : one with all my data (called 'data') and one with latitudes and longitudes of ... data would look like this : See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

2.3k views

1 answer

pandas - Python add a leading zero to column with str and int

Hello I want to add a leading zero in my current column with str and int but I do not know how. I only want to ... 01 02 03 04 4SS 15 S1 A111 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

3.9k views

1 answer

pandas - Getting AttributeError 'Workbook' object has no attribute 'add_worksheet' - while writing data frame to excel sheet

I have the following code, and I am trying to write a data frame into an "existing" worksheet of an Excel ... 't comment on that post either. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

+1 vote

4.5k views

1 answer

pandas - Python equivalent of Excel's PERCENTILE.EXC

I am using Pandas to compute some financial risk analytics, including Value at Risk. In short, to compute Value at ... is -77.4 Thanks, Ryan See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.9k views

1 answer

pandas - Removing *NEARLY* Duplicate Observations - Python

I am attempting to remove some observations in a pandas DataFrame where the similarities are ALMOST 100% but not quite ... Any idea on a remedy? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags