Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

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
    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
    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
    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
    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
    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.0k views
1 answer
    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.2k views
1 answer
    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
    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
    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
    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.1k views
1 answer
    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
    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
    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
    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.7k views
1 answer
    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
    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
1.9k views
1 answer
    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
    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
    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
    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
    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
    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
    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.2k views
1 answer
    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.8k views
1 answer
    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
    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
    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)
Ask a question:
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...