Python Forum
Define a range, return all numbers of range that are NOT in csv data
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Define a range, return all numbers of range that are NOT in csv data
#3
I Suppose I d0nt know where to start with this kind of code.

I have built a part of script that asks the user to enter a number then return the row of that number within the csv file. I would like to put in the option for input to either search for a particular number and return the informaiton, or search for a range and return all numbers that are not included.

the code I have for the searching of a single number is

import csv
import codecs

# Open using dictReader
with open('AssignedLineURI.csv', 'rt') as AssignedLineURI:
    # Open file in UTF Codec
    csv_data = csv.DictReader(codecs.open('AssignedLineURI.csv', 'rU', 'utf-16', ),delimiter =';')

    # Input
    # Get Number in 10 digit format from input
    csenteredNumber = input("Enter User's Line Number in E164 Format: ")
    csLineURI = "tel:" + csenteredNumber + ";ext=" + csenteredNumber[-5:]
    # print(csLineURI)
    
    # Match Line URI to User
    for row in csv_data:
        if row['LineURI'] == csLineURI:
            print (row['DisplayName'] + " - " + row['SipAddress'] + " - " + row['DID'])
This will prompt input for a telephone number, search the csv, and return the fields specified in the row.

Im assuming to being my search of number not contained in the csv file, I would need to define a range, create a loop to search each number in the range and return if NOT in matching csv.
Reply


Messages In This Thread
RE: Define a range, return all numbers of range that are NOT in csv data - by KiNeMs - Dec-31-2019, 03:10 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How do I calculate a ratio from 2 numbers and return an equivalent list of about 1000 Pleiades 8 15,956 Jan-05-2024, 08:30 PM
Last Post: sgrey
  [SOLVED] [loop] Exclude ranges in… range? Winfried 2 1,653 May-14-2023, 04:29 PM
Last Post: Winfried
Thumbs Down I hate "List index out of range" Melen 20 3,624 May-14-2023, 06:43 AM
Last Post: deanhystad
  How to check multiple columns value within range SamLiu 2 1,268 Mar-13-2023, 09:32 AM
Last Post: SamLiu
  Expand the range of a NumPy array? PythonNPC 0 829 Jan-31-2023, 02:41 AM
Last Post: PythonNPC
  Copying files if the name is in range tester_V 9 1,759 Nov-24-2022, 12:21 AM
Last Post: tester_V
Exclamation IndexError: Replacement index 2 out of range for positional args tuple - help? MrKnd94 2 6,882 Oct-14-2022, 09:57 PM
Last Post: MrKnd94
  Solving an equation by brute force within a range alexfrol86 3 2,961 Aug-09-2022, 09:44 AM
Last Post: Gribouillis
  IndexError: list index out of range dolac 4 2,026 Jul-25-2022, 03:42 PM
Last Post: deanhystad
  I'm getting a String index out of range error debian77 7 2,465 Jun-26-2022, 09:50 AM
Last Post: deanhystad

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020