Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
What kind of data does python pandas handle?
One must need to deal with data If they are working with any of these technologies like Machine Learning or Data Science. And data is the foundation for these technologies. Dealing with data is a very difficult process in real-time. because real-world data is messy.
The main advantage of using the python pandas package is, it has numerous functions to handle data. As we know that real-time data can be any form, it may be in the form of characters, integers, floating-point values, categorical data, and more.
Pandas is best for handling or manipulating tabular data because it has a DataFrame object which has more functions. DataFrame is a 2-dimensional data structure that stores tabular data that can be in any form (integer values, characters, floating values, categorical, and more).
Example
import pandas as pd
data = pd.read_csv('sales_data.csv')
data.dtypesExplanation
By using the import keyword we have imported the pandas package, after that the read_csv function is used to read the CSV file. Here sales_data.csv file is our data file, and this file has 10 columns which are named as Customer Number, Customer Name, 2016, 2017, Percent Growth, Jan Units, Month, Day, Year, Active.
Each column is holding a different type of data. To get each column data type individually here we are using the dtype attribute.
Output
Customer Number float64 Customer Name object 2016 object 2017 object Percent Growth object Jan Units object Month int64 Day int64 Year int64 Active object dtype: object
The above output block is representing column names and data types of our input data set (sales_data.cvs). There are three columns that store integer values and one column for floating-point values and the remaining six columns are storing object data nothing but text type data.
Example
df = pd.DataFrame({'datetime': [pd.Timestamp('20190210')],'boolean': True})
print(df)
print() # for providing space at output
print(df.dtypes)Explanation
The above code block is created by two data types which are DateTime and boolean data types. By using the pd.timestamp we have created date time dtype data.
Output
datetime boolean 0 2019-02-10 True datetime datetime64[ns] boolean bool dtype: object
There are 2 outputs in the above output block. The first one is representing data that is present in the data frame object df and the second one is representing the dtypes of each column of our data frame object.
By using these examples we can see how and what kind of data does pandas handle.
280 Views
