Pandas Sql Commands

	SQL	Python
Filtering	sql SELECT * FROM table WHERE column = 'value'	df[df['column'] == 'value']
Ordering	SELECT * FROM table ORDER BY column ASC	df[df[‘column’] == ‘value’]
Removing duplicates	SELECT * FROM table ORDER BY column ASC	df[df[‘column’] == ‘value’]
Filling missing values	SELECT * FROM table ORDER BY column ASC	df[df[‘column’] == ‘value’]
Changing data types	SELECT * FROM table ORDER BY column ASC	df[df[‘column’] == ‘value’]
Renaming columns	SELECT * FROM table ORDER BY column ASC	df[df[‘column’] == ‘value’]
Summing	sql SELECT SUM(column) FROM table	py df['column'].sum()