https://rhodesmill.org/skyfield/positions.html#azimuth-and-altitude-from-a-geographic-position Hi I have function that generates a sun-shot azimuth on a specifi
My Data Frame My Code: a = 10001 b = "01.01.2001" if a == np.any(df["Token_ID"]) and b == np.any(df["Date_of_birth"]): print("yes") else: print("no")
I have an excel file with multiple sheets, the actual data I need from each sheet is from cell B7 to F38, how can I merge all the sheets' data into one by using
I have a yfinance download that is working fine, but I want the Date column to be in YYYY/MM/DD format when I write to disk. The Date column is the Index, so I
My data can have multiple events on a given date or NO events on a date. I take these events, get a count by date and plot them. However, when I plot them, my
I have a dataframe as below, data = [ [ 1, 'AR-123456' ], [ 1, '123456' ], [ 2, '345678' ], [ 3,'Application-12345678901'], [ 3, '1234567890
I have data that show the difference of temperatures from 1955 to 2020 from an average. I want to make a graph in matplotlib that looks like this: It shows tem
I have this simple script that creates a list by taking the values out of the column of excel_1 and compares it to the values of a column in excel_2. I want it
I was trying to divide the month into two weeks. Basically for each month i am trying to create week numbers like 1,2,3,4 and repeat them. How to create the req
I am trying to append nanoseconds to an already existing millisecond datetime pandas object. So, for instance, I already have 08:02:36.715647 which reports upti
I am using a connector to query some tables in Dynamics 365 Business Central and when I view my dataframe all of my dates are offset by -1 days. I generated a l
I am relatively new to Python and NLTK and have a hold of Flickr data stored in CSV and want to remove non-english words from the tags column. I keep getting er
I want to find all gaps in pandas DateTime index as a list of intervals. For example: '2022-05-06 00:01:00' '2022-05-06 00:02:00' <- Start of gap '2022-05
Hi everyone I'm doing a traslation of words in csv/excel files using Google Colab and Pandas here is my code: import pandas as pd from googletrans import Transl
If I have a pandas dataframe it's possible to get values from a row and use it as a label for a new column? I have something like this: | Team| DateTime| Score
I'm trying to identify individuals who have events before or after events of their first occurrence of an event of a specific type. For example, I'm interested
I have a dataset containing various fields of users, like dates, like count etc. I am trying to plot a histogram which shows like count with respect to date, ho
I'm working with a DataFrame containing data as follows, and group the data two different ways. >>> d = { "A": [100]*7 + [200]*7, "B": ["one"
I am doing the following in my python script and I want to hide the index column when I print the dataframe. So I used .to_string(index = False) and then use le
Let's say I have 4 series objects: ser1=pd.Series(data={'a':1,'b':2,'c':NaN, 'd':5, 'e':50}) ser2=pd.Series(data={'a':4,'b':NaN,'c':NaN, 'd':10, 'e':100}) ser3=