473,440 Members | 1,782 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,440 software developers and data experts.

Question on pandas.dataframe

Hello.

I have a dataset as shown below.

session_id search_id search_time session_starting_time booking_id
session_0 search_854 2020-01-18T06:42:41.450Z 2020-01-18T06:22:33Z booking_101
session_0 search_202 2020-01-18T06:36:23.505Z 2020-01-18T06:22:33Z
session_0 search_447 2020-01-18T06:23:05.362Z 2020-01-18T06:22:33Z
session_1 search_959 2020-03-10T11:14:50.664Z 2020-03-10T11:13:58Z booking_29
session_10 search_1194 2019-07-08T21:01:47.218Z 2019-07-08T20:42:51.675Z booking_31
session_10 search_1235 2019-07-08T20:44:59.881Z 2019-07-08T20:42:51.675Z
session_10 search_1030 2019-07-08T20:47:22.750Z 2019-07-08T20:42:51.675Z
session_10 search_1207 2019-07-08T21:00:59.588Z 2019-07-08T20:42:51.675Z
session_10 search_1018 2019-07-08T20:58:43.356Z 2019-07-08T20:42:51.675Z
session_10 search_1212 2019-07-08T20:42:53.203Z 2019-07-08T20:42:51.675Z
session_10 search_1037 2019-07-08T20:43:05.777Z 2019-07-08T20:42:51.675Z
session_10 search_1231 2019-07-08T20:44:15.376Z 2019-07-08T20:42:51.675Z
session_100 search_214 2021-01-03T15:38:04Z 2021-01-03T15:18:13.336Z booking_96
session_101 search_36 2018-10-18T16:07:39.652Z 2018-10-18T16:06:52.540Z booking_264
session_101 search_109 2018-10-18T16:12:58.513Z 2018-10-18T16:06:52.540Z
session_102 search_75 2018-10-20T16:34:22.763Z 2018-10-20T16:34:07.883Z booking_317
session_102 search_75 2018-10-20T16:34:22.763Z 2018-10-20T16:34:07.883Z booking_317

My question is using pandas dataset How many sessions have more than one booking?
Jun 28 '23 #1
0 703

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Stevey | last post by:
I have the following XML file... <?xml version="1.0"?> <animals> <animal> <name>Tiger</name> <questions> <question index="0">true</question> <question index="1">true</question> </questions>
6
semanticnotion
by: semanticnotion | last post by:
Hi sir i want to transform the data of one table into another through foreign key but the following error come to my browser Here is my code and data base structure. CREATE TABLE IF NOT...
1
by: hofeher | last post by:
Trying to write dataframe into existing excel file to a specific column without deleting existing data. Code sample: import pandas from openpyxl import load_workbook writer =...
1
by: aamer111 | last post by:
i have a column that has 53000 rows that has list of nested dictionaries. i need to append or add one more key:value pair to each of the rows that has dicitionaries inside the list.
0
by: alan28a | last post by:
I am just trying to get an SQL Server table into a Pandas DataFrame and copied this code from the internet, obviously added my local details and credentials ie XXXX etc. Which I think works OK. When...
2
by: ck25python | last post by:
Hi There, I am very new to python environment. I am trying to replicate one of the SAS code in python. I want to create 3 columns based on multiple conditions: Below are the requirements: ...
2
by: RockRoll | last post by:
Hi, I have a large (Nx4, >10GB) array that I need to sort based on col.2. I am reading my data in chunks and sorting using Pandas. But I am unable to combine the sorted chunks to give me a...
0
by: Learner99 | last post by:
{'data': {'close': 469.25, 'high': 484.4, 'low': 468.1, 'open': 470.0,}}
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.