This is the 3 post in the series of Pandas and SQL command line similarity, link to first and second post are Pandas and SQL Pandas and SQL similarity 2 Finding unique values from the datasets Pandas We can find unique value and its count for a column with the help of below… Continue reading Pandas and SQL Similarity 3
Category: Data Science
Pandas and SQL similarity 2
This article is the next in the series about the topic of Pandas and SQL similarity which we discussed earlier Pandas and SQL similarity (2) Check the dtypes Pandas – To check data types of the data frame, type ‘df.dtypes’ command SQL – type sp_help table_name in the query editor. You may be wondering what… Continue reading Pandas and SQL similarity 2
Pandas and SQL Similarity 1
Pandas and SQL are the integral part of Data Science. It is used for data manipulation and analysis while SQL or Structured Query Language is usually used to fetch data, update the contents of the table, or operate on the structure of the database or tables, using any type of database tools, which will have… Continue reading Pandas and SQL Similarity 1