EXPORT DATAFRAME TO EXCEL, CSV & TEXT FILE IN PANDAS || SAVE DATAFRAME IN PANDAS

EXPORT DATAFRAME TO EXCEL, CSV & TEXT FILE IN PANDAS 

Firstly, we are importing an excel sheet as a DataFrame,

 

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.

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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)

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

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

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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)

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

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 = '') 

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

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

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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]

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

INDEXING & SLICING DATAFRAMES IN PANDAS [PART 2]- PYTHON PROGRAMMING

INDEXING & SLICING DATAFRAMES IN PANDAS

Shape()

loc()

Columns()

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

INDEXING & SLICING DATAFRAMES IN PANDAS [PART 1]- PYTHON PROGRAMMING

INDEXING & SLICING DATAFRAMES IN PANDAS

head( )

tail( )

describe( )

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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)

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

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)

4] Division

import pandas as pd

s1 = pd.Series([10,20,30,40,50])

s2 = pd.Series([70,80,90,100,110])

s1.divide(s2)

        

 

                                                                      

   

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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

Like us: https://www.facebook.com/pirawenpython

Read More

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)

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

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)

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

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)

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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]

Join us: https://t.me/jupyter_python Like us: https://www.facebook.com/pirawenpython

Read More

Print month of a year

#Print month of a year

#clcoding

import calendar

print(calendar.month(2021,3))

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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())

Join us: https://t.me/jupyter_python 

Like us: https://www.facebook.com/pirawenpython

Read More

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

Read More

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")

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

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')

Join us: https://t.me/jupyter_python Like us: https://www.facebook.com/pirawenpython

Read More

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))

Join us: https://t.me/jupyter_python 

 Like us: https://www.facebook.com/pirawenpython

Read More

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

Read More

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);


}

Read More

DIGITAL CLOCK IN PYTHON

#DIGITAL CLOCK IN PYTHON

#clcoding

from datetime import datetime

from time import sleep

while 1:

    n=datetime.now()

    print(datetime.strftime(n,"%H:%M:%S"), end='\r')

    sleep(1) 

Join us: https://t.me/jupyter_python 

 Like us: https://www.facebook.com/pirawenpython

Read More

Conversion of Hex, Oct, Bin numbers from integer using python

Code: 

#Convert into HEX

print('{:X}'.format(199))

#Convert into OCT

print('{:o}'.format(199))

#Convert into Binary

print('{:b}'.format(199))

#Convert into Grey

print('{:g}'.format(199))

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Let’s play with inheritance. What will be outputted?

class A

{

public void abc(int q)

{

Console.WriteLine("abc from A");

}

}

class B : A

{

public void abc(double p)

{

Console.WriteLine("abc from B");

}

}

static void Main(string[] args)

{

int i = 5;

B b = new B();

b.abc(i);

Console.ReadLine();

}

Answer :-

abc from B.

Read More

A typical polymorphism understanding swindle. The main thing is not to forget and overlook anything. What will be the result of execution of the following code?

class Program

{

static void Main(string[] args)

{

MyClassB b = new MyClassB();

MyClassA a = b;

a.abc();

Console.ReadLine();

}

}

class MyClassA

{

public MyClassA()

{

Console.WriteLine("constructor A");

}

public void abc()

{

Console.WriteLine("A");

}

}

class MyClassB:MyClassA

{

public MyClassB()

{

Console.WriteLine("constructor B");

}

public void abc()

{

Console.WriteLine("B");

}

}

Answer :-

constructor A
constructor B
A

During initialization of the B class, the constructor of the A class will be executed by default, then constructor of the B class. After assignment of the b value to a type variable of the A class, we will get an instance of the B class in it. One would think that abc() from the B class should be called, but since there is no specification of any predicate of the abc method in the B class, it hides abc from the A class. The example is not quite correct and abc() in the B class will be underlined, since the new predicate is required.

Read More

Print Color text in Python

Code: 

#clcoding

print("\033[1;37;48m Python \n")

print("\033[1;36;48m Python \n")

print("\033[1;35;48m Python \n")

print("\033[1;34;48m Python \n")

print("\033[1;33;48m Python \n")

print("\033[1;32;48m Python \n")

print("\033[1;31;48m Python \n")

Join us: https://t.me/jupyter_python

Like us: https://www.facebook.com/pirawenpython

Read More

Print Emoji's in Python

Code:

print("\U0001F917")

print("\U0001F637")

print("\U0001F62A")

print("\U0001F618")

print("\U0001F600")

Telegram: https://t.me/clcoding_python 

  https://www.facebook.com/groups/pirawenpython/

Read More