SajjadRobin

Learn every day

  • Like on facebookLike on facebook
  • Follow me on TwitterFollow me on Twitter
  • Subscribe to youtube channelSubscribe to youtube channel
  • Add SajjadRobin in your circleAdd SajjadRobin in your circle
  • LinkedInLinkedIn
  • FeedFeed

Category: How To

How To · Python

0

ETL in Python – read csv, json files

  • August 6, 2021

Let’s start with how to read csv, json files:

Read CSV, JSON files in Python
Python
1
2
3
4
5
6
 
import glob
list_csv = glob("*.csv")
 
list_json = glob("*.json")
 

Let’s create a function to read a CSV file in python:

Extract content from CSV in Python
Python
1
2
3
4
5
6
7
 
def extract_from_csv(file_to_process):
  dataframe = pd.read_csv(file_to_process)
  return dataframe
 
df = extract_from_csv("example1.csv")
 

Now, let’s create another function to read content[…]

Share this:

  • Tweet
  • Email

Read more

DELETE DUPLICATE ROW

How To · MySql · MySql

0

How to delete duplicate rows from a table

  • August 22, 2017

Often you want to delete rows from a table in mysql. How can you achieve it? Let’s say you have user table which has users with duplicate column (mysql field)[…]

Share this:

  • Tweet
  • Email

Read more

More Tutorials

How to setup virtual host in xampp

apache · How To

0

How to setup virtual host in xampp

  • May 8, 2017

This article is about how to setup virtual host in xampp. Why do you need virtual host? Simple example is to mimic public domain in local development machine. Say you[…]

Share this:

  • Tweet
  • Email

Read more

How to set AddHanlder in PHP

How To · php

0

How to set AddHandler in PHP

  • May 8, 2017

This article is about to set AddHandler properly in PHP. You can run .php file with apache. It may be necessary to execute other file extension with php parser like[…]

Share this:

  • Tweet
  • Email

Read more

  • Get your dream job

    Learn web development
  • Go social, go viral

  • Like on Facebook

    Like on Facebook
  • Recent Posts

    • ETL in Python – read csv, json files
    • Javascript – The Good Parts: Object
    • Javascript – The Good Parts : Grammar
    • How to delete duplicate rows from a table
    • How to setup virtual host in xampp
  • Categories

    • apache
    • How To
    • Javascript
    • MySql
    • MySql
    • php
    • Python
    • security
    • Udemy
    • Web Development in Bengali
    • Wordpress website
  • Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
    To find out more, including how to control cookies, see here: Cookie Policy
  • Like on facebookLike on facebook
  • Follow me on TwitterFollow me on Twitter
  • Subscribe to youtube channelSubscribe to youtube channel
  • Add SajjadRobin in your circleAdd SajjadRobin in your circle
  • LinkedInLinkedIn
  • FeedFeed

© Copyright 2018 sajjadrobin.