Anil  Sakhiya

Anil Sakhiya

1612013872

IOT (Internet of Things) Tutorial for Beginners | Getting Started with IOT

Great Learning brings you this live session on “Introduction to IoT for Beginners”. Internet of Things (IoT) is a network of devices that can sense, accumulate and transfer data over the internet without any human intervention. In this session, we will learn all the fundamentals of IoT. We will start off by understanding what exactly is “Internet of Things”, then we will understand the evolution of the internet, going ahead we will understand the architecture of IoT and finally we will look at some really interesting applications of IoT. There will also be a QnA at the end of the live session where you can ask all your queries. Once, the fundamentals of IoT are covered, we will look at the micro-controllers which are used for IoT such as Arduino and Raspberry Pi. Finally, we will look at some real-world examples of IoT that can be created using these micro-controllers.

#iot #developer

What is GEEK

Buddha Community

IOT (Internet of Things) Tutorial for Beginners | Getting Started with IOT
Shubham Ankit

Shubham Ankit

1657081614

How to Automate Excel with Python | Python Excel Tutorial (OpenPyXL)

How to Automate Excel with Python

In this article, We will show how we can use python to automate Excel . A useful Python library is Openpyxl which we will learn to do Excel Automation

What is OPENPYXL

Openpyxl is a Python library that is used to read from an Excel file or write to an Excel file. Data scientists use Openpyxl for data analysis, data copying, data mining, drawing charts, styling sheets, adding formulas, and more.

Workbook: A spreadsheet is represented as a workbook in openpyxl. A workbook consists of one or more sheets.

Sheet: A sheet is a single page composed of cells for organizing data.

Cell: The intersection of a row and a column is called a cell. Usually represented by A1, B5, etc.

Row: A row is a horizontal line represented by a number (1,2, etc.).

Column: A column is a vertical line represented by a capital letter (A, B, etc.).

Openpyxl can be installed using the pip command and it is recommended to install it in a virtual environment.

pip install openpyxl

CREATE A NEW WORKBOOK

We start by creating a new spreadsheet, which is called a workbook in Openpyxl. We import the workbook module from Openpyxl and use the function Workbook() which creates a new workbook.

from openpyxl
import Workbook
#creates a new workbook
wb = Workbook()
#Gets the first active worksheet
ws = wb.active
#creating new worksheets by using the create_sheet method

ws1 = wb.create_sheet("sheet1", 0) #inserts at first position
ws2 = wb.create_sheet("sheet2") #inserts at last position
ws3 = wb.create_sheet("sheet3", -1) #inserts at penultimate position

#Renaming the sheet
ws.title = "Example"

#save the workbook
wb.save(filename = "example.xlsx")

READING DATA FROM WORKBOOK

We load the file using the function load_Workbook() which takes the filename as an argument. The file must be saved in the same working directory.

#loading a workbook
wb = openpyxl.load_workbook("example.xlsx")

 

GETTING SHEETS FROM THE LOADED WORKBOOK

 

#getting sheet names
wb.sheetnames
result = ['sheet1', 'Sheet', 'sheet3', 'sheet2']

#getting a particular sheet
sheet1 = wb["sheet2"]

#getting sheet title
sheet1.title
result = 'sheet2'

#Getting the active sheet
sheetactive = wb.active
result = 'sheet1'

 

ACCESSING CELLS AND CELL VALUES

 

#get a cell from the sheet
sheet1["A1"] <
  Cell 'Sheet1'.A1 >

  #get the cell value
ws["A1"].value 'Segment'

#accessing cell using row and column and assigning a value
d = ws.cell(row = 4, column = 2, value = 10)
d.value
10

 

ITERATING THROUGH ROWS AND COLUMNS

 

#looping through each row and column
for x in range(1, 5):
  for y in range(1, 5):
  print(x, y, ws.cell(row = x, column = y)
    .value)

#getting the highest row number
ws.max_row
701

#getting the highest column number
ws.max_column
19

There are two functions for iterating through rows and columns.

Iter_rows() => returns the rows
Iter_cols() => returns the columns {
  min_row = 4, max_row = 5, min_col = 2, max_col = 5
} => This can be used to set the boundaries
for any iteration.

Example:

#iterating rows
for row in ws.iter_rows(min_row = 2, max_col = 3, max_row = 3):
  for cell in row:
  print(cell) <
  Cell 'Sheet1'.A2 >
  <
  Cell 'Sheet1'.B2 >
  <
  Cell 'Sheet1'.C2 >
  <
  Cell 'Sheet1'.A3 >
  <
  Cell 'Sheet1'.B3 >
  <
  Cell 'Sheet1'.C3 >

  #iterating columns
