shyam kumar

shyam kumar


#45 Python Read and Write CSV Excel File | Tek Solutions | #teksolutions

In this Python Programming Tutorial, we will be learning how to work with csv files using the csv module. We will learn how to read, parse, and write to csv files. CSV stands for “Comma-Separated Values”. It is a common format for storing information. Knowing how to read, parse, and write this information to files will open the door to working with a lot of data throughout the world. Let’s get started.

#python #data-science #hadoop #teksolutions

What is GEEK

Buddha Community

#45 Python Read  and Write CSV Excel File |  Tek Solutions | #teksolutions
Osiki  Douglas

Osiki Douglas


Excelython — Part 4: Read Excel Files in Python

Project Description

You are working on a purchasing team and you want to check your sales and inventory, the pending orders you might have, where you need to place new orders and what are the products that need your attention as they are slow movers.

After you have done all the downloading, the processing and evaluation, you need to send to another colleague a file by email, that has all the products, split by supplier and volume to be ordered per different sheet and you need a separate excel file with the products that you have stock greater than 4 weeks, ordered by the top 20 cost value, in order to create a plan of push their sales or return them back to supplier.

#excel #python #python-beginner #excelython — part 4: read excel files in python #excelython #read excel files in python

Ray  Patel

Ray Patel


top 30 Python Tips and Tricks for Beginners

Welcome to my Blog , In this article, you are going to learn the top 10 python tips and tricks.

1) swap two numbers.

2) Reversing a string in Python.

3) Create a single string from all the elements in list.

4) Chaining Of Comparison Operators.

5) Print The File Path Of Imported Modules.

6) Return Multiple Values From Functions.

7) Find The Most Frequent Value In A List.

8) Check The Memory Usage Of An Object.

#python #python hacks tricks #python learning tips #python programming tricks #python tips #python tips and tricks #python tips and tricks advanced #python tips and tricks for beginners #python tips tricks and techniques #python tutorial #tips and tricks in python #tips to learn python #top 30 python tips and tricks for beginners

Kennith  Blick

Kennith Blick


Reading and Writing to Files in Python - Intermediate Python Tutorial #2

In this Python tutorial, we will learn how to deal with text files in Python using the built-in open function. You will understand how to use the most important modes: read, write and append.
That’s not all! We will discuss about file parsing and touch important string methods used for that such as: strip( ) and split( ). Finally we wrap up with a parsing file exercise to practice the new concepts. After that video you will be confident to deal with text files which is a very important skill to have as a programmer.

Playlist: Intermediate Python Tutorials | Video #2
Access the codes here:

00:00 - Summary of the video
00:17 - Types of files
00:43 - How to open a file
01:17 - File modes
02:15 - How to read data from a file
03:00 - with statement
04:10 - readlines( ) method
05:05 - String: strip( ) method
06:22 - How to iterate over a file line by lin
08:47 - How to write data to a file
11:43 - How to append data to a file
12:37 - Exercise: Parsing a text file
16:14 - Converting data types
17:00 - Next video announcement

Photo by Mario Ho on Unsplash

#reading #writing #python #intermediate python tutorial #reading and writing to files in python

Ray  Patel

Ray Patel


Lambda, Map, Filter functions in python

Welcome to my Blog, In this article, we will learn python lambda function, Map function, and filter function.

Lambda function in python: Lambda is a one line anonymous function and lambda takes any number of arguments but can only have one expression and python lambda syntax is

Syntax: x = lambda arguments : expression

Now i will show you some python lambda function examples:

#python #anonymous function python #filter function in python #lambda #lambda python 3 #map python #python filter #python filter lambda #python lambda #python lambda examples #python map

Reading CSV(), Excel(), JSON () and HTML() File Formats in Pandas

Panda reads data from csv, txt, excel & more file formats

What is Pandas?

Pandas is a Python library containing a bunch of capacities and specific information structures that have been intended to help Python developers to perform information examination errands in an organized manner.

Importing data is the most fundamental and absolute initial phase in any information-related work. The capacity to import the information accurately is a must have skill for every data scientist.

Data exists in many different forms, and not only should we know how to import various data formats but also how to analyze and manipulate the data to infer insights.

The majority of the things that pandas should do can be possible with fundamental Python, yet the gathered arrangement of pandas capacities and information structure makes the information examination assignments more reliable as far as punctuation and in this manner helps readability.

Specific highlights of pandas that we will be taking a look at over this and the few scenes include:

  • Reading information stored in CSV documents
  • Slicing and subsetting information in Dataframes (tables!)
  • Dealing with missing information
  • Reshaping information (long → wide, wide → long)
  • Inserting and deleting columns from data structures
  • Joining of datasets (after they have been stacked into Dataframes)

If you are asking why I compose pandas with a lower case ‘p’ because it is the name of the bundle and Python is case sensitive.

#python #programming #reading csv(), excel(), json () and html() file formats in pandas #csv() #excel() #html()