import pandas as pd
ds = pd.read_excel("C:\\Users\\mahes\\OneDrive\\Documents\\Students.xlsx")
dt = pd.DataFrame(ds)
print(dt)
Now, Let's perform some operations related to FillNa()
HANDLING MISSING DATA (FillNa) IN PANDAS
Wednesday, 23 June 2021
HANDLING MISSING DATA (dropna) IN PANDAS
import pandas as pd
ds = pd.read_excel("C:\\Users\\mahes\\OneDrive\\Documents\\Students.xlsx")
dt = pd.DataFrame(ds)
print(dt)
Now, Let's perform some operations related to DROPNA
ILOC[ ] IN PANDAS - PYTHON
import pandas as pd
ds = pd.read_excel("C:\\Users\\mahes\\OneDrive\\Documents\\Students.xlsx")
dt = pd.DataFrame(ds)
Now, Let's perform some operations related to ILOC
LOC[ ] IN PANDAS - PYTHON
LOC[ ] IN PANDAS
import pandas as pd
ds = pd.read_excel("C:\\Users\\mahes\\OneDrive\\Documents\\Students.xlsx")
dt = pd.DataFrame(ds)
Now, Let's perform some operations related to LOC and ILOC
Tuesday, 22 June 2021
EXPORT DATAFRAME TO EXCEL, CSV & TEXT FILE IN PANDAS || SAVE DATAFRAME IN PANDAS
EXPORT DATAFRAME TO EXCEL, CSV & TEXT FILE IN PANDAS
import pandas as pd
st = pd.read_excel("C:\\Users\\mahes\\OneDrive\\Documents\\Students.xlsx")
sd = pd.DataFrame(st)
print(st)
Making some changes in the dataframe
st['Total']=st['Hindi']+st['English'] +st['Science'] +st['History']+st['Mathematics']
Now, exporting the DataFrame as Excel, CSV and Text File
sd.to_excel("C:\\Users\\mahes\\OneDrive\\Desktop\\StudentsNew.xlsx")
sd.to_csv("C:\\Users\\mahes\\OneDrive\\Desktop\\StudentsNew.csv")
sd.to_csv("C:\\Users\\mahes\\OneDrive\\Desktop\\StudentsNew.txt" ,sep = "\t")
As you can see we have created three new files.
SORTING DATAFRAME (BY COLUMN) IN PANDAS (Part-2) - PYTHON PROGRAMMING
#SORTING DATAFRAME (BY COLUMN) IN PANDAS (Part-2) - PYTHON PROGRAMMING
Listing Two Rows
df[['Name','Total_Marks']]
df = df.drop(columns = "Total_Marks")
print(df)
MANIPULATING DATAFRAME IN PANDAS (ADD COLUMN , DROP COLUMN) || DATAFRAME MANIPULATIONS
import pandas as pd
dt = pd.read_excel("C:\\Users\\mahes\\OneDrive\\Documents\\Students.xlsx")
df = pd.DataFrame(dt)
print(df)
df['Total_Marks'] = 0
print(df)
df['Total_Marks'] = df['Hindi']+df['English']
df
SORTING DATAFRAME (BY COLUMN) IN PANDAS - PYTHON PROGRAMMING
#SORTING DATAFRAME (BY COLUMN) IN PANDAS
#clcoding
import pandas as pd
dt = pd.read_excel("FILE_NAME")
print(dt)
df = pd.DataFrame(dt)
df.sort_values("MAXMTEMPERATURE", ascending = False)
Monday, 21 June 2021
How do you generate random Password?
#How do you generate 8 random character?
#clcoding
from string import printable
from random import choice
print(*[choice(printable) for _ in range(8)], sep = '')
How do you reverse the string without take another string?
#How do you reverse the string without take another string?
#clcoding
s = 'hello'
n = -1
for x in s:
n += 1
while n >= 0:
print(s[n], end = '')
n -= 1
Sunday, 20 June 2021
INDEXING & SLICING DATAFRAMES IN PANDAS [PART 3]- PYTHON PROGRAMMING
INDEXING & SLICING DATAFRAMES IN PANDAS
data_frame(start:step:stop)
data_frame(col_name)
data_frame(col_name)[index_value]
INDEXING & SLICING DATAFRAMES IN PANDAS [PART 2]- PYTHON PROGRAMMING
INDEXING & SLICING DATAFRAMES IN PANDAS [PART 1]- PYTHON PROGRAMMING
INDEXING & SLICING DATAFRAMES IN PANDAS
head( )
tail( )
describe( )
MATHEMATICAL FUNCTIONS ON SERIES IN PANDAS [Boolean Functions] - PYTHON PROGRAMMING
1] Greater than
import pandas as pd
s1 = pd.Series([10,20,120,40,150])
s2 = pd.Series([70,80,90,100,110])
s1>(s2)
2] Less than
import pandas as pd
s1 = pd.Series([10,20,120,40,150])
s2 = pd.Series([70,80,90,100,110])
s1<(s2)
3] Equal to
import pandas as pd
s1 = pd.Series([10,20,120,40,150])
s2 = pd.Series([70,20,90,40,110])
s1==(s2)
MATHEMATICAL FUNCTIONS ON SERIES IN PANDAS [Part 1] - PYTHON PROGRAMMING
1] Addition
#clcoding
import pandas as pd
s1 = pd.Series([10,20,30,40,50])
s2 = pd.Series([70,80,90,100,110])
s1.add(s2)
2] Subtraction
import pandas as pd
s1 = pd.Series([10,20,30,40,50])
s2 = pd.Series([70,80,90,100,110])
s1.subtract(s2)
3] Multiplication
import pandas as pd
s1 = pd.Series([10,20,30,40,50])
s2 = pd.Series([70,80,90,100,110])
s1.multiply(s2)
import pandas as pd
s1 = pd.Series([10,20,30,40,50])
s2 = pd.Series([70,80,90,100,110])
s1.divide(s2)
Saturday, 19 June 2021
OPERATIONS ON SERIES - PYTHON
ATTRIBUTES OF SERIES IN PANDAS
1. index
2. array
3. values
4. name
5. shape
6. size
7. nbytes
8. dtype
9. memory_usage( )
10. empty
11. ndim
ATTRIBUTES OF SERIES IN PANDAS - PYTHON PROGRAMMING
ATTRIBUTES OF SERIES IN PANDAS
Index - Series.index - Return all index values
Array - Series.array - Return all index values
Values - Series.values - Return values of series
Name - Series.name - Return the name of Series
Shape - Series.shape - Return the shape
Ndim - Series.ndim - Return the dimension of series
Size - Series.size - Return the size of series
Nbytes - Series.nbytes - Returns the memory occupied
memory-usage - Series.memory-usage() - Returns memory occupied by both index & values
Join us: https://t.me/jupyter_python
DIFFERENT WAYS OF CREATING DATAFRAME IN PANDAS - PYTHON PROGRAMMING TWO (II)
#clcoding
dt=[('a',10),('b',20),('c',30)]
pd.Series(dt)
df = pd.read_excel("FILE_NAME")
pd.DataFrame(df)
DIFFERENT WAYS OF CREATING DATAFRAME IN PANDAS - PYTHON PROGRAMMING
#clcoding
import numpy as np
a = np.array([10,20,30,40,50])
import pandas as pd
sa = pd.Series(a)
print(a)
print(sa)
Friday, 18 June 2021
How to find any vowels without using any loops
#How to find any vowels without using any loops
#clcoding
from re import findall
s = 'clcoding'
findall(r'[aeiou]',s)
How do you find dayname of particular date of year?
#How do you find dayname of particular date of year?
#Clcoding
import calendar as cal
dayname = ['MONDAY', 'TUESDAY', 'WEDNESDAY', 'THURSDAY',
'FRIDAY', 'SATURDAY', 'SUNDAY']
inx = cal.weekday(2021,6,18)
dayname[inx]
Thursday, 17 June 2021
Print month of a year
#Print month of a year
#clcoding
import calendar
print(calendar.month(2021,3))
How to create your own Dataset
#How to create your own Dataset
#clcoding
from faker import Faker
fake = Faker()
for _ in range(10):
print(fake.name())
How to make a text in python colorfull.
#how to make a text in python colorfull.
#clcoding
print("\033[92mIf you like this post, Upvote it")
print("\033[96mIf you like this post, Upvote it")
print("\033[93mIf you like this post, Upvote it")
print("\033[95mIf you like this post, Upvote it")
print("\033[1mIf you like this post, Upvote it")
print("\033[4mIf you like this post, Upvote it")
print("\033[94mIf you like this post, Upvote it")
Join us: https://t.me/jupyter_python Like us: https://www.facebook.com/pirawenpython
How to use class and method without creating object
#How to use class and method without creating object
#clcoding
class fruit:
def is_sweet():
return True
if fruit.is_sweet():
print("Yes")
else:
print("No")
How do you find which string largest between two strings?
#HOW TO WHICH STRING IS LARGEST BETWEEN TWO STRINGS
#clcoding
str1 = 'Clcoding'
str2 = 'ClcodingPython'
max(str1,str2)
#HOW TO WHICH STRING IS LARGEST BETWEEN TWO STRINGS
#clcoding
str1 = 'Clcoding'
str2 = 'ClcodingPython'
if str1>str2:
print(str1,'is the largest string')
else:
print(str2,'is the largest string')
How to print only the special characters
#How to print only the special characters
#clcoding
import re
String1= 'Welcome$$@@'
print(*re.findall(r'\W',String1))
Convert a number into scientific format
#Convert a number into scientific format
#clcoding
a = '{:.0e}' .format(1111111111111)
b = '{:.0e}' .format(2222222222222)
print(a)
print(b)
Join us: https://t.me/jupyter_python
Like us: : https://www.facebook.com/pirawenpython
Tuesday, 15 June 2021
Login with Retrofit in android Studio with SourceCode | Login and Registration form in android using JSON example
Build.gradle File:- implementation 'com.google.android.material:material:1.3.0'
implementation 'com.squareup.retrofit2:retrofit:2.8.1'
implementation 'com.squareup.retrofit2:converter-gson:2.8.1'
implementation 'com.squareup.okhttp3:logging-interceptor:4.6.0' Activity-main <?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:orientation="vertical"
android:background="@color/colorWhite"
android:layout_height="match_parent"
tools:context=".MainActivity">
<TextView
android:layout_width="wrap_content"
android:text="Login to continue"
android:layout_marginTop="100dp"
android:textSize="24sp"
android:layout_gravity="center_horizontal"
android:textColor="@color/colorPrimaryDark"
android:layout_height="wrap_content" />
<com.google.android.material.textfield.TextInputLayout
android:layout_width="match_parent"
android:layout_marginTop="30dp"
android:layout_marginStart="30dp"
android:layout_marginEnd="30dp"
android:hint="Username"
android:layout_height="wrap_content">
<com.google.android.material.textfield.TextInputEditText
android:layout_width="match_parent"
android:inputType="text"
android:id="@+id/edUsername"
android:layout_height="wrap_content" />
</com.google.android.material.textfield.TextInputLayout>
<com.google.android.material.textfield.TextInputLayout
android:layout_width="match_parent"
android:layout_marginTop="30dp"
android:hint="Password"
android:layout_marginStart="30dp"
android:layout_marginEnd="30dp"
android:layout_height="wrap_content">
<com.google.android.material.textfield.TextInputEditText
android:layout_width="match_parent"
android:inputType="textPassword"
android:id="@+id/edPassword"
android:layout_height="wrap_content" />
</com.google.android.material.textfield.TextInputLayout>
<Button
android:layout_width="match_parent"
android:layout_margin="30dp"
android:text="Login"
android:id="@+id/btnLogin"
android:background="@color/colorPrimary"
android:textColor="@color/colorWhite"
android:layout_height="wrap_content" />
</LinearLayout> Java File :- 1. Api Client import okhttp3.OkHttpClient;
import okhttp3.logging.HttpLoggingInterceptor;
import retrofit2.Retrofit;
import retrofit2.converter.gson.GsonConverterFactory;
public class ApiClient {
private static Retrofit getRetrofit(){
HttpLoggingInterceptor httpLoggingInterceptor = new HttpLoggingInterceptor();
httpLoggingInterceptor.setLevel(HttpLoggingInterceptor.Level.BODY);
OkHttpClient okHttpClient = new OkHttpClient.Builder().addInterceptor(httpLoggingInterceptor).build();
Retrofit retrofit = new Retrofit.Builder()
.addConverterFactory(GsonConverterFactory.create())
.baseUrl("http://api.irawen.net/") //Change server URL
.client(okHttpClient)
.build();
return retrofit;
}
public static UserService getUserService(){
UserService userService = getRetrofit().create(UserService.class);
return userService;
}
}
2. Login Request :- public class LoginRequest {
private String username;
private String password;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
3. Login response :- public class LoginResponse {
private int user_id;
private String email;
private String username;
public int getUser_id() {
return user_id;
}
public void setUser_id(int user_id) {
this.user_id = user_id;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
} 4. Main Activity :- import android.content.Intent;
import android.os.Bundle;
import android.os.Handler;
import android.text.TextUtils;
import android.view.View;
import android.widget.Button;
import android.widget.Toast;
import com.google.android.material.textfield.TextInputEditText;
import androidx.appcompat.app.AppCompatActivity;
import retrofit2.Call;
import retrofit2.Callback;
import retrofit2.Response;
public class MainActivity extends AppCompatActivity {
TextInputEditText username, password;
Button btnLogin;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
username = findViewById(R.id.edUsername);
password = findViewById(R.id.edPassword);
btnLogin = findViewById(R.id.btnLogin);
btnLogin.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View view) {
if(TextUtils.isEmpty(username.getText().toString()) || TextUtils.isEmpty(password.getText().toString())){
Toast.makeText(MainActivity.this,"Username / Password Required", Toast.LENGTH_LONG).show();
}else{
//proceed to login
login();
}
}
});
}
public void login(){
LoginRequest loginRequest = new LoginRequest();
loginRequest.setUsername(username.getText().toString());
loginRequest.setPassword(password.getText().toString());
Call<LoginResponse> loginResponseCall = ApiClient.getUserService().userLogin(loginRequest);
loginResponseCall.enqueue(new Callback<LoginResponse>() {
@Override
public void onResponse(Call<LoginResponse> call, Response<LoginResponse> response) {
if(response.isSuccessful()){
Toast.makeText(MainActivity.this,"Login Successful", Toast.LENGTH_LONG).show();
LoginResponse loginResponse = response.body();
new Handler().postDelayed(new Runnable() {
@Override
public void run() {
startActivity(new Intent(MainActivity.this,DashboardActivity.class).putExtra("data",loginResponse.getUsername()));
}
},700);
}else{
Toast.makeText(MainActivity.this,"Login Failed", Toast.LENGTH_LONG).show();
}
}
@Override
public void onFailure(Call<LoginResponse> call, Throwable t) {
Toast.makeText(MainActivity.this,"Throwable "+t.getLocalizedMessage(), Toast.LENGTH_LONG).show();
}
});
}
}
5. User Service :-import retrofit2.Call;
import retrofit2.http.Body;
import retrofit2.http.POST;
public interface UserService {
@POST("authenticate/")
Call<LoginResponse> userLogin(@Body LoginRequest loginRequest);
}Popular Posts
-
Activity_main.xml File <? xml version= "1.0" encoding= "utf-8" ?> < LinearLayout xmlns: android = &qu... -
Procedure Oriented Programming Language:- High level language such as COBOL , FORTRAN AND C is commonly known as procedure oriented progr... -
Activity Main : <? xml version ="1.0" encoding ="utf-8" ?> < androidx.constraintlayout.widget.ConstraintLayout...
-
Build.gradle File:- implementation 'com.google.android.material:material:1.3.0' implementation 'com.squareup.retrofit2:retr...
-
Advantages of Object Oriented Programming Object oriented programming has several advantage to the programmer and user. Through inheri...
-
There are many programming languages, each corresponding to specific needs (formula calculus, character string processing, real-time, etc.)...
-
Build interactive, data-driven websites with the potent combination of open-source technologies and web standards, even if you have only ... -
Pseudocode is a compact and informal high-level description of a computer programming algorithm. Pseudo-code typically omits details tha... -
What is Python? → Python is an interpreted High level programming Language for General purpose programming. Python is created by Gui... -
Introduction: In today's digital age, where typing on keyboards and tapping on screens has become the norm, there is something truly mag...
