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 OOP Concepts

Java OOP Concepts Java OOP Concepts:       Java is not fully Object Oriented Programing Languages Because java Provide Primitive Data types Like int,string etc.             Java Provide Following OOPS: Object Class  Inheritance  Polymorphism Abstraction  Encapsulation 1.Object    -Object is nothing but just Blueprint Of Class Means it contain Properties And Behaviour Of Class.     example: real time Example is People, pen. 2.Class   -Class Contain Methods and Properties. so we can say that Collection of Object is nothing But Class. 3.Inheritance   -Inheritance is Process  or Scenario  for accessing Parent class Properties .Means access Properties and Method of Parent class into Sub Class. 4.Polymorphism    -In simple Word Polymorphism is way to Perform one Task in Multiple Dif...
Post a Comment
Read more

Factory Pattern

Factory Pattern        Factory Pattern is way to create object in such Way using Common Interface  without exposing the creation logic Simple Example       Example: step  1.  creation of interface.     public interface BANK {        double getIntrest();   } step  2.  implementation of interface for BOB. public class BOB implements BANK {     @Override     public double getIntrest() {         return 8.7;     } } step 3.  implementation of interface for SBI . public class SBI implements BANK{     @Override     public double getIntrest() {         return 5.7;     }      } step 4.  implementation of interface for UNION  . public class UNION  implements BANK{     ...
Post a Comment
Read more

HashMap in Java

    -What is HashMap:       A HashMap has value and  key. store value based on Key. HasMap implements the Map interface and extends AbstractMap class.       Allow only one null as key and can contain   multiple null value.       Also Conatin Order of element.         HasMap----extend---->AbstractMap----implement---->Map                 Now we see how to Put and Retrive value from HashMap.                Example.             import java.util.*;               class MapTest{                        public static void main(String args[]){     HashMap<Integer,String> map=new HashMap<Integer,String>();     map.put(1,"vjp");   map.put(...
1 comment
Read more