for col in ws.iter_cols(min_row = 2, max_col = 3, max_row = 3):
  for cell in col:
  print(cell) <
  Cell 'Sheet1'.A2 >
  <
  Cell 'Sheet1'.A3 >
  <
  Cell 'Sheet1'.B2 >
  <
  Cell 'Sheet1'.B3 >
  <
  Cell 'Sheet1'.C2 >
  <
  Cell 'Sheet1'.C3 >

To get all the rows of the worksheet we use the method worksheet.rows and to get all the columns of the worksheet we use the method worksheet.columns. Similarly, to iterate only through the values we use the method worksheet.values.


Example:

for row in ws.values:
  for value in row:
  print(value)

 

WRITING DATA TO AN EXCEL FILE

Writing to a workbook can be done in many ways such as adding a formula, adding charts, images, updating cell values, inserting rows and columns, etc… We will discuss each of these with an example.

 

CREATING AND SAVING A NEW WORKBOOK

 

#creates a new workbook
wb = openpyxl.Workbook()

#saving the workbook
wb.save("new.xlsx")

 

ADDING AND REMOVING SHEETS

 

#creating a new sheet
ws1 = wb.create_sheet(title = "sheet 2")

#creating a new sheet at index 0
ws2 = wb.create_sheet(index = 0, title = "sheet 0")

#checking the sheet names
wb.sheetnames['sheet 0', 'Sheet', 'sheet 2']

#deleting a sheet
del wb['sheet 0']

#checking sheetnames
wb.sheetnames['Sheet', 'sheet 2']

 

ADDING CELL VALUES

 

#checking the sheet value
ws['B2'].value
null

#adding value to cell
ws['B2'] = 367

#checking value
ws['B2'].value
367

 

ADDING FORMULAS

 

We often require formulas to be included in our Excel datasheet. We can easily add formulas using the Openpyxl module just like you add values to a cell.
 

For example:

import openpyxl
from openpyxl
import Workbook

wb = openpyxl.load_workbook("new1.xlsx")
ws = wb['Sheet']

ws['A9'] = '=SUM(A2:A8)'

wb.save("new2.xlsx")

The above program will add the formula (=SUM(A2:A8)) in cell A9. The result will be as below.

image

 

MERGE/UNMERGE CELLS

Two or more cells can be merged to a rectangular area using the method merge_cells(), and similarly, they can be unmerged using the method unmerge_cells().

For example:
Merge cells

#merge cells B2 to C9
ws.merge_cells('B2:C9')
ws['B2'] = "Merged cells"

Adding the above code to the previous example will merge cells as below.

image

UNMERGE CELLS

 

#unmerge cells B2 to C9
ws.unmerge_cells('B2:C9')

The above code will unmerge cells from B2 to C9.

INSERTING AN IMAGE

To insert an image we import the image function from the module openpyxl.drawing.image. We then load our image and add it to the cell as shown in the below example.

Example:

import openpyxl
from openpyxl
import Workbook
from openpyxl.drawing.image
import Image

wb = openpyxl.load_workbook("new1.xlsx")
ws = wb['Sheet']
#loading the image(should be in same folder)
img = Image('logo.png')
ws['A1'] = "Adding image"
#adjusting size
img.height = 130
img.width = 200
#adding img to cell A3

ws.add_image(img, 'A3')

wb.save("new2.xlsx")

Result:

image

CREATING CHARTS

Charts are essential to show a visualization of data. We can create charts from Excel data using the Openpyxl module chart. Different forms of charts such as line charts, bar charts, 3D line charts, etc., can be created. We need to create a reference that contains the data to be used for the chart, which is nothing but a selection of cells (rows and columns). I am using sample data to create a 3D bar chart in the below example:

Example

import openpyxl
from openpyxl
import Workbook
from openpyxl.chart
import BarChart3D, Reference, series

wb = openpyxl.load_workbook("example.xlsx")
ws = wb.active

values = Reference(ws, min_col = 3, min_row = 2, max_col = 3, max_row = 40)
chart = BarChart3D()
chart.add_data(values)
ws.add_chart(chart, "E3")
wb.save("MyChart.xlsx")

Result
image


How to Automate Excel with Python with Video Tutorial

Welcome to another video! In this video, We will cover how we can use python to automate Excel. I'll be going over everything from creating workbooks to accessing individual cells and stylizing cells. There is a ton of things that you can do with Excel but I'll just be covering the core/base things in OpenPyXl.

