Flexible and powerful data analysis / manipulation library for Python, providing labeled data structures similar to R data.frame objects, statistical functions, and much more
I have a latest version Pandas: 0.25.0 and I have a problem with pandas.DataFrame.loc - I don't know why however i don't have that
For example :)
I will try
Florian Hi there, can anyone help me with a seamingly simple task?
I have the following DataFrame:
Participant Time Value
0 1 1 1
1 1 2 2
2 1 3 3
3 2 1 2
4 2 2 5
5 2 3 7And now I want to subtract the Value at Time==1 from the Value at Time==2 and Time==3, such that the DataFrame becomes:
Participant Time Value
0 1 1 0
1 1 2 1
2 1 3 2
3 2 1 0
4 2 2 3
5 2 3 5I just cannot figure out how to do this :-)
kir0ul > <@fladd:matrix.org> Hi there, can anyone help me with a seamingly simple task?
I have the following DataFrame:
Participant Time Value 0 1 1 1 1 1 2 2 2 1 3 3 3 2 1 2 4 2 2 5 5 2 3 7And now I want to subtract the Value at Time==1 from the Value at Time==2 and Time==3, such that the DataFrame becomes:
Participant Time Value 0 1 1 0 1 1 2 1 2 1 3 2 3 2 1 0 4 2 2 3 5 2 3 5I just cannot figure out how to do this :-)
Maybe this can help?
https://stackoverflow.com/questions/34855859/is-there-a-way-in-pandas-to-use-previous-row-value-in-dataframe-apply-when-previ
Florian kir0ul: Thanks for the pointer. However, this does not seem to work. I do:
for i in range(1, len(data)):
time = data.loc[i, "Time"]
if time != 1:
data.loc[i, "Time"] = data.loc[i, "Time"] - data.loc[i-time-1, "Time"]But I get the error:
KeyError: 'the label [-2] is not in the [index]'Florian ha, paranthesis error :-)
Florian but it still does not work. I creates the original data frame, instead of the subtracted one
@WillAyd regarding the stale bot, this should be quite simple to implement with GitHub actions directly in the CI (see https://github.com/actions/stale). This is still beta, but when it's released, I see an advantage having it set up in a yaml in the repository, compared to having to integrate another third-party service.
I'm neutral on whether this is a good idea or not, I'd say that if there is interest, we can give it a try, and if it becomes annoying we remove it
or go ahead if i guys are already on the call
@jreback we had the call. Notes at https://docs.google.com/document/d/1k_E_1oSV9VNHgGzepdeCyFdju8ZaXDwI3CvDYkhOtQ8/edit?usp=sharing. Summary at the bottom is where I’d recommend focusing.
Where in what you showed me did you see the info around a stable release?
GitHub actions itself is in beta, not sure when it'll be stable: https://github.com/features/actions
I am having trouble with scatter plot. I have posted my problem in Stack Overflow-
https://stackoverflow.com/q/57988832/3862410
I need some hints on my mistake
https://stackoverflow.com/q/57988832/3862410
I need some hints on my mistake
I am not sure, if this is my mistake or some kind of bug
i want to store a class or @dataclass as the values for one of my dataframe columns
i was just wondering if you can access member functions or attributes particularly like when you do the df filtering
like df[df['MYCLASSCOL'].attribute == 'helloworld']]
or df[df['MYCLASSCOL'].someBoolMethod(1,2,3)]
When parsing a dictionary containing a list of datetime objects, pandas converts it to numpy.datetime64. Is this normal? Reproducable example:
>>> from pandas import DataFrame as df
>>> import datetime
>>> inp = {'date':[datetime.datetime.now() for val in range(3)]}
>>> inp_tbl = df(inp)
>>> inp_tbl
date
0 2019-09-20 15:00:35.080488
1 2019-09-20 15:00:35.080525
2 2019-09-20 15:00:35.080527
>>> inp_tbl.dtypes
date datetime64[ns]
dtype: object
>>> inp_tbl['date'].values[0]
numpy.datetime64('2019-09-20T15:00:35.080488000')
Please, who can follow me in GitHub? I write one project in Python one new framework, and this project and my profile need plus one follow, for I can participate one conpetition, who could help , I thanks : https://github.com/FelipeKatao
Hey guys, I'm interested in contributing to pandas. I have a lot of experience in python. I've used pandas on a few projects, and I'd be interested to spend some of my free time helping it grow whether that's committing to first-timer issues or developing new features. If someone who is an active contributor would like to help me get started, or even provide some mentorship I would appreciated the opportunity.
@Ianphorsman I'd suggest having a look at this issue: pandas-dev/pandas#27977, and fixing few of the problems mentioned there, to get familiarity with the project in a simple way
feel free to DM after that, and I'll try to give you advice on what else you could work on, based on your interests
Specifically looking at the
.dt accessor I thought it might be driven by some of the delegate decorators and class variables like _datetimelike_methods
But I see stuff exposed to the accessor that don’t appear in those variables (ex:
to_pydatetime for a DTA)