Пікірлер
@marcelol5211
@marcelol5211 Жыл бұрын
Finally!
@aussietramp
@aussietramp Жыл бұрын
What command should i use to filter from Friday at 10pm to Monday at 9am? i dont see any function for that..
@caiocezarmilhomens5718
@caiocezarmilhomens5718 Жыл бұрын
i dont know why but it doesnt work for me... only the titles on the line appears.
@32ukneil
@32ukneil Жыл бұрын
There are now better videos on you tube. The Solution is to remove the single quotes around the file name.
@albinspook6134
@albinspook6134 2 жыл бұрын
Thank you for the video. I just started using pandas and this helped a ton.
@nikhilavemuri955
@nikhilavemuri955 2 жыл бұрын
Well explained Sir
@sujitmaji757
@sujitmaji757 2 жыл бұрын
thanks....the way you teach, I love it.
@JonnyLpW
@JonnyLpW 2 жыл бұрын
thnaks. How would i filter for example if i want to know the number of speakers sold per day ?
@rezwan55
@rezwan55 2 жыл бұрын
how come if I use 22:00:00 as start time and 04:00:00 as end time it does not work?
@nikhilavemuri955
@nikhilavemuri955 2 жыл бұрын
Start time should always be less than end time I think
@SOMEONE-eq5bu
@SOMEONE-eq5bu 3 жыл бұрын
explained it very well, liked and subed, cheers
@twtw785
@twtw785 3 жыл бұрын
I am working on some intraday data trading strategies. This has helped me a lot. Thank you so much
@shrutikamble9825
@shrutikamble9825 3 жыл бұрын
Thank you so much for the video!
@32ukneil
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@nicolasleon6980
@nicolasleon6980 3 жыл бұрын
Thank you sir you helped me a lot!
@Portuenllamas
@Portuenllamas 3 жыл бұрын
Thank you very much! it has helped me a lot!
@maryguty1705
@maryguty1705 3 жыл бұрын
how to run shell script in jupyter? one that would call on python code with system arguments.
@32ukneil
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@MrNitKap
@MrNitKap 3 жыл бұрын
Very nice and simple. 👍
@payamsarwar5611
@payamsarwar5611 3 жыл бұрын
Thank you so much sir
@juliabaker7517
@juliabaker7517 3 жыл бұрын
Sorry this doesn't work at all on my jupyter
@32ukneil
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@stefheijnenconsultancy1949
@stefheijnenconsultancy1949 4 жыл бұрын
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)
@yassersayed6109
@yassersayed6109 4 жыл бұрын
thanks, but how to write back to python file ?
@datacapitalist
@datacapitalist 4 жыл бұрын
Jupyter Notebook menu > File > Download as > Python (.py)
@ericwr4965
@ericwr4965 4 жыл бұрын
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 :)
@datacapitalist
@datacapitalist 4 жыл бұрын
Thank you Eric!
@mikemishra8456
@mikemishra8456 4 жыл бұрын
Can you please say me that how can I run an .py file in Jupyter notebook
@32ukneil
@32ukneil Жыл бұрын
The Solution is to remove the single quotes around the file name.
@bhupendrapandey4980
@bhupendrapandey4980 5 жыл бұрын
Nice explanation
@datacapitalist
@datacapitalist 5 жыл бұрын
My first video! :)
@tedi4025
@tedi4025 4 жыл бұрын
@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?
@datacapitalist
@datacapitalist 4 жыл бұрын
@@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