title: reading data from URL using spark databricks platform
body: <p>trying to read data from url using spark on databricks community edition platform
  i tried to use spark.read.csv and using SparkFiles but still, i am missing some simple point</p>
  
  <pre><code>url = "https://raw.githubusercontent.com/thomaspernet/data_csv_r/master/data/adult.csv"
  from pyspark import SparkFiles
  spark.sparkContext.addFile(url)
  # sc.addFile(url)
  # sqlContext = SQLContext(sc)
  # df = sqlContext.read.csv(SparkFiles.get("adult.csv"), header=True, inferSchema= True) 
  
  df = spark.read.csv(SparkFiles.get("adult.csv"), header=True, inferSchema= True)
  </code></pre>
  
  <p>got path related error:</p>
  
  <p><em><code>Path does not exist: dbfs:/local_disk0/spark-9f23ed57-133e-41d5-91b2-12555d641961/userFiles-d252b3ba-499c-42c9-be48-96358357fb75/adult.csv;'</code></em></p>
  
  <p>i also tried someother way </p>
  
  <pre><code>val content = scala.io.Source.fromURL("https://raw.githubusercontent.com/thomaspernet/data_csv_r/master/data/adult.csv").mkString
  
   # val list = content.split("\n").filter(_ != "")
     val rdd = sc.parallelize(content)
     val df = rdd.toDF
  
  SyntaxError: invalid syntax
    File "&lt;command-332010883169993&gt;", line 16
      val content = scala.io.Source.fromURL("https://raw.githubusercontent.com/thomaspernet/data_csv_r/master/data/adult.csv").mkString
                ^
  SyntaxError: invalid syntax
  </code></pre>
  
  <p>data should be loaded directly to databricks folder or i should be able load directly from url using spark.read, any suggestions</p>