What command should i use to filter from Friday at 10pm to Monday at 9am? i dont see any function for that..
@caiocezarmilhomens5718 Жыл бұрын
i dont know why but it doesnt work for me... only the titles on the line appears.
@32ukneil Жыл бұрын
There are now better videos on you tube. The Solution is to remove the single quotes around the file name.
@albinspook61342 жыл бұрын
Thank you for the video. I just started using pandas and this helped a ton.
@nikhilavemuri9552 жыл бұрын
Well explained Sir
@sujitmaji7572 жыл бұрын
thanks....the way you teach, I love it.
@JonnyLpW2 жыл бұрын
thnaks. How would i filter for example if i want to know the number of speakers sold per day ?
@rezwan552 жыл бұрын
how come if I use 22:00:00 as start time and 04:00:00 as end time it does not work?
@nikhilavemuri9552 жыл бұрын
Start time should always be less than end time I think
@SOMEONE-eq5bu3 жыл бұрын
explained it very well, liked and subed, cheers
@twtw7853 жыл бұрын
I am working on some intraday data trading strategies. This has helped me a lot. Thank you so much
@shrutikamble98253 жыл бұрын
Thank you so much for the video!
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@nicolasleon69803 жыл бұрын
Thank you sir you helped me a lot!
@Portuenllamas3 жыл бұрын
Thank you very much! it has helped me a lot!
@maryguty17053 жыл бұрын
how to run shell script in jupyter? one that would call on python code with system arguments.
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@MrNitKap3 жыл бұрын
Very nice and simple. 👍
@payamsarwar56113 жыл бұрын
Thank you so much sir
@juliabaker75173 жыл бұрын
Sorry this doesn't work at all on my jupyter
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@stefheijnenconsultancy19494 жыл бұрын
I've a question If i want to use it in this code it's not working what I'm doing wrong? DataFile = 'ACPUTAWAY.XLSX' df_Data = pd.read_excel(DataFile) DF_Dates = df_Data[['Date Finished']] DF_Single_Dates = DF_Dates.drop_duplicates(keep='first') for ind in DF_Single_Dates.index : DF_Putaway_followed = df_Data[df_Data['Date Finished'].dt.date == DF_Single_Dates['Date Finished'][ind].dt.date] print(DF_Putaway_followed)
@yassersayed61094 жыл бұрын
thanks, but how to write back to python file ?
@datacapitalist4 жыл бұрын
Jupyter Notebook menu > File > Download as > Python (.py)
@ericwr49654 жыл бұрын
I would like just to say thank you sir, this was terribly easy the way you explained it. I hope you get some more subscribers in the future but I am number 11 today :)
@datacapitalist4 жыл бұрын
Thank you Eric!
@mikemishra84564 жыл бұрын
Can you please say me that how can I run an .py file in Jupyter notebook
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@bhupendrapandey49805 жыл бұрын
Nice explanation
@datacapitalist5 жыл бұрын
My first video! :)
@tedi40254 жыл бұрын
@Ravi , I think my datetimes are not in the right dtype format, it shows up as a Pandas object and the error comes up as: TypeError: '>=' not supported between instances of 'str' and 'Timestamp'. How would I fix this to prevent Pandas from reading the datetime objects as a string?
@datacapitalist4 жыл бұрын
@@tedi4025 It appears that your pandas dataframe does not recognize that particular column to be of dtype datetime. You will need to convert the columns dtype explicity first using the pd.to_datetime() method. Details here: pandas.pydata.org/pandas-docs/stable/reference/api/pandas.to_datetime.html