3rd Semester Syllabus

Mining Geology Lab

Perform all experiments

1. Megascopic identification and description of Rock Forming Minerals.
2. Megascopic identification and description of important Rocks.
3. Practices on Basic Concept of Contours, Attitude of Beds, Width of Outcrop, True and Apparent Dips.
4. Study of ecological Maps, preparation and description of Geological Cross Sections.
5. Megascopic identification, description and distribution of Ore Forming Minerals and Industrial Minerals.
6. Plotting of important Mineral deposits / mine locations on map of India.

Python Programming Lab

Perform any ten experiments

1. Experiment 1:
   a) Download and Install IDLE. Write and execute Python program to-
   b) Calculate the Area of a Triangle where its three sides a, b, c are given. s=(a+b+c)/2, Area=square root of s(s-a)(s-b)(s-c) (write program without using function)
   c) Swap Two Variables
   d) Solve quadratic equation for real numbers.
2. Experiment 2:
   Write and execute Python program to-
   a) Check if a Number is Positive, Negative or zero.
   b) Check whether the given year is a Leap Year.
   c) Print all Prime Numbers in an Interval.
   d) Display the multiplication Table based on the given input.
   e) Print the Fibonacci sequence.
   f) Find the Factorial of a Number.
3. Experiment 3:
   Write and execute Python program to-
   a) Check whether the string is Palindrome
   b) Reverse words in a given String in Python
   c) Identify in a strings the name, position and counting of vowels.
   d) Count the Number of matching characters in a pair of string (set)
   e) Python program for removing i-th character from a string
4. Experiment 4:
   Write and execute Python program to-
   a) Find largest number in a given list without using max().
   b) Find the common numbers from two lists.
   c) Create a list of even numbers and another list of odd numbers from a given list.
   d) To find number of occurrences of given number without using built-in methods.
5. Experiment 5:
   Write and execute Python program to-
   a) Find the index of an item of a tuple.
   b) Find the length of a tuple.
   c) To reverse a tuple.
   d) Write a Python program to sort a list of tuple by its float element.
   Sample data: [('item1', '12.20'), ('item2', '15.10'), ('item3', '24.5')]
   Expected Output: [('item3', '24.5'), ('item2', '15.10'), ('item1', '12.20')]
6. Experiment 6:
   Write and execute Python program to-
   a) Create an intersection of sets.
   b) Create a union of sets.
   c) Create set difference.
   d) Check if two given sets have no elements in common.
7. Experiment 7:
   Write and execute Python program to-
   a) Write a Python script to concatenate two dictionaries to create a new one
   b) Write a Python script to merge two Python dictionaries.
   c) Write a Python program to combine two dictionary adding values for common keys.
   d1 = {'a': 100, 'b': 200, 'c':300}
   d2 = {'a': 300, 'b': 200, 'd':400}
   Sample output: d({'a': 400, 'b': 400, 'd': 400, 'c': 300})
8. Experiment 8:
   Write and execute Python program to-
   a) Write a Python function for reversing a string and call it.
   b) Write a Python function for calculating compound interest and call it.
   c) Write a Python function for calculating the factorial of a number and call it to calculate ln/(lr)*!(n-r)) where symbol '!' stands for factorial.
9. Experiment 9:
   Write program using OOP approach to –
   a) Create an instance of a specified class and display the namespace of the said instance.
   b) Create a Python class named Student with two attributes: student_id, student_name. Add a new attribute: student_class. Create a function to display all attributes and their values in the Student class.
   c) Create a Python class named Student with two instances student1, student2 and assign values to the instances' attributes. Print all the attributes of the student1, student2 instances.
   d) Write programs to demonstrate use of following types of inheritance:
      i. Single inheritance
      ii. Multiple inheritance
      iii. Multilevel inheritance
   e) Demonstrate use of polymorphism with following situations:
      i. Polymorphism in operator
      ii. Polymorphism in user defined method
      iii. Polymorphism in built-in function
      iv. Polymorphism with class method
      v. Polymorphism with method overriding
10. Experiment 10:
    a) Using exception handling feature such as try…except, try finally- write minimum three programs to handle following types of exceptions.
       i. TypeError
       ii. NameError
       iii. IndexError
       iv. KeyError
       v. ValueError
       vi. IOError
       vii. ZeroDivisionError
    b) Write Python program to demonstrate file operations.
11. Experiment 11: Working with a Series using Pandas
    a) Create a series using list and dictionary.
    b) Create a series using NumPy functions in Pandas.
    c) Print the index and values of series.
    d) Print the first and last few rows from the series.
12. Experiment 12: Working with Data Frame Rows
    a) Slicing Data Frame using loc and iloc.
    b) Filter multiple rows using isin.
    c) Select first n rows and last n rows.
    d) Select rows randomly n rows and fractions of rows (use df. sample method).
    e) Count the number of rows with each unique value of variables.
    f) Select alargest and nsmallest values.
    g) Order/sort the rows.
13. Experiment 13: Merge and combine data
    a) Perform the append, concat and combine first operations on Data Frames.
    b) Apply different types of merge on data.
    c) Use a query method to filter Data Frame with multiple conditions.

Internship – I

Duration: 2 Weeks (2 Credits)

Internship I Guidelines:

Internship I is of a minimum duration of two weeks which can be completed in an Industry/Institute in consultation with concerned Engineering College/Institute. After completion of Internship a detailed report of the Internship mentioning the training undertaken along with certificate should be submitted.