Python- Pandas- Data Science question: If I want to merge these two tables on the column [order number] for machine learning project, what is the best way to do this with one row for every order number and minimum n/a values. FYI :The end goal is to create a logistic regression. (please include python code). NOTE: Order 1 has 3 items attached to it, Order 2 has 2 items, and Order 3 has 3 items

Order number	Date
1	8/1/2018
2	8/1/2018
3	8/5/2018

order number	product	bids
1	peanut butter	$3
3	usb drive	$10
3	computer	$50
1	jellly	$4
2	sugar	$2
3	mouse	$20
3	keyboard	$15
2	koolaid	$1
1	bread	$4