⭐️ Timestamps ⭐️
00:00 | Introduction
02:14 | Installing openpyxl
03:19 | Testing Installation
04:25 | Loading an Existing Workbook
06:46 | Accessing Worksheets
07:37 | Accessing Cell Values
08:58 | Saving Workbooks
09:52 | Creating, Listing and Changing Sheets
11:50 | Creating a New Workbook
12:39 | Adding/Appending Rows
14:26 | Accessing Multiple Cells
20:46 | Merging Cells
22:27 | Inserting and Deleting Rows
23:35 | Inserting and Deleting Columns
24:48 | Copying and Moving Cells
26:06 | Practical Example, Formulas & Cell Styling

📄 Resources 📄
OpenPyXL Docs: https://openpyxl.readthedocs.io/en/stable/ 
Code Written in This Tutorial: https://github.com/techwithtim/ExcelPythonTutorial 
Subscribe: https://www.youtube.com/c/TechWithTim/featured 

#python 

Wilford  Pagac

Wilford Pagac

1596789120

Best Custom Web & Mobile App Development Company

Everything around us has become smart, like smart infrastructures, smart cities, autonomous vehicles, to name a few. The innovation of smart devices makes it possible to achieve these heights in science and technology. But, data is vulnerable, there is a risk of attack by cybercriminals. To get started, let’s know about IoT devices.

What are IoT devices?

The Internet Of Things(IoT) is a system that interrelates computer devices like sensors, software, and actuators, digital machines, etc. They are linked together with particular objects that work through the internet and transfer data over devices without humans interference.

Famous examples are Amazon Alexa, Apple SIRI, Interconnected baby monitors, video doorbells, and smart thermostats.

How could your IoT devices be vulnerable?

When technologies grow and evolve, risks are also on the high stakes. Ransomware attacks are on the continuous increase; securing data has become the top priority.

When you think your smart home won’t fudge a thing against cybercriminals, you should also know that they are vulnerable. When cybercriminals access our smart voice speakers like Amazon Alexa or Apple Siri, it becomes easy for them to steal your data.

Cybersecurity report 2020 says popular hacking forums expose 770 million email addresses and 21 million unique passwords, 620 million accounts have been compromised from 16 hacked websites.

The attacks are likely to increase every year. To help you secure your data of IoT devices, here are some best tips you can implement.

Tips to secure your IoT devices

1. Change Default Router Name

Your router has the default name of make and model. When we stick with the manufacturer name, attackers can quickly identify our make and model. So give the router name different from your addresses, without giving away personal information.

2. Know your connected network and connected devices

If your devices are connected to the internet, these connections are vulnerable to cyber attacks when your devices don’t have the proper security. Almost every web interface is equipped with multiple devices, so it’s hard to track the device. But, it’s crucial to stay aware of them.

3. Change default usernames and passwords

When we use the default usernames and passwords, it is attackable. Because the cybercriminals possibly know the default passwords come with IoT devices. So use strong passwords to access our IoT devices.

4. Manage strong, Unique passwords for your IoT devices and accounts

Use strong or unique passwords that are easily assumed, such as ‘123456’ or ‘password1234’ to protect your accounts. Give strong and complex passwords formed by combinations of alphabets, numeric, and not easily bypassed symbols.

Also, change passwords for multiple accounts and change them regularly to avoid attacks. We can also set several attempts to wrong passwords to set locking the account to safeguard from the hackers.

5. Do not use Public WI-FI Networks

Are you try to keep an eye on your IoT devices through your mobile devices in different locations. I recommend you not to use the public WI-FI network to access them. Because they are easily accessible through for everyone, you are still in a hurry to access, use VPN that gives them protection against cyber-attacks, giving them privacy and security features, for example, using Express VPN.

6. Establish firewalls to discover the vulnerabilities

There are software and firewalls like intrusion detection system/intrusion prevention system in the market. This will be useful to screen and analyze the wire traffic of a network. You can identify the security weakness by the firewall scanners within the network structure. Use these firewalls to get rid of unwanted security issues and vulnerabilities.

7. Reconfigure your device settings

Every smart device comes with the insecure default settings, and sometimes we are not able to change these default settings configurations. These conditions need to be assessed and need to reconfigure the default settings.

8. Authenticate the IoT applications

Nowadays, every smart app offers authentication to secure the accounts. There are many types of authentication methods like single-factor authentication, two-step authentication, and multi-factor authentication. Use any one of these to send a one time password (OTP) to verify the user who logs in the smart device to keep our accounts from falling into the wrong hands.

9. Update the device software up to date

