Skip to main content

Reading csv/Google Sheet in Python

 Reading google sheet file using function:


File_Url="https://docs.google.com/spreadsheets/d/458qrjGFH9CD050rRwEHfayWVd4x9VheVAiZkGsj4lIo/export?format=tsv"

def getGoogle(google):

    import pandas as pd
    import numpy as np
    import sys
    if sys.version_info.major == 3:
        import ssl
        ssl._create_default_https_context = ssl._create_unverified_context
    try:
        df = pd.read_csv(google, delimiter='\t').rename(columns=lambda x: x.strip())
    except Exception as e:
        import requests, io
        x = requests.get(url=google).content
        df = pd.read_csv(io.StringIO(x.decode('utf8')), delimiter='\t').rename(columns=lambda x: x.strip())
    df = df.replace({np.nan: None})
    return df.to_dict('records')
   

googleSheetRecord=getGoogle(File_Url)

now you can get every record from data as below.

for record in googleSheetRecord:

print(record)


happy learning☺ 


Labels:

Comments

Post a Comment

Popular posts from this blog

Java 8 installation

Java 8 installation setup:       First of all ,we need to install java 8 jdk in your  machine.so for that you can download  it from following  url. click here download  jdk 1.8.0_11 and install it on your machine. Once installation has been done. Please checkout version of jdk. C:\Users\hp>java -version java version "1.8.0_11" Java(TM) SE Runtime Environment (build 1.8.0_11-b12) Java HotSpot(TM) Client VM (build 25.11-b03, mixed mode, sharing) once you have installed Java on your machine, you would need to set environment variables to point to correct installation directories                                                       ...
1 comment
Read more

Interface in Java

Interface:          An interface is a nothing but  reference type,it is same as class.In short Interface is collection of Abstract Method .          It can  also contain  final, static fields  .               you can't create object of Interface.    it can't have Constructor.   Interface can't implement another interface it can extend another one. Interface not extended by class but implemented. Declare Interface: public interface Example {     // final, static fields  .     //Method } Example 1.create interface that contain method. public interface IA {     public void show(); } 2.implement by class  public class ClassA  implements IA{     @Override     public void show() {         System.out.println("from class A called");   ...
Post a Comment
Read more