import pandas as pa
dat = {
"Country": [
"India", "China", "Indonesia", "Pakistan", "Bangladesh", "Japan", "Philippines", "Vietnam", "Iran", "Turkey",
"Thailand", "Myanmar", "South Korea", "Iraq", "Afghanistan", "Russia", "Saudi Arabia", "Uzbekistan", "Yemen", "Malaysia",
"Nepal", "North Korea", "Taiwan", "Syria", "Sri Lanka", "Kazakhstan", "Cambodia", "Jordan", "United Arab Emirates",
"Tajikistan", "Israel", "Azerbaijan", "Laos", "Hong Kong (China)", "Kyrgyzstan", "Turkmenistan", "Singapore", "Palestine"
],
"Capital": [
"New Delhi", "Beijing", "Jakarta", "Islamabad", "Dhaka", "Tokyo", "Manila", "Hanoi", "Tehran", "Ankara",
"Bangkok", "Naypyidaw", "Seoul", "Baghdad", "Kabul", "Moscow", "Riyadh", "Tashkent", "Sana'a", "Kuala Lumpur",
"Kathmandu", "Pyongyang", "Taipei", "Damascus", "Sri Jayawardenepura Kotte", "Astana", "Phnom Penh", "Amman", "Abu Dhabi",
"Dushanbe", "Jerusalem", "Baku", "Vientiane", "Hong Kong", "Bishkek", "Ashgabat", "Singapore", "East Jerusalem"
],
"Geographic Location": [
"South Asia", "East Asia", "Southeast Asia", "South Asia", "South Asia", "East Asia", "Southeast Asia", "Southeast Asia",
"West Asia", "West Asia", "Southeast Asia", "Southeast Asia", "East Asia", "West Asia", "South Asia", "Northern Asia",
"West Asia", "Central Asia", "West Asia", "Southeast Asia", "South Asia", "East Asia", "East Asia", "West Asia",
"South Asia", "Central Asia", "Southeast Asia", "West Asia", "West Asia", "Central Asia", "West Asia", "West Asia",
"Southeast Asia", "East Asia", "Central Asia", "Central Asia", "Southeast Asia", "West Asia"
]
}
da = pa.DataFrame(dat)
#Entire DataFrame
print("\n\tEntire DataFrame:")
print(da)
print('\n')
#First 20 rows
print("\n\tFirst 20 rows:")
print(da.head(20))
print('\n')
#Last 15 rows
print("\n\tLast 15 rows:")
print(da.tail(15))
print('\n')
#Size of the DataFrame
print("\n\tSize of the DataFrame:", da.size)
print('\n')
#Country and Capital only
print("\n\tCountry and Capital columns:")
print(da[['Country', 'Capital']])
print('\n')
#Population
population = [
1428627000, 1408280000, 277534000, 240485000, 172954000, 123700000, 117337000, 100145000, 89172000, 85664944,
65950000, 55227000, 51751065, 46100000, 43486000, 143400000, 36947000, 36024000, 34449000, 34308000,
30896000, 26160000, 23893000, 23227000, 21893000, 19994000, 17168000, 11337000, 9516000,
10143000, 9364000, 10353000, 7749000, 7488000, 7174000, 6789000, 5637000, 5371000
]
da['Population'] = population
print('\n')
#Sort
da_sorted = da.sort_values(by='Population', ascending=False)
print("\n\tDataFrame sorted by Population in a Descending order:")
print(da_sorted)
print('\n')
#Filter : Southeast Asia
SA_da = da[da['Geographic Location'] == 'Southeast Asia']
print("\n\tSoutheast Asia countries:")
print(SA_da)
print('\n')
#Filter : West Asia
WA_da = da[da['Geographic Location'] == 'West Asia']
print("\n\tWest Asia countries:")
print(WA_da)
print('\n')Benefits of CodeGroundAI Online IDE
Multi-Language Support
CodeGroundAI Online IDE supports C++, Java, Node.js, Python, and more, making it an incredibly versatile tool for diverse coding needs. This extensive language support allows developers to work on different projects within a single platform.
Real-Time Collaboration
Our real-time collaboration feature enables multiple developers to work on the same project simultaneously, enhancing teamwork and productivity. This feature is particularly beneficial for remote teams and pair programming sessions.
User-Friendly Interface
Designed with a clean and intuitive interface, CodeGroundAI Online IDE simplifies coding and debugging processes, making it accessible for users of all skill levels. The ease of use and clear navigation ensure a smooth coding experience.
Instant Code Execution
Experience fast and efficient code execution with immediate feedback in the integrated terminal. This feature helps streamline the development process, allowing developers to quickly test and debug their code.
Free to Use
Enjoy the full range of features at no cost. CodeGroundAI Online IDE is completely free, providing a valuable resource for developers without any subscription fees. This makes it an ideal choice for students, hobbyists, and professionals alike.
Cloud-Based Platform
As a cloud-based IDE, CodeGroundAI allows you to access your projects from anywhere, at any time. This flexibility ensures that you can continue coding without being tied to a specific device or location.
Customizable Environment
Tailor the IDE to your preferences with customizable themes, layouts, and extensions. This personalization ensures a comfortable and productive coding environment.
Why Choose CodeGroundAI Over Other Online IDEs?
CodeGroundAI Online IDE stands out from the competition with its comprehensive feature set, ease of use, and cost-effectiveness. Unlike many other online IDEs that require subscriptions or offer limited free plans, CodeGroundAI provides all its features for free. Our multi-language support, real-time collaboration, and advanced debugging tools ensure that you have everything you need for effective development. Additionally, our user-friendly interface and customizable environment make coding a pleasant experience, regardless of your expertise level. Choose CodeGroundAI Online IDE for a seamless, efficient, and enjoyable coding experience.