Every smart device manufacturer releases updates to fix bugs in their software. These security patches help us to improve our protection of the device. Also, update the software on the smartphone, which we are used to monitoring the IoT devices to avoid vulnerabilities.

10. Track the smartphones and keep them safe

When we connect the smart home to the smartphone and control them via smartphone, you need to keep them safe. If you miss the phone almost, every personal information is at risk to the cybercriminals. But sometimes it happens by accident, makes sure that you can clear all the data remotely.

However, securing smart devices is essential in the world of data. There are still cybercriminals bypassing the securities. So make sure to do the safety measures to avoid our accounts falling out into the wrong hands. I hope these steps will help you all to secure your IoT devices.

If you have any, feel free to share them in the comments! I’d love to know them.

Are you looking for more? Subscribe to weekly newsletters that can help your stay updated IoT application developments.

#iot #enterprise iot security #how iot can be used to enhance security #how to improve iot security #how to protect iot devices from hackers #how to secure iot devices #iot security #iot security devices #iot security offerings #iot security technologies iot security plus #iot vulnerable devices #risk based iot security program

Kole  Haag

Kole Haag

1597305600

How manufacturing and Lighting Solution companies are benefitting from IoT

Lights today have become more than simple means of lighting up the dark. During their evolution from a simple filament bulb to today’s connected LEDs, lights have become more efficient and intelligent.

Digitalization makes new services possible

Digitalization makes new services possible

Products and services in the field of lighting and building-services technology are taking the form of subscription models. The ongoing process of digitalization is driving the trend. Known as ‘X as a Service’ (XaaS), ‘Light as a Service’ (LaaS), ‘Security as a Service,’ and ‘Safety as a Service,’ this trend offers benefits for both providers and customers. Digitalization is not only driving this development but also giving rise to new business models offered by IoT service providers.

In the future, lighting will be part of the internet of things (IoT) and services. Modern technology based on IoT Applications makes it possible to adapt the light to the needs of individual users. Lighting-system operation can be optimized if employed in combination with sun-protection systems, air-conditioning technology, and user-behavior models.

Given that service providers receive data from many different locations, they can develop algorithms that benefit all customers by helping to control the lighting situation more effectively and thus save energy.

Customers via service agreements can obtain the best lighting for their premises without having to bear high investment costs. They not only profit from the reduced effort required but always have the latest IoT Technology and enjoy accounting benefits.

What Is Smart Lighting?

Simply speaking, smart lighting is a combination of 6 components.

  1. LED Luminaries
  2. Sensors
  3. Drivers to control lighting operations such as DALI
  4. Data connectivity modules such as Wi-Fi or 4G/LTE
  5. Platform to collect data, moderate data and onboard sensors enabled devices
  6. User facing application

A complete smart lighting system using IoT Platform can intelligently automate and control lighting operations making working environments safer, productive, and efficient.

What Can Smart Lighting do?

Technology without a relevant business use case is not of much use. Availability of a variety of Sensors, Advanced analytics techniques like Edge Computing, and scalable IoT Cloud services are fuelling the rise of unique use cases for smart lighting. IoT devices no longer limit industrial use cases for smart lighting solutions.

Smart lighting can enable the following use cases:

  1. Predictive maintenance of your lighting operations with IoT services
  2. Create custom schedules for lighting operations to save energy and reduce bills
  3. On-demand lighting based on motion sensor and proximity sensor
  4. HVAC cleaning and maintenance alerts based on temperature and dust particle measurements
  5. Smart lighting pole for measuring the presence of atmospheric gases. Digital boards for weather updates, integrated camera feed for security, and calling points for emergencies.

smart lighting

Why Facility Managers Should Upgrade to IoT Enabled Digital Service Solutions

For many years, efficiency and cost savings in maintenance operations have been the guiding lights for Facility Managers round the globe. But they are not enough. Facility Managers are now looking out for IoT solutions that can help them identify areas of improvement and give them operational insights with baseline data. Digitizing critical maintenance processes with the help of IoT solutions is the right step forward.

Lighting operations alone contribute a significant portion of maintenance expenses. But not many facility managers have visibility in area wise or device/machine wise electricity consumption. This is where IoT enabled solutions can help.

