Pandas Dataframe Query Lessons

	import numpy as np
	import pandas as pd
	#create data frame
	#Data frame to matrix
	df = pd.DataFrame({'Perf':[21,112,13,41],'Sets':['A-B','A','A-C-B','D-E-F'],'SetCount':[2,1,3,3]})
	print(df)
	#Find top one
	index = df[['Perf']].idxmax()
	print(index)
	FirstItem = df['Sets'].values[index]
	print(FirstItem)
	result_item = str(FirstItem)
	result_item = result_item.strip()
	result_item = result_item.replace('[','')
	result_item = result_item.replace(']','')
	result_item = result_item.replace('\'','')
	print(result_item)
	#Sort the dataframe
	final_df = df.sort_values(by=['Perf'], ascending=False)
	print(final_df)
	#filter set of records on a column condition
	temp_step = df.loc[df['SetCount'] == 2]
	print(temp_step)
	#Find by text search
	temp_items = df[df['Sets'].str.contains(result_item)]
	print(temp_items)
	#Drop index on string column
	results = final_df['Sets']
	resultstr = results.to_string(index=False)
	print(resultstr)

view raw dataframequery.py hosted with ❤ by GitHub

 

Keep Thinking!!!