Posts

Showing posts with the label series in pandas examples

Featured Post

Step-by-Step Guide to Creating an AWS RDS Database Instance

Image
 Amazon Relational Database Service (AWS RDS) makes it easy to set up, operate, and scale a relational database in the cloud. Instead of managing servers, patching OS, and handling backups manually, AWS RDS takes care of the heavy lifting so you can focus on building applications and data pipelines. In this blog, we’ll walk through how to create an AWS RDS instance , key configuration choices, and best practices you should follow in real-world projects. What is AWS RDS? AWS RDS is a managed database service that supports popular relational engines such as: Amazon Aurora (MySQL / PostgreSQL compatible) MySQL PostgreSQL MariaDB Oracle SQL Server With RDS, AWS manages: Database provisioning Automated backups Software patching High availability (Multi-AZ) Monitoring and scaling Prerequisites Before creating an RDS instance, make sure you have: An active AWS account Proper IAM permissions (RDS, EC2, VPC) A basic understanding of: ...

How to use Pandas Series Method top ideas

Image
Here is an example of how to use a Series constructor in Pandas. A one-dimensional array capable of holding any data type (integers, strings, floating-point numbers, Python objects, etc.) is called a Series object in pandas. Sample DataFrame Single dimension data Below is the single dimension data of Index and Value.  Index  Value  1  10                2  40  3  01  4  99 Having single value for an index is called Single dimensional data. On the other hand, when one index has multiple values, it is called multi-dimensional array.   Below is the example for Multi-dimensional array.  a = (1, (10,20)) mySeries =  pd. Series(data, index=index) Here, pd is a Pandas object. The data and index are two arguments. The  data refers to a Python dictionary of "ndarray"  and index is index of data. Generating DataFrame from single dimension data The below example shows, how ...