Three crucial IoT solutions can help Facility Managers not only create digital services operations but also reduce cost and gain efficiency, which enables higher productivity for the organization.

  1. IoT enabled Smart Lighting solution — Smart lighting solutions allow Facility Managers to switch to IoT lighting, which can control with defined rules without any manual intervention. Facility Managers also stand to gain from detailed reports on area wise electricity consumption, which gives them real insights that were not available before. Advanced features such as Faulty Light Identification, predicting light failure, can help Facility Managers plan their lighting maintenance operations, thus reducing time on production floors.
  2. IoT enabled smart, metering solutions. Smart metering solutions, when installed at each consumption point, can give Facility Managers real-time insights into important parameters such as quality of current supply, real-time voltage levels, power consumption, etc. When these parameters are associated with machine operational parameters can give real-time correlation between previously unknown factors. Automated operations such as isolators or MCB trips can save precious equipment from getting damaged. Detailed graphs and reports provide real insights into daily activities, allowing them to take necessary actions before things go wrong.
  3. IoT enabled smart air monitoring solution – Modern HVAC systems are the lifeline of today’s buildings. However, these systems are under constant pressure and need constant maintenance in the form of leak checks, duct cleanliness, and the ability to maintain the right temperature and humidity levels. IoT enabled ambient atmosphere monitoring systems can help Facility Managers get real-time visibility into their HVAC operations and their cleanliness status. High dust particles reading than normal can indicate a need to clean the ducts. Abnormal temperature or humidity levels can indicate window glazing going bad or condensation forming in unexpected places.

#internet of things #iot security #iot application #iot solutions #iot technology #internet of things applications #iot services #iot solutions provider

Joey  Grimes

Joey Grimes

1594207380

Understanding IoT Standards and Protocols | Powering Internet of Things

Introduction

A plethora of devices connected and sharing information is called the internet of things. These devices collect, send and receive data to applications, objects, and servers. They are used in various industries like automotive, industrial automation, medicine, security systems, and manufacturing.

There are various protocols and standards to connect. To decide a protocol, we need to consider the following aspects:

  • bandwidth
  • range
  • power consumptions
  • node of the protocols.

This article is aimed at understanding IoT standards and protocols offered by Internet Engineering Task Force (IETF), Institute of Electrical and Electronics Engineers (IEEE), and the International Telecommunication Union (ITU).

The following will give the protocol structure much better:

  • IoT Data Link Protocol
  • IEEE 802.15.4e
  • IEEE 802.11 ah
  • WirelessHART
  • Z-Wave
  • Bluetooth Low Energy
  • Zigbee Smart Energy
  • DASH7
  • HomePlug
  • G.9959
  • LTE-A
  • LoRaWAN
  • Weightless
  • DECT/ULE
  • Network Layer
  • Routing Protocols
  • RPL
  • CORPL
  • CARP
  • Encapsulation Protocols
  • LoWPAN
  • 6TiSCH
  • 6Lo
  • IPv6 over G.9959
  • IPv6 over Bluetooth Low Energy
  • Session Layer Protocols
  • MQTT
  • SMQTT
  • AMQP
  • CoAP
  • XMPP
  • DDS
  • IoT Management Protocol
  • Interconnection of Heterogeneous Datalink
  • Smart Transducer Interface
  • Security in IoT Protocols
  • MAC 802.15.4
  • 6LoWPAN
  • RPL
  • Application Layer

Background of IoT Protocol

In 1982, the first machine which can communicate, and track record was created. It was a soft drink vending machine from Coca-Cola. In 1999, an RFID technology researcher, Kelvin Ashton coined the term internet of things. In two decades from 2000-2019, the system had undergone rapid development and found many practical applications.

Since then, it has evolved as a different internet world, it requires a new range of standards and protocols. Although new standards are available some applications still use technology like HTTP.

Necessity of IoT Protocols

The following points will emphasize the necessity of these communication protocols and how they help us in overcoming issues:

  • Can be used to call for help in case of emergency or failure of another device which is connected.
  • Assist in notifying the user about the emergency.
  • Economically profitable, as the end-user data can be used to analyse trends and market.
  • Minimizes risks of security threats.
  • Unification of all the IoT communications available worldwide.
  • Heterogeneity within the connected systems.

Types of IoT Connections

The connections of the devices in IoT platform can be of following types:

  • Device to Device (D2D)
  • Device to Gateway
  • Gateway to Data systems
  • Between data systems

Let’s discuss in brief about each connection type of IoT.

#all #internet of things (iot) #iot development #iot standards #iot protocols #iot

Willie  Beier

Willie Beier

1596728880

Tutorial: Getting Started with R and RStudio

In this tutorial we’ll learn how to begin programming with R using RStudio. We’ll install R, and RStudio RStudio, an extremely popular development environment for R. We’ll learn the key RStudio features in order to start programming in R on our own.

If you already know how to use RStudio and want to learn some tips, tricks, and shortcuts, check out this Dataquest blog post.

Table of Contents

#data science tutorials #beginner #r tutorial #r tutorials #rstats #tutorial #tutorials